impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sthitaprajna Sahoo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IMPALA-3970) UDFs created in hive with database prefix with '.' in the name are not loadable by impala
Date Fri, 17 Mar 2017 20:24:41 GMT

    [ https://issues.apache.org/jira/browse/IMPALA-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15930649#comment-15930649
] 

Sthitaprajna Sahoo commented on IMPALA-3970:
--------------------------------------------

Does anyone know if there is a jira opened for this issue on hive ? Looks like its an issue
that must be resolved in order to use fully qualified function name.

> UDFs created in hive with database prefix with '.' in the name are not loadable by impala
> -----------------------------------------------------------------------------------------
>
>                 Key: IMPALA-3970
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3970
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog
>    Affects Versions: Impala 2.2.4
>            Reporter: Mala Chikka Kempanna
>              Labels: ramp-up, usability
>
> Steps to reproduce the issue.
> On hive:
> Step1. CREATE FUNCTION default.listtostring AS 'com.matthewrathbone.example.SimpleUDFExample'
USING JAR 'hdfs:///user/hive/warehouse/myudf.jar';
> Step2.
>  create view testview as select default.listtostring(code) from sample_07;
> Ste3.
> select * from testview;
> -> This retuns with results as expected.
> On impala
> Step4.
> invalidate metadata;
> Step5.
> show functions;
> Query: show functions
> +-------------+----------------------+-------------+---------------+
> | return type | signature            | binary type | is persistent |
> +-------------+----------------------+-------------+---------------+
> | STRING      | listtostring(STRING) | JAVA        | true          |
> +-------------+----------------------+-------------+---------------+
> Step6.
>  select * from testview;
> Query: select * from testview
> ERROR: AnalysisException: Function names must be all alphanumeric or underscore. Invalid
name: default.listtostring



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message