One Star

Unable to use "Where" clause in tHiveInput Query

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
1 REPLY
Moderator

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

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.