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

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

[~mgergely] Ya, I don't know what the right move is...  I think from an API 
perspective, it's best to pass around a {{Pattern}} object.  But if HMS wants 
to push the filter all the way down to the RDBMS, it would have to convert it 
back to a SQL-style expression.  It's probably best to start with the HMS doing 
a {{SELECT *}} and filtering with the Pattern object.  It would allow for full 
Regex and it be universally supported across all RDBMS.  If that's too slow, 
there can be further consideration to push it all the way down to the RDBMS.

> 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