[ https://issues.apache.org/jira/browse/HIVE-12417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15008159#comment-15008159 ]
Olaf Flebbe commented on HIVE-12417: ------------------------------------ Oops, the negation operator is broken now, somehow. Canceling patch > 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 > Attachments: HIVE-12417.1.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)