question Sql to Cdp Data Migration in Support Questions

Sql to Cdp Data Migration

Amn_468 — Tue, 21 Apr 2026 07:16:27 GMT

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

Re: Sql to Cdp Data Migration

rrrajesh — Tue, 11 Apr 2023 14:41:19 GMT

Follow these docs

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

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

Re: Sql to Cdp Data Migration

Amn_468 — Wed, 12 Apr 2023 05:36:56 GMT

@rrrajesh Thanks 😊