/
sqoop
26 lines (10 loc) · 1.93 KB
/
sqoop
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
sqoop import --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --table AIRPORTS --username root --password hcluser --target-dir '/user/focus1/gaya/test/' --m 1
sqoop list-tables --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser
sqoop eval --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --query "SELECT * FROM AIRPORTS"
sqoop import --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --query "SELECT * FROM AIRPORTS where country='USA' AND \$CONDITIONS" --m 1 --delete-target-dir --target-dir '/user/focus1/gaya/test'
sqoop create-hive-table --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --table AIRPORTS
sqoop import --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --table AIRPORTS --hive-import --m 1
sqoop import --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --table AIRPORTS --query "select * from AIRPORTS where c1=1" --hive-import --hive-table gaya.AIRPORTS --m 1
sqoop export --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --username root --password hcluser --table AIRPORTS --export-dir /hive/warehouse/test/country=india/ --input-fields-terminated-by "\t"
sqoop import -m 1 --connect jdbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --table city_date --username root --password hcluser --incremental append --check-column sid --last-value 1
sqoop import -m 1 --connect dbc:mysql://cloudazure1.eastus2.cloudapp.azure.com:3306/mysql --table city_date --username hcluser --password hcluser --incremental lastmodified --check-column mdate --last-value ' 2019-04-22 12:00:40' --target-dir /user/focus1/city_date