Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
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