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
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.