Unable to use "Where" clause in tHiveInput Query

Anonymous — Sat, 16 Nov 2024 10:08:02 GMT

Hi,
I am a newbie to both Talend and Hive.
I want to query the Hive table and output the data to csv file.
Created
1) tHiveConnection (I was able to connect to Hive Database)
2) tHiveInput (used the use existing connection and wrote the Query)
3) connected tHiveInput to tMap
4) connected tMap to tfileOutputDelimited
5) tHiveClose
in the point 2) when i write a query "select * from table_name" everything is working fine, I was able to collect the data in csv file
but when i change my query to "select * from table_name where column_name = value" it is failing
Below is the error log
Exception in component tHiveInput_1
java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:277)
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:376)
tHiveInput_1 Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

Re: Unable to use "Where" clause in tHiveInput Query

Anonymous — Fri, 10 Feb 2017 07:27:15 GMT

Hi,
Can you run the same query on the Hive Query Editorsuccesfully? Could you please indicate what's the build version you are using? Screenshot of thiveinput component setting will be preferred.
Best regards
Sabrina

topic Re: Unable to use "Where" clause in tHiveInput Query in Talend Studio

Unable to use "Where" clause in tHiveInput Query

Re: Unable to use "Where" clause in tHiveInput Query