[jira] [Updated] (HIVE-12417) Support for exclamation mark missing in regexp

["Olaf Flebbe (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-12417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Olaf Flebbe updated HIVE-12417:
-------------------------------
    Attachment: HIVE-12417.1.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)