Sql to Cdp Data Migration

[#1]

Hi,

We are looking to migrate our data from SQL server to CDP environment and would like some insights on getting this done. Would appreciate any help/guidance in the same.

Thanks 

Amn

[#2 · Accepted solution]

Follow these docs

https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/migrating-data-into-hive/topics/hive_moving_d...

Command example:-

Import from SQL Server to Hadoop

sqoop import -Dmapreduce.job.queuename=<yourqueur> --connect "jdbc:sqlserver://<sqlserverhost>:<sqlserver port>;database=<sqlserver database>;username=<sqlserver user>;password=<sqlserver password>" --table "<sqlserver table>" -- --schema <sqlserver schema> -m 1 --hive-import --hive-database "<hive database>" --hive-table "<hive table>" --hive-overwrite --direct

[#3]

@rrrajesh Thanks 😊