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

Posted to dev@hive.apache.org by "Xiao Jiang (JIRA)" <ji...@apache.org> on 2012/12/12 18:18:19 UTC

[jira] [Created] (HIVE-3795) NPE in SELECT when WHERE-clause is an and/or/not operation involving null

Xiao Jiang created HIVE-3795:
--------------------------------

             Summary: NPE in SELECT when WHERE-clause is an and/or/not operation involving null
                 Key: HIVE-3795
                 URL: https://issues.apache.org/jira/browse/HIVE-3795
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Xiao Jiang


Sometimes users forget to quote date constants in queries. For example, SELECT * FROM some_table WHERE ds >= 2012-12-10 and ds <= 2012-12-12; . In such cases, if the WHERE-clause contains and/or/not operation, it would throw NPE exception. That's because PcrExprProcFactory in ql/optimizer forgot to check null. 

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