[
https://issues.apache.org/jira/browse/HIVE-19500?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16478001#comment-16478001
]
Nita Dembla commented on HIVE-19500:
------------------------------------
I didn't have a good pass rate on TPCDS with 2nd patch here. Though the change
fixes query74 but causes OOM's in other queries.
> Prevent multiple selectivity estimations for the same variable in conjuctions
> -----------------------------------------------------------------------------
>
> Key: HIVE-19500
> URL: https://issues.apache.org/jira/browse/HIVE-19500
> Project: Hive
> Issue Type: Sub-task
> Affects Versions: 3.0.0, 3.1.0
> Reporter: Zoltan Haindrich
> Assignee: Zoltan Haindrich
> Priority: Major
> Attachments: HIVE-19500.01.patch, HIVE-19500.02.patch
>
>
> see HIVE-19097 for problem description
> for filters like: {{(d_year in (2001,2002) and d_year = 2001)}} the current
> estimation is around {{(1/NDV)**2}} (iff column stats are available) ....
> actually the source of the problem was a small typo in HIVE-17465
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
