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