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

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

Ok, it looks like the example I have requires '.*fn' as opposed to just '*fn'
Rather than adding the LIKE syntax, would you be able to update the function 
pattern matching to allow '\*' ? I think the SHOW TABLE has some code to 
substitute '\*' with '.*' when creating the pattern matcher, would you be able 
to do something like that for SHOW FUNCTION as well?


was (Author: jdere):
Ok, it looks like the example I have requires '.*fn' as opposed to just '*fn'
Rather than adding the LIKE syntax, would you be able to update the function 
pattern matching to allow '*'? I think the SHOW TABLE has some code to 
substitute '*' with '.*' when creating the pattern matcher, would you be able 
to do something like that for SHOW FUNCTION as well?

> 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