[jira] [Created] (HIVE-3979) Provide syntax for unescaped regex on rlike, and other regexp_* functions

["John Omernik (JIRA)" <ji...@apache.org>]

John Omernik created HIVE-3979:
----------------------------------

             Summary: Provide syntax for unescaped regex on rlike, and other regexp_* functions
                 Key: HIVE-3979
                 URL: https://issues.apache.org/jira/browse/HIVE-3979
             Project: Hive
          Issue Type: New Feature
          Components: UDF
    Affects Versions: 0.10.0
         Environment: All Queries, JDBC and cli 
            Reporter: John Omernik
             Fix For: 0.11.0


To make hive more intuitive, can we provide a syntax for hive functions that when encompassing a regex, that regex doesn't have to the standard hive double escape? For example

column rlike '\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}'
could become
column rlike '/\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}/'

In this case, just using PERL's regex brackets, but could be anything...

The point is to be able to take a standard JAVA/Perl type regex and cut and paste it into a query. This would allow for faster query development, more mainstream adoption by those with regex experience, and intuitive transition to hive query writing. 


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira