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

David Mollitor commented on HIVE-23243:
---------------------------------------

+1 on [^HIVE-23243.01.patch] pending tests

 

Spoke with [~mgergely] directly.  We will go with this option for now, but 
there should be another Jira created to improve this.

 

This patch loses the benefit of the current setup in that the wildcard is not 
passed all the way down to the RDBMS (as it is now), but instead it requests an 
entire list of Databases and then filters at HS2 level.  It would be nice if 
this filter could also be pushed all the way down to the RDBMS, however, the 
current HMS API only allows the simple use case of having a '*' in the lookup, 
probably to support this feature.  There is currently no easy (or accurate) way 
to map the SQL wildcard syntax to this simplified wildcard setup.  HMS needs a 
more robust, fully featured, capability to generate a list of databases based 
on SQL wild card semantics.

> Accept SQL type like pattern for Show Databases
> -----------------------------------------------
>
>                 Key: HIVE-23243
>                 URL: https://issues.apache.org/jira/browse/HIVE-23243
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Miklos Gergely
>            Assignee: Miklos Gergely
>            Priority: Minor
>         Attachments: HIVE-23243.01.patch
>
>
> Show Databases pattern accepts java like pattern with * and ., use SQL like 
> instead with % and _.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to