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