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

Reply via email to