Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 29 Sep 2014 22:10:34 +0000 (UTC)
From: "Jason Dere (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12741305.1410672623000.149576.1412028634350@Atlassian.JIRA>
In-Reply-To: <JIRA.12741305.1410672623000@Atlassian.JIRA>
References: <JIRA.12741305.1410672623000@Atlassian.JIRA>
 <JIRA.12741305.1410672623987@arcas>
Subject: [jira] [Commented] (HIVE-8094) add LIKE keyword support for SHOW
 FUNCTIONS
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Jason Dere commented on HIVE-8094:
----------------------------------

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)