MySql to Hive

Anonymous · ‎2019-05-27

I am trying to insert mysql records into Hive.

I did created metadata connetions to My Hadoop cluster and hive connected successfully.

I am using Big Data open studio 7.1 version.

I am facing problem to insert records into hive.

I cant find tHiveOutput in my pallete.

I did tried tMySqlInput --> tHiveRow

and i used below conf for tHiverow

it throws error as

Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 6:5 Table not found 'EmpData'

Where i already created table in hive db.

I am really confused how to use hive in talend.

Theres no proper documentation for what component need to be used to import data into hive.

Someone says use thiverow as thiveoutput is not available.

and how to create connection between tHivecreatetable to tHiverow, where if i want to create table in talend job itself.

Can anyone please clear my confusions.

Regards,

Mohan V

vapukov · ‎2019-05-27

Hi,

why just not check examples which coming with Studio?

btw, one of the logics could be:

or you can use sqoop