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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[chabou19]

Hello,

any updates here?

Thanks.