Extracting table from Mysql to hive using talend

[Anonymous]

Hi,
I want to extract a table from mysql to hive using talend (big data studio)....
Can anyone guide me how to do that???

[Anonymous]

Hi,
You can use sqoop to import mysql table into hdfs firstly then using TalendHelpCenter:thiveload to write data into hive table.
Best regards
Sabrina

[Anonymous]

Thanks.

[Anonymous]

Hi seemi,
Is it working for you? Feel free to post your issue on forum.
Best regards
Sabrina

[Anonymous]

Hi.... I am able to extract tables to & from hdfs & mysql using sqoop, but the extraction is not in a table fromat from mysql to hive... I need help here...

& is there any other way to do this?? Coz... Talend is itself an ETL... (so I want to use its capablities to extract data using some mappings or anything else which is available .....

[Anonymous]

Hi,

Hi.... I am able to extract tables to & from hdfs & mysql using sqoop, but the extraction is not in a table fromat from mysql to hive... I need help here...

What's the actual result? Could you please upload the screenshots with us?
Best regards
Sabrina

[Anonymous]

Hi,

Hi.... I am able to extract tables to & from hdfs & mysql using sqoop, but the extraction is not in a table fromat from mysql to hive... I need help here...

What's the actual result? Could you please upload the screenshots with us?
Best regards
Sabrina

Hi Sabrina,
Attathced is the screen shot...
I have loaded the data into mysql... Now I want to load the same mysql table into hive without using sqoop.... Plz help me out...
Regards,
Seemi.

[Anonymous]

Hi,
It seems your screenshots are missing.
Pay more attention on limitation of Image Upload Section:20 images per post, each image must be less then 1024x768 pixels and 200 KB, png is preferred.

I have loaded the data into mysql... Now I want to load the same mysql table into hive without using sqoop.

Actually, you cannot load data from mysql to hive directly.
You could try tmysqlinput==>thdfsoutput then thiveload
Best regards
Sabrina

[Anonymous]

Hi,
It seems your screenshots are missing.
Pay more attention on limitation of Image Upload Section:20 images per post, each image must be less then 1024x768 pixels and 200 KB, png is preferred.

I have loaded the data into mysql... Now I want to load the same mysql table into hive without using sqoop.

Actually, you cannot load data from mysql to hive directly.
You could try tmysqlinput==>thdfsoutput then thiveload
Best regards
Sabrina

Hi,
I mable to extract my table from mysql to hdfs... but it is creating an empty table in hive... plz guide...

[Anonymous]

Can anyone tell me what does the following error means???

Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask