filter is removed due to regression of HIVE-1538
------------------------------------------------
Key: HIVE-2344
URL: https://issues.apache.org/jira/browse/HIVE-2344
Project: Hive
Issue Type: Bug
Reporter: He Yongqiang
Assignee: Amareshwari Sriramadasu
select * from
(
select type_bucket,randum123
from (SELECT *, cast(rand() as double) AS randum123 FROM tbl where ds = ...) a
where randum123 <=0.1)s where s.randum123>0.1 limit 20;
This is returning results...
and
explain
select type_bucket,randum123
from (SELECT *, cast(rand() as double) AS randum123 FROM tbl where ds = ...) a
where randum123 <=0.1
shows that there is no filter.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
