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