[jira] [Resolved] (HIVE-9943) CBO (Calcite Return Path): GroupingID translation from Calcite [CBO branch]

2015-03-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-9943. -- Resolution: Fixed CBO (Calcite Return Path): GroupingID translation from

[jira] [Updated] (HIVE-9982) CBO (Calcite Return Path): Prune TS Relnode schema

2015-03-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-9982: - Attachment: HIVE-9982.patch CBO (Calcite Return Path): Prune TS Relnode schema

[jira] [Commented] (HIVE-9867) Migrate usage of deprecated Calcite methods

2015-03-06 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14350801#comment-14350801 ] Laljo John Pullokkaran commented on HIVE-9867: -- +1 Migrate usage of

[jira] [Updated] (HIVE-9563) CBO(Calcite Return Path): Translate GB to Hive OP [CBO branch]

2015-03-25 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9563?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-9563: - Attachment: HIVE-9563.patch CBO(Calcite Return Path): Translate GB to Hive OP

[jira] [Commented] (HIVE-10038) Add Calcite's ProjectMergeRule.

2015-03-30 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10038?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14387613#comment-14387613 ] Laljo John Pullokkaran commented on HIVE-10038: --- +1 Add Calcite's

[jira] [Resolved] (HIVE-10097) CBO (Calcite Return Path): Upgrade to new Calcite snapshot [CBO Branch]

2015-03-26 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10097. --- Resolution: Fixed CBO (Calcite Return Path): Upgrade to new Calcite snapshot

[jira] [Assigned] (HIVE-10069) CBO (Calcite Return Path): Ambiguity table name causes problem in field trimmer [CBO Branch]

2015-03-26 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran reassigned HIVE-10069: - Assignee: Laljo John Pullokkaran (was: Jesus Camacho Rodriguez) CBO

[jira] [Resolved] (HIVE-10069) CBO (Calcite Return Path): Ambiguity table name causes problem in field trimmer [CBO Branch]

2015-03-26 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10069. --- Resolution: Fixed CBO (Calcite Return Path): Ambiguity table name causes

[jira] [Updated] (HIVE-10069) CBO (Calcite Return Path): Ambiguity table name causes problem in field trimmer [CBO Branch]

2015-03-26 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10069: -- Attachment: HIVE-10069.1.patch CBO (Calcite Return Path): Ambiguity table name

[jira] [Commented] (HIVE-9903) Update calcite version

2015-03-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14376289#comment-14376289 ] Laljo John Pullokkaran commented on HIVE-9903: -- Failure is unrelated. +1

[jira] [Commented] (HIVE-10243) Introduce JoinAlgorithm Interface

2015-04-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14493004#comment-14493004 ] Laljo John Pullokkaran commented on HIVE-10243: --- [~jcamachorodriguez] Could

[jira] [Resolved] (HIVE-10326) CBO (Calcite Return Path): Invoke Hive's Cumulative Cost

2015-04-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10326. --- Resolution: Fixed CBO (Calcite Return Path): Invoke Hive's Cumulative Cost

[jira] [Updated] (HIVE-10326) CBO (Calcite Return Path): Invoke Hive's Cumulative Cost

2015-04-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10326: -- Attachment: HIVE-10326.patch CBO (Calcite Return Path): Invoke Hive's

[jira] [Commented] (HIVE-10310) Support GROUPING() and GROUP_ID() in HIVE

2015-04-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14492694#comment-14492694 ] Laljo John Pullokkaran commented on HIVE-10310: --- Also see

[jira] [Commented] (HIVE-10268) Merge cbo branch into trunk

2015-04-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14504204#comment-14504204 ] Laljo John Pullokkaran commented on HIVE-10268: --- [~leftylev] These are

[jira] [Commented] (HIVE-10413) [CBO] Return path assumes distinct column cant be same as grouping column

2015-04-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10413?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505462#comment-14505462 ] Laljo John Pullokkaran commented on HIVE-10413: --- [~ashutoshc] We need to

