You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (JIRA)" <ji...@apache.org> on 2016/12/12 22:16:58 UTC
[jira] [Commented] (SPARK-18832) Spark SQL: Incorrect error message
on calling registered UDF.
[ https://issues.apache.org/jira/browse/SPARK-18832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15743324#comment-15743324 ]
Dongjoon Hyun commented on SPARK-18832:
---------------------------------------
Hi, [~roadster11].
Could you confirm that your Hive UDTF works well in Hive?
> Spark SQL: Incorrect error message on calling registered UDF.
> -------------------------------------------------------------
>
> Key: SPARK-18832
> URL: https://issues.apache.org/jira/browse/SPARK-18832
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0, 2.0.1, 2.0.2
> Reporter: Lokesh Yadav
>
> On calling a registered UDF in metastore from spark-sql CLI, it gives a generic error:
> Error in query: Undefined function: 'Sample_UDF'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'.
> The functions is registered and it shoes up in the list output by 'show functions'.
> I am using a Hive UDTF, registering it using the statement: create function Sample_UDF as 'com.udf.Sample_UDF' using JAR '/local/jar/path/containing/the/class';
> and I am calling the functions from spark-sql CLI as: SELECT Sample_UDF("input_1", "input_2" )
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org