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)
-
Input file: emp.csv ---------------- empno,ename,designation,manager,hire_date,sal,deptno 7788,SCOTT,ANALYST,7566,12/9/1982,3000,20 73... -
Import data from MySQL to HDFS using SQOOP with conditional data importing //Conditional import using Where sqoop import \ -connect jdbc:m...
-
$ hive // Display all the databases available in Hive hive> show databases; OK default ohm hive>create database if not exists testdb; ...
No comments:
Post a Comment