[ https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi updated HIVE-2344: ----------------------------- Assignee: Ido Hadanny (was: Amareshwari Sriramadasu) Status: Open (was: Patch Available) I'm getting many regression test failures due to EXPLAIN plan changes. > 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 > Affects Versions: 0.8.0 > Reporter: He Yongqiang > Assignee: Ido Hadanny > Fix For: 0.8.0 > > Attachments: hive-patch-2344.txt, ppd_udf_col.q.out.txt > > > 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