topic Re: component to be used to load the data into hive table. in Talend Studio

component to be used to load the data into hive table.

Anonymous — Sat, 16 Nov 2024 09:52:43 GMT

hi all,

can anyone say the exact component to be used to load the data into hive table, if am using remote hdfs server.

I tried it using the thive load component but its giving the following error.

Re: component to be used to load the data into hive table.

Anonymous — Mon, 24 Apr 2017 09:50:20 GMT

Hi,

Could you please share a bit more information ? What's the configuration of your component? On which talend build version you got this issue? Can you execute the same command successfully from hive client?

Best regards

Sabrina

Re: component to be used to load the data into hive table.

Anonymous — Mon, 24 Apr 2017 14:25:02 GMT

hi,

yeah tried the same load using the hive client and it is giving the same error

Re: component to be used to load the data into hive table.

Anonymous — Mon, 24 Apr 2017 14:25:55 GMT

the version am using is

TOS_BD-20161216_1026-V6.3.1

Re: component to be used to load the data into hive table.

Anonymous — Tue, 25 Apr 2017 04:28:33 GMT

Hi,

Have you already given "hive" user permission on the root folder you load the file from?

Are you trying to load one file from your local machine to hive table? Make sure the file has to be either in HDFS or the file system of your Hadoop cluster (i.e named node).

Best regards

Sabrina

Re: component to be used to load the data into hive table.

Anonymous — Tue, 25 Apr 2017 10:55:57 GMT

yeah the prob was the file was not in hdfs , we put that in hdfs and tried, the job got run but the data not loaded into the target file.

am attaching the contents loaded int the target table.

Re: component to be used to load the data into hive table.

Anonymous — Tue, 25 Apr 2017 11:02:53 GMT

Hi Srikanth,

Is there any error message printed on console when you execute your job in talend studio? Any security setting? Are you able to load data into hive?

Best regards

Sabrina

Re: component to be used to load the data into hive table.

Anonymous — Tue, 25 Apr 2017 11:31:21 GMT

hi sabrina,

i dint get any error

and are u asking me to load into hive table from command line??

i dint try it, will check it .

Re: component to be used to load the data into hive table.

Anonymous — Tue, 25 Apr 2017 11:44:55 GMT

hi sabrina,

the other thing is whwn the data is kept in edge node and tried giving that path,checking the local box, its giving error,

am attaching the images