hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Hassold (JIRA)" <>
Subject [jira] [Updated] (HIVE-1740) support NOT IN and NOT LIKE syntax
Date Tue, 31 May 2011 19:54:47 GMT


Eric Hassold updated HIVE-1740:

    Release Note: Extend SQL to support for NOT LIKE, NOT RLIKE, NOT REGEXP and NOT IN operators
          Status: Patch Available  (was: Open)

Support for "NOT op" is implemented using only a syntactic transformation performed in grammar,
without adding definition for new UDF. That is, AST generated for say "value NOT LIKE 'pattern'"is
strictly equal to the one for "NOT (value LIKE 'pattern')".

> support NOT IN and NOT LIKE syntax
> ----------------------------------
>                 Key: HIVE-1740
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: John Sichi
>         Attachments: HIVE-1740.1.patch.txt
> Hive should support standard SQL syntax
> x NOT LIKE p
> x NOT IN (...)

This message is automatically generated by JIRA.
For more information on JIRA, see:

View raw message