[
https://issues.apache.org/jira/browse/HIVE-8094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14155357#comment-14155357
]
Thejas M Nair commented on HIVE-8094:
-------------------------------------
I didn't realize that show tables had LIKE as an optional keyword.
In terms of backward compatiblity , it looks like the case where user hits this
issue is going be rare. If user had "foo.*" , now it gets translated into
"foo..*" . Ie it would still match function "fooabc" but stop matching "fooa" .
Is that right [~peter_liu] ? Ie the test cases that were removed in the initial
patches don't need to be removed.
The probability of a user using 'show functions' in a script and also hitting
this use case seems quite low.
ie, I am leaning towards Jason's suggestion of changing the behavior of
existing show-functions syntax as well. Sorry about the back and forth on this
Peter!
> 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)
