[jira] [Created] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

[Rajesh Balamohan (JIRA)]

Rajesh Balamohan created HIVE-17342:
---------------------------------------

             Summary: Where condition with 1=0 should be treated similar to 
limit 0
                 Key: HIVE-17342
                 URL: https://issues.apache.org/jira/browse/HIVE-17342
             Project: Hive
          Issue Type: Improvement
            Reporter: Rajesh Balamohan
            Priority: Minor


In some cases, queries may get executed with where condition mentioning to 
"1=0" to get schema. E.g 
{noformat}
SELECT * FROM (select avg(d_year) as  y from date_dim where d_year>1999) q 
WHERE 1=0
{noformat}

Currently hive executes the query; it would be good to consider this similar to 
"limit 0" which does not execute the query.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)