https://community.qlik.com/t5/Talend-Studio/two-hive-tables-Join-not-working-using-tELTHiveMap-component/m-p/2244204#M30433 Hi Jayateerth, <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>just to test, if there is any connectivity issue, I changed the output table name and gave a table name which is not present in the DB. The moment I do this the job fails with the error. This means there is no connection issue . Also the join query which is generated in tELTHiveMap looks correct. I ran the query through command line and it runs absolutely fine. Can you please let me know what could be reason the job goes into running state. I have to personally click on "Kill" button to come out of it.</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Could you please upload your job setting screenshots into forum which will be helpful for us to address this issue? <BR />Best regards <BR />Sabrina Sat, 10 Oct 2015 04:27:40 GMT Anonymous 2015-10-10T04:27:40Z https://community.qlik.com/t5/Talend-Studio/two-hive-tables-Join-not-working-using-tELTHiveMap-component/m-p/2244203#M30432 Hi Team, <BR />I am trying to use ELT components to join to Hive tables using tELTHiveMap and load into another Hive table using tELTHiveOutput. When I run the job, the job just goes on without giving any error/warning. There are no errors or warnings in the job. <BR />Just to test, if there is any connectivity issue, I changed the output table name and gave a table name which is not present in the DB. The moment I do this the job fails with the error. This means there is no connection issue . Also the join query which is generated in tELTHiveMap looks correct. I ran the query through command line and it runs absolutely fine. Can you please let me know what could be reason the job goes into running state. I have to personally click on "Kill" button to come out of it. <BR />Appreciate your response. <BR />Please note: I am using Talend Open Studio for BIGDATA version 6.0.1. <BR />Thanks! Sat, 16 Nov 2024 11:00:15 GMT https://community.qlik.com/t5/Talend-Studio/two-hive-tables-Join-not-working-using-tELTHiveMap-component/m-p/2244203#M30432 Anonymous 2024-11-16T11:00:15Z https://community.qlik.com/t5/Talend-Studio/two-hive-tables-Join-not-working-using-tELTHiveMap-component/m-p/2244204#M30433 Hi Jayateerth, <BR /> <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>just to test, if there is any connectivity issue, I changed the output table name and gave a table name which is not present in the DB. The moment I do this the job fails with the error. This means there is no connection issue . Also the join query which is generated in tELTHiveMap looks correct. I ran the query through command line and it runs absolutely fine. Can you please let me know what could be reason the job goes into running state. I have to personally click on "Kill" button to come out of it.</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Could you please upload your job setting screenshots into forum which will be helpful for us to address this issue? <BR />Best regards <BR />Sabrina Sat, 10 Oct 2015 04:27:40 GMT https://community.qlik.com/t5/Talend-Studio/two-hive-tables-Join-not-working-using-tELTHiveMap-component/m-p/2244204#M30433 Anonymous 2015-10-10T04:27:40Z