[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.05.patch > Logical PPD: Push filter clauses through PTF(W

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Status: Patch Available (was: Open) > Logical PPD: Push filter clauses through

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Status: Open (was: Patch Available) > Logical PPD: Push filter clauses through

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Status: Patch Available (was: Open) > Logical PPD: Push filter clauses through

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.04.patch > Logical PPD: Push filter clauses through PTF(W

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Status: Open (was: Patch Available) > Logical PPD: Push filter clauses through

[jira] [Commented] (HIVE-11752) Pre-materializing complex CTE queries

[ https://issues.apache.org/jira/browse/HIVE-11752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15144978#comment-15144978 ] Laljo John Pullokkaran commented on HIVE-11752: --- We need subsequent work to

[jira] [Commented] (HIVE-11752) Pre-materializing complex CTE queries

[ https://issues.apache.org/jira/browse/HIVE-11752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15144976#comment-15144976 ] Laljo John Pullokkaran commented on HIVE-11752: --- +1 > Pre-materializing com

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.03.patch > Logical PPD: Push filter clauses through PTF(W

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: (was: HIVE-12808.02.patch) > Logical PPD: Push filter clauses th

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.02.patch > Logical PPD: Push filter clauses through PTF(W

[jira] [Commented] (HIVE-12763) Use bit vector to track NDV

[ https://issues.apache.org/jira/browse/HIVE-12763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15120647#comment-15120647 ] Laljo John Pullokkaran commented on HIVE-12763: --- +1 > Use bit vector to tra

[jira] [Commented] (HIVE-12709) further improve user level explain

[ https://issues.apache.org/jira/browse/HIVE-12709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15120641#comment-15120641 ] Laljo John Pullokkaran commented on HIVE-12709: --- +1 > further improve user

[jira] [Commented] (HIVE-12478) Improve Hive/Calcite Transitive Predicate inference

[ https://issues.apache.org/jira/browse/HIVE-12478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15116790#comment-15116790 ] Laljo John Pullokkaran commented on HIVE-12478: --- +1 conditional on clean qa

[jira] [Commented] (HIVE-12867) Semantic Exception Error Msg should be with in the range of "10000 to 19999"

[ https://issues.apache.org/jira/browse/HIVE-12867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15111755#comment-15111755 ] Laljo John Pullokkaran commented on HIVE-12867: --- +1 > Semantic Exception Er

[jira] [Commented] (HIVE-12879) RowResolver of Semijoin not updated in CalcitePlanner

[ https://issues.apache.org/jira/browse/HIVE-12879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15106065#comment-15106065 ] Laljo John Pullokkaran commented on HIVE-12879: --- +1 > RowResolver of Semijo

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.02.patch > Logical PPD: Push filter clauses through PTF(W

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF(Windowing) into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Summary: Logical PPD: Push filter clauses through PTF(Windowing) into TS (was:

[jira] [Commented] (HIVE-12808) Logical PPD: Push filter clauses through PTF into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15097441#comment-15097441 ] Laljo John Pullokkaran commented on HIVE-12808: --- Initial patch; need to uplo

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Attachment: HIVE-12808.01.patch > Logical PPD: Push filter clauses through PTF i

[jira] [Commented] (HIVE-12785) View with union type and UDF to `cast` the struct is broken

[ https://issues.apache.org/jira/browse/HIVE-12785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15092822#comment-15092822 ] Laljo John Pullokkaran commented on HIVE-12785: --- +1 > View with union type

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses through PTF into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Summary: Logical PPD: Push filter clauses through PTF into TS (was: Logical PPD

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses into ROW_NUMBER() over()

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Summary: Logical PPD: Push filter clauses into ROW_NUMBER() over() (was: Logica

[jira] [Updated] (HIVE-12808) Logical PPD: Push filter clauses into PTF

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12808: -- Summary: Logical PPD: Push filter clauses into PTF (was: Logical PPD: Push filt

[jira] [Assigned] (HIVE-12808) Logical PPD: Push filter clauses through PTF into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran reassigned HIVE-12808: - Assignee: Laljo John Pullokkaran > Logical PPD: Push filter clauses throu

[jira] [Commented] (HIVE-12808) Logical PPD: Push filter clauses through PTF into TS

[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15088440#comment-15088440 ] Laljo John Pullokkaran commented on HIVE-12808: --- [~gopalv] I have a WIP patc

[jira] [Commented] (HIVE-12800) HiveFilterSetOpTransposeRule might be executed over non deterministic filter predicates

[ https://issues.apache.org/jira/browse/HIVE-12800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15088205#comment-15088205 ] Laljo John Pullokkaran commented on HIVE-12800: --- +1 Pending QA Run > HiveFi

[jira] [Commented] (HIVE-12590) Repeated UDAFs with literals can produce incorrect result

[ https://issues.apache.org/jira/browse/HIVE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15088202#comment-15088202 ] Laljo John Pullokkaran commented on HIVE-12590: --- +1 > Repeated UDAFs with l

[jira] [Updated] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-11603: -- Fix Version/s: 1.3.0 > IndexOutOfBoundsException thrown when accessing a union a

[jira] [Commented] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15084579#comment-15084579 ] Laljo John Pullokkaran commented on HIVE-11603: --- [~jcamachorodriguez] Could

[jira] [Updated] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-11603: -- Attachment: HIVE-11603.3.patch > IndexOutOfBoundsException thrown when accessing

[jira] [Commented] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15084573#comment-15084573 ] Laljo John Pullokkaran commented on HIVE-11603: --- This is no more an issue on

[jira] [Commented] (HIVE-10141) count(distinct) not supported in Windowing function

[ https://issues.apache.org/jira/browse/HIVE-10141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15067253#comment-15067253 ] Laljo John Pullokkaran commented on HIVE-10141: --- Its not just parser; the co

[jira] [Commented] (HIVE-11927) Implement/Enable constant related optimization rules in Calcite: enable HiveReduceExpressionsRule to fold constants

[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15067076#comment-15067076 ] Laljo John Pullokkaran commented on HIVE-11927: --- +1 conditional on QA run +

[jira] [Commented] (HIVE-12644) Support for offset in HiveSortMergeRule

[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15065190#comment-15065190 ] Laljo John Pullokkaran commented on HIVE-12644: --- +1 conditional on clean qa

[jira] [Commented] (HIVE-11865) Disable Hive PPD optimizer when CBO has optimized the plan

[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15065000#comment-15065000 ] Laljo John Pullokkaran commented on HIVE-11865: --- May be you could address th

[jira] [Commented] (HIVE-11865) Disable Hive PPD optimizer when CBO has optimized the plan

[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15064999#comment-15064999 ] Laljo John Pullokkaran commented on HIVE-11865: --- [~jcamachorodriguez] Simple

[jira] [Commented] (HIVE-11865) Disable Hive PPD optimizer when CBO has optimized the plan

[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15064905#comment-15064905 ] Laljo John Pullokkaran commented on HIVE-11865: --- +1 conditional on clean qa

[jira] [Commented] (HIVE-12644) Support for offset in HiveSortMergeRule

[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15064891#comment-15064891 ] Laljo John Pullokkaran commented on HIVE-12644: --- As we discussed, need to si

[jira] [Commented] (HIVE-11775) Implement limit push down through union all in CBO

[ https://issues.apache.org/jira/browse/HIVE-11775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15063018#comment-15063018 ] Laljo John Pullokkaran commented on HIVE-11775: --- +1 conditional on clean QA

[jira] [Commented] (HIVE-12570) Incorrect error message Expression not in GROUP BY key thrown instead of Invalid function

[ https://issues.apache.org/jira/browse/HIVE-12570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15061283#comment-15061283 ] Laljo John Pullokkaran commented on HIVE-12570: --- https://issues.apache.org/j

[jira] [Commented] (HIVE-12675) PerfLogger should log performance metrics at debug level

[ https://issues.apache.org/jira/browse/HIVE-12675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15060886#comment-15060886 ] Laljo John Pullokkaran commented on HIVE-12675: --- +1 conditional on clean QA

[jira] [Commented] (HIVE-12666) PCRExprProcFactory.GenericFuncExprProcessor.process() aggressively removes dynamic partition pruner generated synthetic join predicates.

[ https://issues.apache.org/jira/browse/HIVE-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15057194#comment-15057194 ] Laljo John Pullokkaran commented on HIVE-12666: --- +1 conditional on QA run.

[jira] [Commented] (HIVE-12570) Incorrect error message Expression not in GROUP BY key thrown instead of Invalid function

[ https://issues.apache.org/jira/browse/HIVE-12570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15057001#comment-15057001 ] Laljo John Pullokkaran commented on HIVE-12570: --- +1 > Incorrect error messa

[jira] [Commented] (HIVE-12644) Support for offset in HiveSortMergeRule

[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15053937#comment-15053937 ] Laljo John Pullokkaran commented on HIVE-12644: --- In HiveSortMergeRule @92 is

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.35.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052306#comment-15052306 ] Laljo John Pullokkaran commented on HIVE-11603: --- There is an issue on master

[jira] [Commented] (HIVE-12355) Keep Obj Inspectors in Sync with RowSchema

[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052301#comment-15052301 ] Laljo John Pullokkaran commented on HIVE-12355: --- TS keeps pruned col list;

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.34.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-12590) Repeated UDAFs with literals can produce incorrect result

[ https://issues.apache.org/jira/browse/HIVE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051600#comment-15051600 ] Laljo John Pullokkaran commented on HIVE-12590: --- Obvious change was to remov

[jira] [Updated] (HIVE-12590) Repeated UDAFs with literals can produce incorrect result

[ https://issues.apache.org/jira/browse/HIVE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12590: -- Assignee: Ashutosh Chauhan (was: Laljo John Pullokkaran) > Repeated UDAFs with

[jira] [Commented] (HIVE-12535) Dynamic Hash Join: Key references are cyclic

[ https://issues.apache.org/jira/browse/HIVE-12535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051592#comment-15051592 ] Laljo John Pullokkaran commented on HIVE-12535: --- [~pxiong] Could you take a

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.33.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-12478) Improve Hive/Calcite Trasitive Predicate inference

[ https://issues.apache.org/jira/browse/HIVE-12478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12478: -- Assignee: Jesus Camacho Rodriguez (was: Laljo John Pullokkaran) > Improve Hive/

[jira] [Commented] (HIVE-12478) Improve Hive/Calcite Trasitive Predicate inference

[ https://issues.apache.org/jira/browse/HIVE-12478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15047639#comment-15047639 ] Laljo John Pullokkaran commented on HIVE-12478: --- Once HIVE-11918, HIVE-0

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.32.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.31.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.30.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.29.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-12559) Vectorization on MR produces different results

[ https://issues.apache.org/jira/browse/HIVE-12559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15034783#comment-15034783 ] Laljo John Pullokkaran commented on HIVE-12559: --- https://docs.oracle.com/cd/

[jira] [Commented] (HIVE-12559) Vectorization on MR produces different results

[ https://issues.apache.org/jira/browse/HIVE-12559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15034743#comment-15034743 ] Laljo John Pullokkaran commented on HIVE-12559: --- Yes that true, i think the

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.28.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-12477) CBO: Left Semijoins are incompatible with a cross-product

[ https://issues.apache.org/jira/browse/HIVE-12477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15032630#comment-15032630 ] Laljo John Pullokkaran commented on HIVE-12477: --- It seems like this is induc

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.27.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.27 > Reorder applyPreJoinOrderingTransforms, add NotNULL/

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.26.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-11927) Implement/Enable constant related optimization rules in Calcite: enable HiveReduceExpressionsRule to fold constants

[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15028102#comment-15028102 ] Laljo John Pullokkaran commented on HIVE-11927: --- [~pxiong] I looked at the p

[jira] [Resolved] (HIVE-5119) MapJoin & Partition Pruning (MapJoin can take advantage of materialized data to prune partitions of big table)

[ https://issues.apache.org/jira/browse/HIVE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-5119. -- Resolution: Fixed > MapJoin & Partition Pruning (MapJoin can take advantage of ma

[jira] [Resolved] (HIVE-8077) CBO Trunk Merge: Test Failure vectorization_7

[ https://issues.apache.org/jira/browse/HIVE-8077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-8077. -- Resolution: Fixed > CBO Trunk Merge: Test Failure vectorization_7 > -

[jira] [Resolved] (HIVE-8234) CBO: Refactor SemanticAnalyzer and move out CBO code

[ https://issues.apache.org/jira/browse/HIVE-8234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-8234. -- Resolution: Fixed > CBO: Refactor SemanticAnalyzer and move out CBO code > -

[jira] [Resolved] (HIVE-7462) CBO:Add rule to push filter through GB

[ https://issues.apache.org/jira/browse/HIVE-7462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-7462. -- Resolution: Fixed > CBO:Add rule to push filter through GB >

[jira] [Commented] (HIVE-5119) MapJoin & Partition Pruning (MapJoin can take advantage of materialized data to prune partitions of big table)

[ https://issues.apache.org/jira/browse/HIVE-5119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15027699#comment-15027699 ] Laljo John Pullokkaran commented on HIVE-5119: -- This is fixed by DPP work. >

[jira] [Updated] (HIVE-12524) SemiJoinProjectTranspose/SemiJoinFilterTransposeRule Rule in CBO is not firing

[ https://issues.apache.org/jira/browse/HIVE-12524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12524: -- Summary: SemiJoinProjectTranspose/SemiJoinFilterTransposeRule Rule in CBO is not

[jira] [Commented] (HIVE-12519) ANTI JOIN in hive

[ https://issues.apache.org/jira/browse/HIVE-12519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15027557#comment-15027557 ] Laljo John Pullokkaran commented on HIVE-12519: --- You can achieve this by rew

[jira] [Commented] (HIVE-11927) Implement/Enable constant related optimization rules in Calcite: enable HiveReduceExpressionsRule to fold constants

[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15026134#comment-15026134 ] Laljo John Pullokkaran commented on HIVE-11927: --- [~pxiong] Now that Calcite

[jira] [Commented] (HIVE-12508) HiveAggregateJoinTransposeRule places a heavy load on the metadata system

[ https://issues.apache.org/jira/browse/HIVE-12508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15025581#comment-15025581 ] Laljo John Pullokkaran commented on HIVE-12508: --- Can we run in to CALCITE-79

[jira] [Commented] (HIVE-12508) HiveAggregateJoinTransposeRule places a heavy load on the metadata system

[ https://issues.apache.org/jira/browse/HIVE-12508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15025489#comment-15025489 ] Laljo John Pullokkaran commented on HIVE-12508: --- [~jcamachorodriguez] Given

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.25.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-12503) GBY-Join transpose rule may go in infinite loop

[ https://issues.apache.org/jira/browse/HIVE-12503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15023713#comment-15023713 ] Laljo John Pullokkaran commented on HIVE-12503: --- [~ashutoshc] The new Join n

[jira] [Commented] (HIVE-11684) Implement limit pushdown through outer join in CBO

[ https://issues.apache.org/jira/browse/HIVE-11684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15018710#comment-15018710 ] Laljo John Pullokkaran commented on HIVE-11684: --- +1 > Implement limit pushd

[jira] [Commented] (HIVE-12355) Keep Obj Inspectors in Sync with RowSchema

[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15018649#comment-15018649 ] Laljo John Pullokkaran commented on HIVE-12355: --- [~ashutoshc] I think if we

[jira] [Updated] (HIVE-12355) Keep Obj Inspectors in Sync with RowSchema

[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12355: -- Assignee: Ashutosh Chauhan (was: Laljo John Pullokkaran) Target Vers

[jira] [Commented] (HIVE-12356) Capture if a rule mutated the plan.

[ https://issues.apache.org/jira/browse/HIVE-12356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15014712#comment-15014712 ] Laljo John Pullokkaran commented on HIVE-12356: --- Yes, this is to reduce Hive

[jira] [Commented] (HIVE-11603) IndexOutOfBoundsException thrown when accessing a union all subquery and filtering on a column which does not exist in all underlying tables

[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15014688#comment-15014688 ] Laljo John Pullokkaran commented on HIVE-11603: --- Patch needs to be revised a

[jira] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12384: -- Attachment: HIVE-12384.4.patch Added a modified patch (.4) to include missed tes

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15009817#comment-15009817 ] Laljo John Pullokkaran commented on HIVE-12384: --- yes this needs to be back p

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15009803#comment-15009803 ] Laljo John Pullokkaran commented on HIVE-12384: --- Committed to Master > Unio

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15007373#comment-15007373 ] Laljo John Pullokkaran commented on HIVE-12384: --- Filed HIVE-12423 to remove

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15007328#comment-15007328 ] Laljo John Pullokkaran commented on HIVE-12384: --- Penalty is the cost of addi

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15007254#comment-15007254 ] Laljo John Pullokkaran commented on HIVE-12384: --- The counter argument is thi

[jira] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12384: -- Attachment: HIVE-12384.3.patch > Union Operator may produce incorrect result on

[jira] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12384: -- Attachment: HIVE-12384.2.patch > Union Operator may produce incorrect result on

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.24.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.23.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

[ https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15001566#comment-15001566 ] Laljo John Pullokkaran commented on HIVE-11493: --- Yes this should be back po

[jira] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12384: -- Affects Version/s: 1.0.0 1.1.0 1.0.

[jira] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12384: -- Attachment: HIVE-12384.1.patch > Union Operator may produce incorrect result on

[jira] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15001097#comment-15001097 ] Laljo John Pullokkaran commented on HIVE-12384: --- Patch introduces explicit c

[jira] [Updated] (HIVE-11110) Reorder applyPreJoinOrderingTransforms, add NotNULL/FilterMerge rules, improve Filter selectivity estimation

[ https://issues.apache.org/jira/browse/HIVE-0?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-0: -- Attachment: HIVE-0.22.patch > Reorder applyPreJoinOrderingTransforms, add No

[jira] [Commented] (HIVE-7693) Invalid column ref error in order by when using column alias in select clause and using having

[ https://issues.apache.org/jira/browse/HIVE-7693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14999794#comment-14999794 ] Laljo John Pullokkaran commented on HIVE-7693: -- are the test failures related?

  1   2   3   4   >