Monday, 10 December 2018

SQOOP Eval and List

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

No comments:

Post a Comment

Flume - Simple Demo

// create a folder in hdfs : $ hdfs dfs -mkdir /user/flumeExa // Create a shell script which generates : Hadoop in real world <n>...