RapidMiner Wisdom Banner

Error hive execution

sebastian_gonzasebastian_gonza RapidMiner Certified Analyst, Member Posts: 52  Guru
edited June 2019 in Help


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





  • phellingerphellinger Employee, Member Posts: 90   RM Engineering



    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,


Sign In or Register to comment.