[
https://issues.apache.org/jira/browse/HIVE-12417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15028241#comment-15028241
]
Lefty Leverenz commented on HIVE-12417:
---------------------------------------
Okay, thanks [~oflebbe].
> Support for exclamation mark missing in regexp
> ----------------------------------------------
>
> Key: HIVE-12417
> URL: https://issues.apache.org/jira/browse/HIVE-12417
> Project: Hive
> Issue Type: Bug
> Affects Versions: 1.2.1
> Reporter: Olaf Flebbe
> Assignee: Olaf Flebbe
> Fix For: 1.3.0, 2.0.0
>
> Attachments: HIVE-12417.1.patch, HIVE-12417.2.patch
>
>
> with HIVE-6013 gets support for regular expressions. However, die ! character
> is valid, too. It is needed for expressions like
> {code}
> set hive.support.quoted.identifiers = none;
> select `^(?!donotuseme).*$` from table;
> {code}
> which is the idiom to select all but column {{donotuseme}} .
> See http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html for
> a reference of supported chars in Java regexp.
> The patch simply fixes the lexer to support '!' as REGEX char. And does
> simply work.
> Please review.
> If you like to have an iTest for it, I beg you to help me. I tried several
> days on a different issue to figure out how it is supposed to work and failed
> miserably.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
