Sql to Cdp Data Migration

2 replies
2555 views
Translate All

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

rrrajeshAnswer

Gold ⭐️⭐️

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

rrrajeshAnswer

Gold ⭐️⭐️

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

Translate

Amn_468Author

Silver ⭐️⭐️⭐️

@rrrajesh Thanks 😊

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.