topic Re: How Scenario to Migrating Table from MSSQL to Hive Cloudera? in Talend Studio

How Scenario to Migrating Table from MSSQL to Hive Cloudera?

Anonymous — Sat, 16 Nov 2024 06:01:46 GMT

Dear Masters,

I am newbie in Talend, I have a problems with migrating some tables with record data from MSSQL to Hive distribution Cloudera version CDH5.13.0 , on help website Talend I only found this

but i still have problems, If you have any suggestion and solution, please tell reply this messege

I'm attached my stuck scenario and metadata.

Regards,

Albar

Re: How Scenario to Migrating Table from MSSQL to Hive Cloudera?

manodwhb — Wed, 24 Apr 2019 05:18:50 GMT

@albarhp ,below link has illustrated that loading form RDBMS to hive. Please check the below link.

https://help.talend.com/reader/4V0c8kuEdmnsDYqE3rQEbw/wAUBsQq17yU4Kr4gApOn1w

Re: How Scenario to Migrating Table from MSSQL to Hive Cloudera?

Anonymous — Wed, 24 Apr 2019 05:40:16 GMT

I was look that link but my problem is The Flow must be creating a table and schema like source Database in this case using MSSQL

Re: How Scenario to Migrating Table from MSSQL to Hive Cloudera?

manodwhb — Wed, 24 Apr 2019 05:43:55 GMT

@albarhp ,if are you working with Enterprise Talend you can use dynamic schema option. are you using Talend enterprise software?