Error hive execution

sebastian_gonza
sebastian_gonza New Altair Community Member
edited November 5 in Community Q&A

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

Tagged:

Answers

  • phellinger
    phellinger New Altair Community Member

    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

Categories