[jira] [Updated] (HIVE-10413) [CBO] Return path assumes distinct column cant be same as grouping column

2015-04-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10413: -- Issue Type: Sub-task (was: Bug) Parent: HIVE-9132 [CBO] Return path

[jira] [Commented] (HIVE-10416) CBO (Calcite Return Path): Fix return columns if Sort operator is on top of plan returned by Calcite

2015-04-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14505331#comment-14505331 ] Laljo John Pullokkaran commented on HIVE-10416: --- [~jcamachorodriguez]

[jira] [Updated] (HIVE-10463) CBO (Calcite Return Path): Insert overwrite... select * from... queries failing for bucketed tables

2015-04-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10463: -- Assignee: Laljo John Pullokkaran CBO (Calcite Return Path): Insert

[jira] [Updated] (HIVE-10413) [CBO] Return path assumes distinct column cant be same as grouping column

2015-04-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10413: -- Attachment: HIVE-10413.3.patch [CBO] Return path assumes distinct column cant

[jira] [Commented] (HIVE-10416) CBO (Calcite Return Path): Fix return columns if Sort operator is on top of plan returned by Calcite

2015-04-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14510060#comment-14510060 ] Laljo John Pullokkaran commented on HIVE-10416: --- Code Formatting: two tabs.

[jira] [Commented] (HIVE-10462) CBO (Calcite Return Path): Exception thrown in conversion to MapJoin

2015-04-23 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14510189#comment-14510189 ] Laljo John Pullokkaran commented on HIVE-10462: --- [~jcamachorodriguez] Since

[jira] [Updated] (HIVE-10391) CBO (Calcite Return Path): HiveOpConverter always assumes that HiveFilter does not include a partition column

2015-04-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10391: -- Attachment: HIVE-10391.patch CBO (Calcite Return Path): HiveOpConverter always

[jira] [Commented] (HIVE-10391) CBO (Calcite Return Path): HiveOpConverter always assumes that HiveFilter does not include a partition column

2015-04-21 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14506001#comment-14506001 ] Laljo John Pullokkaran commented on HIVE-10391: --- [~ashutoshc] Can you review

[jira] [Commented] (HIVE-10416) CBO (Calcite Return Path): Fix return columns if Sort operator is on top of plan returned by Calcite

2015-04-22 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14507739#comment-14507739 ] Laljo John Pullokkaran commented on HIVE-10416: --- [~jcamachorodriguez]

[jira] [Commented] (HIVE-10462) CBO (Calcite Return Path): Exception thrown in conversion to MapJoin

2015-04-24 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14511505#comment-14511505 ] Laljo John Pullokkaran commented on HIVE-10462: --- +1 CBO (Calcite Return

[jira] [Updated] (HIVE-10413) [CBO] Return path assumes distinct column cant be same as grouping column

2015-04-22 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10413: -- Attachment: HIVE-10413.2.patch [CBO] Return path assumes distinct column cant

[jira] [Assigned] (HIVE-10413) [CBO] Return path assumes distinct column cant be same as grouping column

2015-04-22 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran reassigned HIVE-10413: - Assignee: Laljo John Pullokkaran (was: Ashutosh Chauhan) [CBO] Return

[jira] [Commented] (HIVE-10400) CBO (Calcite Return Path): Exception when column name contains dot or colon characters

2015-04-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14503398#comment-14503398 ] Laljo John Pullokkaran commented on HIVE-10400: --- +1 CBO (Calcite Return

[jira] [Commented] (HIVE-10120) Disallow create table with dot/colon in column name

2015-04-24 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14511525#comment-14511525 ] Laljo John Pullokkaran commented on HIVE-10120: --- +1 Disallow create table

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-04-28 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518393#comment-14518393 ] Laljo John Pullokkaran commented on HIVE-10526: --- [~ashutoshc] Could you

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-04-28 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14518440#comment-14518440 ] Laljo John Pullokkaran commented on HIVE-10526: --- I am not sure about that.

