[ 
https://issues.apache.org/jira/browse/SPARK-11948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Weizhong updated SPARK-11948:
-----------------------------
    Description: 
We create a function,
{noformat}
add jar /home/test/smartcare-udf-0.0.1-SNAPSHOT.jar;
create function arr_equals as 'smartcare.dac.hive.udf.UDFArrayGreaterEqual';
{noformat}
 but "show functions" don't display, and when we create the same function 
again, it throw exception as below:
{noformat}
Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: 
Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.FunctionTask. 
AlreadyExistsException(message:Function arr_greater_equal33 already exists) 
(state=,code=0)
{noformat}
But if we use this function, it throw exception as below:
{noformat}
Error: org.apache.spark.sql.AnalysisException: undefined function 
arr_greater_equal33; line 1 pos 119 (state=,code=0)
{noformat}

  was:
We create a function, but "show functions" don't display, and when we create 
the same function again, it throw exception as below:
{noformat}
Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: 
Execution Error, return code 1 from 
org.apache.hadoop.hive.ql.exec.FunctionTask. 
AlreadyExistsException(message:Function arr_greater_equal33 already exists) 
(state=,code=0)
{noformat}
But if we use this function, it throw exception as below:
{noformat}
Error: org.apache.spark.sql.AnalysisException: undefined function 
arr_greater_equal33; line 1 pos 119 (state=,code=0)
{noformat}


> UDF not work
> ------------
>
>                 Key: SPARK-11948
>                 URL: https://issues.apache.org/jira/browse/SPARK-11948
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.5.1
>            Reporter: Weizhong
>            Priority: Minor
>
> We create a function,
> {noformat}
> add jar /home/test/smartcare-udf-0.0.1-SNAPSHOT.jar;
> create function arr_equals as 'smartcare.dac.hive.udf.UDFArrayGreaterEqual';
> {noformat}
>  but "show functions" don't display, and when we create the same function 
> again, it throw exception as below:
> {noformat}
> Error: org.apache.spark.sql.execution.QueryExecutionException: FAILED: 
> Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.FunctionTask. 
> AlreadyExistsException(message:Function arr_greater_equal33 already exists) 
> (state=,code=0)
> {noformat}
> But if we use this function, it throw exception as below:
> {noformat}
> Error: org.apache.spark.sql.AnalysisException: undefined function 
> arr_greater_equal33; line 1 pos 119 (state=,code=0)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to