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

Jacques Nadeau updated DRILL-1124:
----------------------------------

    Component/s:     (was: Client - CLI)
                 Metadata
       Priority: Minor  (was: Major)
        Summary: Expose the list of functions (including udf/udaf) in another 
system or metadata table (including signature)  (was: Add a command to sqlline 
to list registered UDFs and UDAFs with their signature)

> Expose the list of functions (including udf/udaf) in another system or 
> metadata table (including signature)
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1124
>                 URL: https://issues.apache.org/jira/browse/DRILL-1124
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Metadata
>    Affects Versions: 1.0.0-milestone-1
>            Reporter: Abhinav C
>            Priority: Minor
>
> A UDF source jar and binaries are successfully registered by the Drillbit but 
> when the UDF is called, it throws EigenbaseContextException.
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while 
> running query.[error_id: "f80cd899-983c-4af7-8c3e-86616294a2e6"
> endpoint {
>  address: "ubuntu3.maprtech.com"
>  user_port: 31010
>  control_port: 31011
>  data_port: 31012
> }
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[ 
> org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 
> 1, column 19 ] < EigenbaseContextException:[ From line 1, column 8 to line 1, 
> column 19 ] < SqlValidatorException:[ No match found for function signature 
> mode(<ANY>) ]"
> ]
> Error: exception while executing query (state=,code=0)
> It will be helpful to add a command to list UDFs and UDAFs that Drillbits are 
> aware of.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to