eval:
select query:
sqoop eval --connect jdbc:mysql://localhost/sara --username=root --password=cloudera --query "select * from employee"
insert query"
sqoop eval --connect jdbc:mysql://localhost/sara --username=root --password=cloudera --query "INSERT INTO employee values(1207,'Mahan','UI Dev',15000,'TP')"
list databases:
sqoop list-databases --connect jdbc:mysql://localhost --username root --password cloudera
sqoop list-databases --connect jdbc:mysql://localhost --username root --password cloudera
Subscribe to:
Post Comments (Atom)
-
Import data from MySQL to HDFS using SQOOP with conditional data importing //Conditional import using Where sqoop import \ -connect jdbc:m...
-
// How to add auto generated column Index to existing dataframe? scala> import org.apache.spark.sql.functions._ import org.apache.spark.s...
-
Input file: emp.csv ---------------- empno,ename,designation,manager,hire_date,sal,deptno 7788,SCOTT,ANALYST,7566,12/9/1982,3000,20 73...
No comments:
Post a Comment