[jira] [Updated] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-04-28 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10526: -- Attachment: HIVE-10526.patch CBO (Calcite Return Path): HiveCost epsilon

[jira] [Commented] (HIVE-10513) [CBO] return path : Fix create_func1.q for return path

2015-04-29 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14520044#comment-14520044 ] Laljo John Pullokkaran commented on HIVE-10513: --- +1 [CBO] return path :

[jira] [Commented] (HIVE-10522) CBO (Calcite Return Path): fix the wrong needed column names when TS is created

2015-04-29 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10522?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14520097#comment-14520097 ] Laljo John Pullokkaran commented on HIVE-10522: --- +1 CBO (Calcite Return

[jira] [Commented] (HIVE-10462) CBO (Calcite Return Path): MapJoin and SMBJoin conversion not triggered

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14515139#comment-14515139 ] Laljo John Pullokkaran commented on HIVE-10462: --- [~jcamachorodriguez] This

[jira] [Reopened] (HIVE-10462) CBO (Calcite Return Path): MapJoin and SMBJoin conversion not triggered

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran reopened HIVE-10462: --- CBO (Calcite Return Path): MapJoin and SMBJoin conversion not triggered

[jira] [Commented] (HIVE-10462) CBO (Calcite Return Path): MapJoin and SMBJoin conversion not triggered

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14515151#comment-14515151 ] Laljo John Pullokkaran commented on HIVE-10462: --- [~jcamachorodriguez] If

[jira] [Commented] (HIVE-10506) CBO (Calcite Return Path): Disallow return path to be enable if CBO is off

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14516118#comment-14516118 ] Laljo John Pullokkaran commented on HIVE-10506: --- [~jcamachorodriguez] I

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-01 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523540#comment-14523540 ] Laljo John Pullokkaran commented on HIVE-10526: --- [~ashutoshc] The plan

[jira] [Updated] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-01 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10526: -- Attachment: HIVE-10526.1.patch CBO (Calcite Return Path): HiveCost epsilon

[jira] [Updated] (HIVE-10479) Empty tabAlias in columnInfo which triggers PPD

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10479: -- Attachment: HIVE-10479.patch Empty tabAlias in columnInfo which triggers PPD

[jira] [Commented] (HIVE-10479) Empty tabAlias in columnInfo which triggers PPD

2015-04-27 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14514751#comment-14514751 ] Laljo John Pullokkaran commented on HIVE-10479: --- This is a temporary patch

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529502#comment-14529502 ] Laljo John Pullokkaran commented on HIVE-10526: --- uploaded modified patch

[jira] [Commented] (HIVE-10506) CBO (Calcite Return Path): Disallow return path to be enable if CBO is off

2015-05-05 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529489#comment-14529489 ] Laljo John Pullokkaran commented on HIVE-10506: --- +1 CBO (Calcite Return

[jira] [Updated] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10526: -- Attachment: HIVE-10526.4.patch CBO (Calcite Return Path): HiveCost epsilon

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14532152#comment-14532152 ] Laljo John Pullokkaran commented on HIVE-10526: --- Most of the failures are

[jira] [Commented] (HIVE-10526) CBO (Calcite Return Path): HiveCost epsilon comparison should take row count in to account

2015-05-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10526?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533405#comment-14533405 ] Laljo John Pullokkaran commented on HIVE-10526: --- Committed to master/trunk,

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-05-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533546#comment-14533546 ] Laljo John Pullokkaran commented on HIVE-10190: --- [~sircodesalot] Looks good,

[jira] [Commented] (HIVE-10627) Queries fail with Failed to breakup Windowing invocations into Groups

2015-05-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14533535#comment-14533535 ] Laljo John Pullokkaran commented on HIVE-10627: --- 1. Could you add logical

[jira] [Commented] (HIVE-10506) CBO (Calcite Return Path): Disallow return path to be enable if CBO is off

