[
https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081531#comment-13081531
]
Amareshwari Sriramadasu commented on HIVE-2344:
-----------------------------------------------
The problem is that the select operator chooses to push down the filter
'random123 <0.1', though it is non deterministic. And the filter is discarded
to be pushed down since it is non deterministic later. Will upload a patch with
the fix shortly.
Any other filter on 'udf selected as column alias in select' will also be
pushed down always. Do we want to do this? Might address in a separate jira.
> 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
