The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Error hive execution
sebastian_gonza
RapidMiner Certified Analyst, Member Posts: 52 
Guru
hi
I am getting this error while transforming nominal "numerical values" into only numerical, someone knows how to fix it?
Message: org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:1 validation error detected: Value 'SELECT CASE `radoop__tmp_hadoop_1527779946347_xfycxhu`.`duracion` WHEN '-81828' THEN 1 ELSE 0 END AS `duracion__81828`, CASE `radoop__tmp_hadoop_1527779946347_xfycxhu`.`duracion` WHEN '-81840' THEN 1 ELSE 0 END AS `duracion__81840`, CASE `radoop__tmp_hadoop_1527779946347_xfycxhu`.`duracion` WHEN '3802' THEN 1 ELSE 0 END AS `duracion_3802`, CASE
etc.....
0
Answers
Hi,
unfortunately, Hive does not return more information via JDBC when there is a "Execution Error, return code..." type of error.
You need to log into the cluster node that runs HiveServer2, and check its log, typically inside /var/log/hive directory. You can search for this message, and usually a more helpful error message precedes or follows it.
I hope this helps,
Peter