Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Error hive execution

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

Find more posts tagged with

AI Studio

AI Studio Radoop

Errors

Accepted answers

All comments

phellinger

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