2015-05-06 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14531870#comment-14531870 ] Laljo John Pullokkaran commented on HIVE-10506: --- Committed to trunk,

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-05-04 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527253#comment-14527253 ] Laljo John Pullokkaran commented on HIVE-10190: --- [~sircodesalot] Try running

[jira] [Commented] (HIVE-10568) Select count(distinct()) can have more optimal execution plan

2015-05-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535603#comment-14535603 ] Laljo John Pullokkaran commented on HIVE-10568: --- +1 Select

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-05-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538207#comment-14538207 ] Laljo John Pullokkaran commented on HIVE-10190: --- +1 CBO: AST mode checks

[jira] [Commented] (HIVE-10244) Vectorization : TPC-DS Q80 fails with java.lang.ClassCastException when hive.vectorized.execution.reduce.enabled is enabled

2015-05-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538297#comment-14538297 ] Laljo John Pullokkaran commented on HIVE-10244: --- [~jcamachorodriguez] Could

[jira] [Updated] (HIVE-10244) Vectorization : TPC-DS Q80 fails with java.lang.ClassCastException when hive.vectorized.execution.reduce.enabled is enabled

2015-05-11 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10244: -- Assignee: Jesus Camacho Rodriguez (was: Matt McCline) Vectorization : TPC-DS

[jira] [Updated] (HIVE-10107) Union All : Vertex missing stats resulting in OOM and in-efficient plans

2015-05-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10107: -- Assignee: Pengcheng Xiong Union All : Vertex missing stats resulting in OOM

[jira] [Updated] (HIVE-10107) Union All : Vertex missing stats resulting in OOM and in-efficient plans

2015-05-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10107: -- Assignee: (was: Prasanth Jayachandran) Union All : Vertex missing stats

[jira] [Commented] (HIVE-10686) java.lang.IndexOutOfBoundsException for query with rank() over(partition ...)

2015-05-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14542797#comment-14542797 ] Laljo John Pullokkaran commented on HIVE-10686: --- [~jcamachorodriguez] In

[jira] [Commented] (HIVE-10627) Queries fail with Failed to breakup Windowing invocations into Groups

2015-05-13 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14542800#comment-14542800 ] Laljo John Pullokkaran commented on HIVE-10627: --- +1 Queries fail with

[jira] [Updated] (HIVE-10695) Hive Query Produces Wrong Result: PPD

2015-05-12 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10695: -- Description: Following query produces wrong result: select * from t1 s left

[jira] [Commented] (HIVE-10695) Hive Query Produces Wrong Result: PPD

2015-05-12 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14541035#comment-14541035 ] Laljo John Pullokkaran commented on HIVE-10695: --- This is duplicate of

[jira] [Updated] (HIVE-10695) Hive Query Produces Wrong Result: PPD

2015-05-12 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10695: -- Attachment: HIVE-10695.patch Hive Query Produces Wrong Result: PPD

[jira] [Commented] (HIVE-10686) java.lang.IndexOutOfBoundsException for query with rank() over(partition ...)

2015-05-14 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14544664#comment-14544664 ] Laljo John Pullokkaran commented on HIVE-10686: --- +1

[jira] [Commented] (HIVE-10627) Queries fail with Failed to breakup Windowing invocations into Groups

2015-05-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14548613#comment-14548613 ] Laljo John Pullokkaran commented on HIVE-10627: --- Committed to trunk. Waiting

[jira] [Commented] (HIVE-10627) Queries fail with Failed to breakup Windowing invocations into Groups

2015-05-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14549369#comment-14549369 ] Laljo John Pullokkaran commented on HIVE-10627: --- [~sushanth] Can i check

[jira] [Updated] (HIVE-10310) Support GROUPING() in HIVE

