You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Eric Hassold (JIRA)" <ji...@apache.org> on 2011/05/31 21:54:47 UTC

[jira] [Updated] (HIVE-1740) support NOT IN and NOT LIKE syntax

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

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: https://issues.apache.org/jira/browse/HIVE-1740
>             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: http://www.atlassian.com/software/jira