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

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

Olaf Flebbe created HIVE-12417:
----------------------------------

             Summary: 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


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)