2015-04-15 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10310?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10310: -- Summary: Support GROUPING() in HIVE (was: Support GROUPING() and GROUP_ID() in

[jira] [Commented] (HIVE-10344) CBO (Calcite Return Path): Use newInstance to create ExprNodeGenericFuncDesc rather than construction function

2015-04-15 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14496924#comment-14496924 ] Laljo John Pullokkaran commented on HIVE-10344: --- [~ashutoshc] Could you

[jira] [Updated] (HIVE-10343) CBO (Calcite Return Path): Parameterize algorithm cost model

2015-04-15 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10343: -- Attachment: HIVE-10343.patch CBO (Calcite Return Path): Parameterize algorithm

[jira] [Updated] (HIVE-10350) CBO: Use total size instead of bucket count to determine number of splits parallelism

2015-04-15 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10350: -- Attachment: HIVE-10350.2.patch CBO: Use total size instead of bucket count to

[jira] [Commented] (HIVE-10350) CBO: Use total size instead of bucket count to determine number of splits parallelism

2015-04-15 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14497444#comment-14497444 ] Laljo John Pullokkaran commented on HIVE-10350: --- [~mmokhtar] I have uploaded

[jira] [Resolved] (HIVE-10350) CBO: Use total size instead of bucket count to determine number of splits parallelism

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10350. --- Resolution: Fixed CBO: Use total size instead of bucket count to determine

[jira] [Commented] (HIVE-10350) CBO: Use total size instead of bucket count to determine number of splits parallelism

2015-04-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10350?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14499159#comment-14499159 ] Laljo John Pullokkaran commented on HIVE-10350: --- Fixed by HIVE-10369 CBO:

[jira] [Resolved] (HIVE-10369) CBO: Don't use HiveDefaultCostModel when With Tez and hive.cbo.costmodel.extended enabled

2015-04-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10369. --- Resolution: Fixed CBO: Don't use HiveDefaultCostModel when With Tez and

[jira] [Updated] (HIVE-10369) CBO: Don't use HiveDefaultCostModel when With Tez and hive.cbo.costmodel.extended enabled

2015-04-16 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10369: -- Attachment: HIVE-10369.patch CBO: Don't use HiveDefaultCostModel when With Tez

[jira] [Commented] (HIVE-10380) CBO (Calcite Return Path): Add QBId to TableScan digest

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14500426#comment-14500426 ] Laljo John Pullokkaran commented on HIVE-10380: --- [~jcamachorodriguez] Could

[jira] [Commented] (HIVE-10380) CBO (Calcite Return Path): Add QBId to TableScan digest

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14500593#comment-14500593 ] Laljo John Pullokkaran commented on HIVE-10380: --- +1 CBO (Calcite Return

[jira] [Commented] (HIVE-10268) Merge cbo branch into trunk

2015-04-18 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14501671#comment-14501671 ] Laljo John Pullokkaran commented on HIVE-10268: --- +1 Merge cbo branch into

[jira] [Updated] (HIVE-10243) CBO (Calcite Return Path): Introduce JoinAlgorithm Interface

2015-04-14 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10243: -- Summary: CBO (Calcite Return Path): Introduce JoinAlgorithm Interface (was:

[jira] [Resolved] (HIVE-10243) CBO (Calcite Return Path): Introduce JoinAlgorithm Interface

2015-04-14 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10243. --- Resolution: Fixed CBO (Calcite Return Path): Introduce JoinAlgorithm

[jira] [Updated] (HIVE-10386) CBO (Calcite Return Path): Disable Trivial Project Removal on ret path

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10386: -- Attachment: HIVE-10386.patch CBO (Calcite Return Path): Disable Trivial

[jira] [Updated] (HIVE-10380) CBO (Calcite Return Path): Add QBId to TableScan digest

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10380: -- Attachment: HIVE-10380.02.patch CBO (Calcite Return Path): Add QBId to

[jira] [Resolved] (HIVE-10380) CBO (Calcite Return Path): Add QBId to TableScan digest

2015-04-17 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10380. --- Resolution: Fixed CBO (Calcite Return Path): Add QBId to TableScan digest

[jira] [Assigned] (HIVE-10118) CBO (Calcite Return Path): Internal error: Cannot find common type for join keys

2015-04-06 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran reassigned HIVE-10118: - Assignee: Laljo John Pullokkaran (was: Jesus Camacho Rodriguez) CBO

[jira] [Commented] (HIVE-9727) GroupingID translation from Calcite

2015-04-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9727?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14483798#comment-14483798 ] Laljo John Pullokkaran commented on HIVE-9727: -- [~jcamachorodriguez] I think

[jira] [Commented] (HIVE-10040) CBO (Calcite Return Path): Pluggable cost modules [CBO branch]

2015-04-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14484004#comment-14484004 ] Laljo John Pullokkaran commented on HIVE-10040: --- [~jcamachorodriguez] As we

[jira] [Resolved] (HIVE-10040) CBO (Calcite Return Path): Pluggable cost modules [CBO branch]

2015-04-07 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10040. --- Resolution: Fixed CBO (Calcite Return Path): Pluggable cost modules [CBO

[jira] [Resolved] (HIVE-10262) CBO (Calcite Return Path): Temporarily disable Aggregate check input for bucketing

2015-04-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10262?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran resolved HIVE-10262. --- Resolution: Fixed CBO (Calcite Return Path): Temporarily disable Aggregate

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-04-10 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14490465#comment-14490465 ] Laljo John Pullokkaran commented on HIVE-10190: --- [~ sircodesalot] How does

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-04-09 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14488081#comment-14488081 ] Laljo John Pullokkaran commented on HIVE-10190: --- Submit your patch, i am

[jira] [Commented] (HIVE-10246) [CBO] Table alias should be stored with Scan object, instead of Table object

2015-04-09 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14487863#comment-14487863 ] Laljo John Pullokkaran commented on HIVE-10246: --- +1 [CBO] Table alias

[jira] [Commented] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-04-09 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14488076#comment-14488076 ] Laljo John Pullokkaran commented on HIVE-10190: --- [~Reuben] No need for

[jira] [Updated] (HIVE-10190) CBO: AST mode checks for TABLESAMPLE with AST.toString().contains(TOK_TABLESPLITSAMPLE)

2015-04-08 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10190: -- Assignee: Pengcheng Xiong (was: Laljo John Pullokkaran) CBO: AST mode checks

[jira] [Commented] (HIVE-10263) CBO (Calcite Return Path): Aggregate checking input for bucketing should be conditional

2015-04-09 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14488259#comment-14488259 ] Laljo John Pullokkaran commented on HIVE-10263: --- Checked in to CBO branch.

[jira] [Commented] (HIVE-10263) CBO (Calcite Return Path): Aggregate checking input for bucketing should be conditional

2015-04-09 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14487828#comment-14487828 ] Laljo John Pullokkaran commented on HIVE-10263: --- [~jcamachorodriguez]

[jira] [Updated] (HIVE-10244) Vectorization : TPC-DS Q80 fails with java.lang.ClassCastException when hive.vectorized.execution.reduce.enabled is enabled

2015-05-19 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10244?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10244: -- Assignee: Matt McCline (was: Jesus Camacho Rodriguez) Vectorization : TPC-DS

[jira] [Updated] (HIVE-10686) java.lang.IndexOutOfBoundsException for query with rank() over(partition ...)

2015-05-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10686: -- Fix Version/s: 1.2.1 java.lang.IndexOutOfBoundsException for query with rank()

[jira] [Commented] (HIVE-10627) Queries fail with Failed to breakup Windowing invocations into Groups

2015-05-20 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14552942#comment-14552942 ] Laljo John Pullokkaran commented on HIVE-10627: --- Based on [~sushanth] input

[jira] [Commented] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-06-02 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14568731#comment-14568731 ] Laljo John Pullokkaran commented on HIVE-10841: --- I have attached an

[jira] [Updated] (HIVE-10841) [WHERE col is not null] does not work sometimes for queries with many JOIN statements

2015-06-02 Thread Laljo John Pullokkaran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laljo John Pullokkaran updated HIVE-10841: -- Attachment: HIVE-10841.patch [WHERE col is not null] does not work sometimes

  1   2   3   4   >