从sql server导出数据到hdfs

sqoop import –connect ‘jdbc:sqlserver://192.168.20.105:1433;databasename=dep’ –username sa –password server2008! –table test_table –fields-terminated-by ‘\001’ –target-dir /user/hive/warehouse/sqlserverdb/wht_v2 -m 1

从sql server导出数据到hive

sqoop import –hive-import –connect ‘jdbc:sqlserver://192.168.20.105:1433;databasename=dep’ –username sa –password server2008! –table data_dictonary_test –hive-database db2db –hive-table ata_dictonary_test –fields-terminated-by ‘\001’ –hive-overwrite -m 1