getting error in tELTHiveMap

One Star

getting error in tELTHiveMap

Hi,
I am using HiveInput, HiveMap and HiveOutput components.
my data is stored in S3. I am able to execute the insertion query from Hive prompt and its working fine.
I am able to create tables in Hive using Talend but when I am trying to insert records in table I am getting below error.
please help me to solve the problem.
Exception in component tELTHiveOutput_1
java.sql.SQLException: Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127)
at talendold.test_map_0_1.test_Map.tELTHiveMap_1Process(test_Map.java:372)
at talendold.test_map_0_1.test_Map.runJobInTOS(test_Map.java:611)
at talendold.test_map_0_1.test_Map.main(test_Map.java:477)
thanks in advance.
Regards
Abhishek
Moderator

Re: getting error in tELTHiveMap

Hi,
Exception in component tELTHiveOutput_1
java.sql.SQLException: Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:189)
at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127)
at talendold.test_map_0_1.test_Map.tELTHiveMap_1Process(test_Map.java:372)
at talendold.test_map_0_1.test_Map.runJobInTOS(test_Map.java:611)
at talendold.test_map_0_1.test_Map.main(test_Map.java:477)

Is there any more error log info for this issue? Go to <Talend Studio installation path>/workspace/.metadata/.log.
Could you give us your component setting screenshot? What's the query of tHiveinput? Insert OVERWRITE partition?
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.
Employee

Re: getting error in tELTHiveMap

Hello,
Which kind of connection do you use? Embedded? Standalone? Which distribution are uou working with?
Rémy.
Three Stars

Re: getting error in tELTHiveMap

Hi,
I am using HiveInput, HiveMap and HiveOutput components.
 when I am trying to insert records in table I am getting below error.
please help me to solve the problem.
Exception in component tELTHiveOutput_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:279)
at demos.dataversion_0_1.DataVersion.tELTHiveMap_1Process(DataVersion.java:455)
at demos.dataversion_0_1.DataVersion.runJobInTOS(DataVersion.java:756)
at demos.dataversion_0_1.DataVersion.main(DataVersion.java:613)
Regards
Rahul N