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] [Commented] (HIVE-8094) add LIKE keyword support for SHOW FUNCTIONS
Date Wed, 01 Oct 2014 19:38:34 GMT

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

Mime
View raw message