hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-8094) add LIKE keyword support for SHOW FUNCTIONS
Date Mon, 29 Sep 2014 22:23:34 GMT

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

Thejas M Nair edited comment on HIVE-8094 at 9/29/14 10:23 PM:
---------------------------------------------------------------

[~jdere] Thanks for your comments. Actually, this patch does exactly what you asked for: make
the SHOW FUNCTIONS LIKE pattern work in the same way as SHOW TABLE. You can see I substitute
'\*' with '.\*' from the code review. 

Another difference from 'SHOW FUNCTIONS [pattern]' is, 'SHOW FUNCTIONS LIKE [pattern]' will
also search the functions which have been registered on metastore, which could fix the bug
that 'SHOW FUNCTIONS [pattern]' couldn't list the functions registered on metastore.


was (Author: peter_liu):
[~jdere] Thanks for your comments. Actually, this patch does exactly what you asked for: make
the SHOW FUNCTIONS LIKE pattern work in the same way as SHOW TABLE. You can see I substitute
'*' with '.*' from the code review. 

Another difference from 'SHOW FUNCTIONS [pattern]' is, 'SHOW FUNCTIONS LIKE [pattern]' will
also search the functions which have been registered on metastore, which could fix the bug
that 'SHOW FUNCTIONS [pattern]' couldn't list the functions registered on metastore.

> add LIKE keyword support for SHOW FUNCTIONS
> -------------------------------------------
>
>                 Key: HIVE-8094
>                 URL: https://issues.apache.org/jira/browse/HIVE-8094
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 0.14.0, 0.13.1
>            Reporter: peter liu
>            Assignee: peter liu
>             Fix For: 0.14.0
>
>         Attachments: HIVE-8094.1.patch, HIVE-8094.2.patch, HIVE-8094.3.patch
>
>
> It would be nice to  add LIKE keyword support for SHOW FUNCTIONS as below, and keep the
patterns consistent to the way as SHOW DATABASES, SHOW TABLES.
> bq. SHOW FUNCTIONS LIKE 'foo*';



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

Mime
View raw message