Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive HPLSQL Error evaluating hplsql

Highlighted

Hive HPLSQL Error evaluating hplsql

New Contributor

Currently we are in process of migrating the Oracle Functions to Hive using HPLSQL. Is there any alternate way/programming language to move the Oracle functions and create in Hive 2.0 or later versions.

Currently i am getting below issue:

Logging initialized using configuration in file:/etc/hive/conf.dist/hive-log4j2.properties Async: false

hive> ADD JAR /home/hadoop/antlr4-runtime-4.5.jar; Added [/home/hadoop/antlr4-runtime-4.5.jar] to class path Added resources:

[/home/hadoop/antlr4-runtime-4.5.jar] hive> ADD JAR /home/hadoop/hive-hplsql-2.0.0.jar; Added [/home/hadoop/hive-hplsql-2.0.0.jar] to class path Added resources: [/home/hadoop/hive-hplsql-2.0.0.jar]

hive> ADD JAR /usr/lib/hive/lib/hive-hplsql-2.1.1-amzn-0.jar; Added [/usr/lib/hive/lib/hive-hplsql-2.1.1-amzn-0.jar] to class path Added resources: [/usr/lib/hive/lib/hive-hplsql-2.1.1-amzn-0.jar]

hive> SELECT hplsql('hello(:1)', fname) FROM eeatest.namecheck; FAILED: SemanticException [Error 10011]: Invalid function

hplsql hive> CREATE TEMPORARY FUNCTION hplsql AS 'org.apache.hive.hplsql.Udf'; OK Time taken: 0.048 seconds

hive> SELECT hplsql('hello(:1)', fname) FROM eeatest.namecheck; OK Configuration file: jar:file:/usr/lib/hive/lib/hive-hplsql-2.1.1-amzn-0.jar!/hplsql-site.xml Parser tree: (program (block (stmt (expr_stmt (expr (expr_func (ident hello) ( (expr_func_params (func_param (expr (expr_atom (ident :1))))) )))))))

INLCUDE CONTENT hplsqlrc (non-empty)

Ln:1 CREATE FUNCTION hello

Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: Error evaluating hplsql Time taken: 2.55 seconds

Don't have an account?
Coming from Hortonworks? Activate your account here