beeswax can't support permanent UDF query

[晓格]

i create permanent udf in hive, which can be used by hive metastore and hive servers.

i create udf as below:
add jar hdfs://test.jar;
CREATE FUNCTION test AS 'com.Test' USING JAR 'hdfs://test.jar';

but the function test can't be found by hue

but when i submit sql in hue, it shows that "Error while compiling statement: FAILED: SemanticException [Error 10011]: ....."

can hue support permanent udf?

[Romain Rigaux]

Where did you put

add jar hdfs://test.jar;
CREATE FUNCTION test AS 'com.Test' USING JAR 'hdfs://test.jar';

?

It should probably be set as a HiveServer2 property to be available to all the Hive users?
https://issues.apache.org/jira/browse/HIVE-5160

--
You received this message because you are subscribed to the Google Groups "Hue-Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hue-user+u...@cloudera.org.

[晓格]

i add permanent udf by hive command once, so that hive client can use this function.

i run beeline, which can find the function i created, but hue can't find this function.

i fix it temporary by add jar in hive-site.xml

<property>

    <name>hive.aux.jars.path</name>

    <value>file:///test.jar</value>

  </property>

Thanks

在 2016年4月8日星期五 UTC+8上午12:01:07，Romain Rigaux写道：