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

2016-02-19 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-02-19 Thread Laljo John Pullokkaran (JIRA)
[ 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

2016-02-19 Thread Laljo John Pullokkaran (JIRA)
[ 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

2016-02-17 Thread Laljo John Pullokkaran (JIRA)
[ 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

2016-02-17 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-02-12 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15144976#comment-15144976 ] Laljo John Pullokkaran commented on HIVE-11752: --- +1 > Pre-materializing complex CTE queries

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

2016-02-12 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11752?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15144978#comment-15144978 ] Laljo John Pullokkaran commented on HIVE-11752: --- We need subsequent work to 1. link the top

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

2016-02-02 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-02-02 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-02-02 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-01-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15120641#comment-15120641 ] Laljo John Pullokkaran commented on HIVE-12709: --- +1 > further improve user level explain >

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

2016-01-25 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15116790#comment-15116790 ] Laljo John Pullokkaran commented on HIVE-12478: --- +1 conditional on clean qa run > Improve

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

2016-01-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15111755#comment-15111755 ] Laljo John Pullokkaran commented on HIVE-12867: --- +1 > Semantic Exception Error Msg should

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

2016-01-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15106065#comment-15106065 ] Laljo John Pullokkaran commented on HIVE-12879: --- +1 > RowResolver of Semijoin not updated

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

2016-01-15 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-01-13 Thread Laljo John Pullokkaran (JIRA)
[ 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

2016-01-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12808?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15097441#comment-15097441 ] Laljo John Pullokkaran commented on HIVE-12808: --- Initial patch; need to upload a patch with

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

2016-01-13 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-01-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15092822#comment-15092822 ] Laljo John Pullokkaran commented on HIVE-12785: --- +1 > View with union type and UDF to

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

2016-01-08 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-01-08 Thread Laljo John Pullokkaran (JIRA)
[ 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:

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

2016-01-08 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2016-01-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15088202#comment-15088202 ] Laljo John Pullokkaran commented on HIVE-12590: --- +1 > Repeated UDAFs with literals can

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

2016-01-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15088205#comment-15088205 ] Laljo John Pullokkaran commented on HIVE-12800: --- +1 Pending QA Run >

[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

2016-01-06 Thread Laljo John Pullokkaran (JIRA)
[ 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

[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

2016-01-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15084573#comment-15084573 ] Laljo John Pullokkaran commented on HIVE-11603: --- This is no more an issue on master been

[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

2016-01-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15084579#comment-15084579 ] Laljo John Pullokkaran commented on HIVE-11603: --- [~jcamachorodriguez] Could you review the

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

2015-12-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15067076#comment-15067076 ] Laljo John Pullokkaran commented on HIVE-11927: --- +1 conditional on QA run + dead code

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

2015-12-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15067253#comment-15067253 ] Laljo John Pullokkaran commented on HIVE-10141: --- Its not just parser; the compiler currently

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

2015-12-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15065000#comment-15065000 ] Laljo John Pullokkaran commented on HIVE-11865: --- May be you could address this in a followup

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

2015-12-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15064999#comment-15064999 ] Laljo John Pullokkaran commented on HIVE-11865: --- [~jcamachorodriguez]

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

2015-12-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15064891#comment-15064891 ] Laljo John Pullokkaran commented on HIVE-12644: --- As we discussed, need to simplify the logic

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

2015-12-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11865?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15064905#comment-15064905 ] Laljo John Pullokkaran commented on HIVE-11865: --- +1 conditional on clean qa run > Disable

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

2015-12-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15065190#comment-15065190 ] Laljo John Pullokkaran commented on HIVE-12644: --- +1 conditional on clean qa run > Support

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

2015-12-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11775?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15063018#comment-15063018 ] Laljo John Pullokkaran commented on HIVE-11775: --- +1 conditional on clean QA run based on

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

2015-12-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060886#comment-15060886 ] Laljo John Pullokkaran commented on HIVE-12675: --- +1 conditional on clean QA run & adding

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

2015-12-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15061283#comment-15061283 ] Laljo John Pullokkaran commented on HIVE-12570: ---

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

2015-12-14 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15057001#comment-15057001 ] Laljo John Pullokkaran commented on HIVE-12570: --- +1 > Incorrect error message Expression

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

2015-12-14 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15057194#comment-15057194 ] Laljo John Pullokkaran commented on HIVE-12666: --- +1 conditional on QA run. >

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

2015-12-11 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15053937#comment-15053937 ] Laljo John Pullokkaran commented on HIVE-12644: --- In HiveSortMergeRule @92 isn't it better to

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

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15051592#comment-15051592 ] Laljo John Pullokkaran commented on HIVE-12535: --- [~pxiong] Could you take a look? > Dynamic

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

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15051600#comment-15051600 ] Laljo John Pullokkaran commented on HIVE-12590: --- Obvious change was to remove lowercase

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

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ 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-12355) Keep Obj Inspectors in Sync with RowSchema

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15052301#comment-15052301 ] Laljo John Pullokkaran commented on HIVE-12355: --- TS keeps pruned col list; private List

[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

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15052306#comment-15052306 ] Laljo John Pullokkaran commented on HIVE-11603: --- There is an issue on master too; but is

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

2015-12-10 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15047639#comment-15047639 ] Laljo John Pullokkaran commented on HIVE-12478: --- Once HIVE-11918, HIVE-0 goes in we

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

2015-12-08 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-08 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-07 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-04 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-02 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-12-01 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15034743#comment-15034743 ] Laljo John Pullokkaran commented on HIVE-12559: --- Yes that true, i think the join order

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

2015-12-01 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15034783#comment-15034783 ] Laljo John Pullokkaran commented on HIVE-12559: ---

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

2015-11-30 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-30 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-30 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15032630#comment-15032630 ] Laljo John Pullokkaran commented on HIVE-12477: --- It seems like this is induced by constprop.

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

2015-11-29 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15028102#comment-15028102 ] Laljo John Pullokkaran commented on HIVE-11927: --- [~pxiong] I looked at the patch: 1. Patch

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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12519?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15027557#comment-15027557 ] Laljo John Pullokkaran commented on HIVE-12519: --- You can achieve this by rewriting query

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

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

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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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] [Resolved] (HIVE-5119) MapJoin & Partition Pruning (MapJoin can take advantage of materialized data to prune partitions of big table)

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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] [Updated] (HIVE-12524) SemiJoinProjectTranspose/SemiJoinFilterTransposeRule Rule in CBO is not firing

2015-11-25 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-24 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15025581#comment-15025581 ] Laljo John Pullokkaran commented on HIVE-12508: --- Can we run in to CALCITE-794 with

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

2015-11-24 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15026134#comment-15026134 ] Laljo John Pullokkaran commented on HIVE-11927: --- [~pxiong] Now that Calcite 1.5 is released

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

2015-11-24 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12508?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15025489#comment-15025489 ] Laljo John Pullokkaran commented on HIVE-12508: --- [~jcamachorodriguez] Given that HIVE-12503

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

2015-11-24 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12503?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15023713#comment-15023713 ] Laljo John Pullokkaran commented on HIVE-12503: --- [~ashutoshc] The new Join node needs to be

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

2015-11-20 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15018649#comment-15018649 ] Laljo John Pullokkaran commented on HIVE-12355: --- [~ashutoshc] I think if we get TS to match

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

2015-11-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15018710#comment-15018710 ] Laljo John Pullokkaran commented on HIVE-11684: --- +1 > Implement limit pushdown through

[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

2015-11-19 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15014688#comment-15014688 ] Laljo John Pullokkaran commented on HIVE-11603: --- Patch needs to be revised and is blocked by

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

2015-11-19 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15014712#comment-15014712 ] Laljo John Pullokkaran commented on HIVE-12356: --- Yes, this is to reduce Hive Compilation

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

2015-11-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15009803#comment-15009803 ] Laljo John Pullokkaran commented on HIVE-12384: --- Committed to Master > Union Operator may

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

2015-11-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15009817#comment-15009817 ] Laljo John Pullokkaran commented on HIVE-12384: --- yes this needs to be back ported to

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

2015-11-17 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15007373#comment-15007373 ] Laljo John Pullokkaran commented on HIVE-12384: --- Filed HIVE-12423 to remove union operator.

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

2015-11-16 Thread Laljo John Pullokkaran (JIRA)
[ 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] [Commented] (HIVE-12384) Union Operator may produce incorrect result on TEZ

2015-11-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15007254#comment-15007254 ] Laljo John Pullokkaran commented on HIVE-12384: --- The counter argument is this: We already

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

2015-11-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15007328#comment-15007328 ] Laljo John Pullokkaran commented on HIVE-12384: --- Penalty is the cost of additional select

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

2015-11-15 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-15 Thread Laljo John Pullokkaran (JIRA)
[ 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

2015-11-12 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15001566#comment-15001566 ] Laljo John Pullokkaran commented on HIVE-11493: --- Yes this should be back ported. >

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

2015-11-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15001097#comment-15001097 ] Laljo John Pullokkaran commented on HIVE-12384: --- Patch introduces explicit cast during plan

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

2015-11-11 Thread Laljo John Pullokkaran (JIRA)
[ 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] [Updated] (HIVE-12384) Union Operator may produce incorrect result on TEZ

2015-11-11 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14999393#comment-14999393 ] Laljo John Pullokkaran commented on HIVE-11684: --- [~jcamachorodriguez] Could you update RB?

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

2015-11-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14999794#comment-14999794 ] Laljo John Pullokkaran commented on HIVE-7693: -- are the test failures related? +1 conditional

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

2015-11-10 Thread Laljo John Pullokkaran (JIRA)
[ 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

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

2015-11-06 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-12355: -- Fix Version/s: 2.0.0 > Keep Obj Inspectors in Sync with RowSchema >

[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

2015-11-06 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-11603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14994745#comment-14994745 ] Laljo John Pullokkaran commented on HIVE-11603: --- On Master ".1" patch is not sufficient as

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

2015-11-06 Thread Laljo John Pullokkaran (JIRA)
[ 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.21.patch > Reorder applyPreJoinOrderingTransforms, add

[jira] [Commented] (HIVE-12344) Wrong types inferred for SemiJoin generation in CBO

2015-11-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992257#comment-14992257 ] Laljo John Pullokkaran commented on HIVE-12344: --- This should be back ported to Hive 14 &

[jira] [Commented] (HIVE-12344) Wrong types inferred for SemiJoin generation in CBO

2015-11-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14992255#comment-14992255 ] Laljo John Pullokkaran commented on HIVE-12344: --- +1 > Wrong types inferred for SemiJoin

  1   2   3   4   >