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.
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?
yeah tried the same load using the hive client and it is giving the same error
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).
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.
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?
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 .
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