Monday, November 2, 2015

SQOOP - Auto transfer DB from SQL Server to Hive

sqoop import-all-tables -m 1 --connect "jdbc:sqlserver://111.222.33.99:1433;database=AdventureWorksDW" --username xxxxx--password xxx--compression-codec=snappy --as-parquetfile --warehouse-dir=/user/hive/warehouse/xxx.db --hive-import --hive-database xxxxxxxx


Just one amazing command!

No comments:

Post a Comment