Alina created HIVE-3592:
---------------------------

             Summary: where clause is ignored when limit is used and query runs 
locally
                 Key: HIVE-3592
                 URL: https://issues.apache.org/jira/browse/HIVE-3592
             Project: Hive
          Issue Type: Bug
          Components: Query Processor, SQL
         Environment: AWS
            Reporter: Alina


select * from tbl where blah='foo' limit 4;
results in displaying first 4 rows of the tbl that runs locally, the blah='foo' 
condition is ignored

if I change the select to specify columns which will essentially force it to 
not run locally but do map reduce works fine
select column1 as test, * from tbl where blah='foo' limit 4;

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