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

peter liu commented on HIVE-8094:
---------------------------------

[~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)

Reply via email to