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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

hi,

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

[Anonymous]

the version am using is 

TOS_BD-20161216_1026-V6.3.1

[Anonymous]

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

[Anonymous]

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. 

[Anonymous]

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

[Anonymous]

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 .

[Anonymous]

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