[
https://issues.apache.org/jira/browse/HIVE-23243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17087944#comment-17087944
]
David Mollitor commented on HIVE-23243:
---------------------------------------
Ya, I took a look at:
https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/udf/UDFLike.java#L64
It generates a pretty complicated {{Pattern}} and I'm not sure why, but it
generates a Regex and that is not compatible with DataNucleaus.
{quote}
Only the following regular expression patterns are required to be supported and
are portable: global “(?i)” for case-insensitive matches; and “.” and “.*” for
wild card matches. The pattern passed to matches must be a literal or parameter.
{quote}
http://www.datanucleus.org/products/accessplatform/jdo/query.html
I would rather see you change this {{UDFLike}} method to generate something
that is DN-friendly or create a new method and continue to use the
{{getDatabasesByPattern}} instead of making a new code path.
> 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)
