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