topic tELTHiveOutput component's INSERT(append) functionality is not working in Talend Studio

tELTHiveOutput component's INSERT(append) functionality is not working

Anonymous — Tue, 08 Jul 2014 12:35:48 GMT

Hi,
When I tried to use tELTHiveOutput component to append data in an existing table, I am not getting the desired output.
The component is deleting the corresponding HDFS file data before loading the new data into it.
I verified the logs and I could see that the syntax (if I select INSERT operation) is INSERT INTO TABLE which is the right syntax.
I am not sure which part of the component is deleting the data before loading.
I could see the append happening with the same query , if I run it using tHiveRow component.
Could you please help me to resolve this issue ?

Thanks,
Saravana

Re: tELTHiveOutput component's INSERT(append) functionality is not working

Anonymous — Wed, 09 Jul 2014 09:52:18 GMT

Hi,
Have you checked component reference TalendHelpCenter:tELTHiveOutput?
Did you use tELTHiveMap and tELTHiveInput / tELTHiveOutput in your job design? Would you mind uploading your current job design screenshot into forum?
Best regards
Sabrina

Re: tELTHiveOutput component's INSERT(append) functionality is not working

Anonymous — Wed, 09 Jul 2014 13:41:33 GMT

Hi Sabrina,
I have verified the component reference. And below is property of the tELTHiveOutput component which I mentioned earlier.
"
Action on data :
Select the action to be performed on the data to be written in the Hive table.
With the Insert option, the data to be written in the Hive table will be appended to the existing data if there is any
"
I do have tELTHiveInput and tELTHiveMap component in my job and I have attached the screen shots of my job as well as the component in which I am facing issue.
Thanks,
Saravana

Re: tELTHiveOutput component's INSERT(append) functionality is not working

chabou19 — Wed, 26 Feb 2025 10:46:06 GMT

Hello,

any updates here?

Thanks.