[jira] [Commented] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-22 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14375123#comment-14375123 ] Pengcheng Xiong commented on HIVE-9859: --- ccing ANTLR expert [~rhbutani] to see if he

[jira] [Commented] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-21 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14372931#comment-14372931 ] Pengcheng Xiong commented on HIVE-9859: --- [~jdere], I took a look last night and I

[jira] [Commented] (HIVE-9859) Create bitwise left/right shift UDFs

2015-03-20 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14372074#comment-14372074 ] Pengcheng Xiong commented on HIVE-9859: --- [~jdere], I will take a look tonight and get

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-09 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.24.patch Reduce ambiguity in grammar ---

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-09 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.25.patch update golden file for keyword inner Reduce ambiguity in

[jira] [Commented] (HIVE-6617) Reduce ambiguity in grammar

2015-03-07 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14351760#comment-14351760 ] Pengcheng Xiong commented on HIVE-6617: --- [~ashutoshc], i just noticed that

[jira] [Commented] (HIVE-6617) Reduce ambiguity in grammar

2015-03-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14355206#comment-14355206 ] Pengcheng Xiong commented on HIVE-6617: --- [~ashutoshc], HIVE-6617.25 is the patch that

[jira] [Commented] (HIVE-6617) Reduce ambiguity in grammar

2015-03-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14355200#comment-14355200 ] Pengcheng Xiong commented on HIVE-6617: --- [~ashutoshc], both patches passed. I updated

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.26.patch test backward compatibility again. Reduce ambiguity in grammar

[jira] [Reopened] (HIVE-6617) Reduce ambiguity in grammar

2015-03-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reopened HIVE-6617: --- Reduce ambiguity in grammar --- Key: HIVE-6617

[jira] [Commented] (HIVE-6617) Reduce ambiguity in grammar

2015-03-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14355822#comment-14355822 ] Pengcheng Xiong commented on HIVE-6617: --- The 74 reserved key words are ALL, ALTER,

[jira] [Updated] (HIVE-9780) Add another level of explain for RDBMS audience

2015-03-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9780: -- Attachment: HIVE-9780.03.patch Add another level of explain for RDBMS audience

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-03 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: parser.png Performance comparison between the old parser and the proposed new parser

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-04 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.23.patch in this patch, we enable the support for SQL 2011 reserved

[jira] [Commented] (HIVE-9840) select count(*) tablename should give exception

2015-03-04 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14347660#comment-14347660 ] Pengcheng Xiong commented on HIVE-9840: --- [~pradeep_bhadani], the logic behind this

[jira] [Commented] (HIVE-6617) Reduce ambiguity in grammar

2015-03-04 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14347877#comment-14347877 ] Pengcheng Xiong commented on HIVE-6617: --- not sure why TestCompactionTxnHandler

[jira] [Commented] (HIVE-9840) select count(*) tablename should give exception

2015-03-03 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14346487#comment-14346487 ] Pengcheng Xiong commented on HIVE-9840: --- (1) When there is no from clause,

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-03 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.22.patch test backward compatibiltiy Reduce ambiguity in grammar

[jira] [Commented] (HIVE-9840) select count(*) tablename should give exception

2015-03-03 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14345389#comment-14345389 ] Pengcheng Xiong commented on HIVE-9840: --- [~pradeep_bhadani], I tried mysql and

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-03-01 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.21.patch test the backward compatibility Reduce ambiguity in grammar

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-02-26 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.20.patch The patch with new set of keywords passed. Now I attached a patch

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-02-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: (was: HIVE-6617.19.patch) Reduce ambiguity in grammar

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-02-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.19.patch Reduce ambiguity in grammar ---

[jira] [Updated] (HIVE-6617) Reduce ambiguity in grammar

2015-02-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-6617: -- Attachment: HIVE-6617.19.patch Reduce ambiguity in grammar ---

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

2015-03-27 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Attachment: HIVE-10120.01.patch Disallow create table with dot/colon in column name

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

2015-03-27 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Description: Since we don't allow users to query column names with dot in the middle such as

[jira] [Updated] (HIVE-9780) Add another level of explain for RDBMS audience

2015-03-26 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9780: -- Attachment: HIVE-9780.04.patch Add another level of explain for RDBMS audience

[jira] [Commented] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-03-26 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14382588#comment-14382588 ] Pengcheng Xiong commented on HIVE-10062: The two failed test cases are unrelated

[jira] [Commented] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-03-26 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14382599#comment-14382599 ] Pengcheng Xiong commented on HIVE-10062: The RB is ready. [~hagleitn] and

[jira] [Assigned] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-03-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-10062: -- Assignee: Pengcheng Xiong HiveOnTez: Union followed by Multi-GB followed by

[jira] [Updated] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-03-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10062: --- Attachment: HIVE-10062.01.patch a quick try to fix it. HiveOnTez: Union followed by

[jira] [Updated] (HIVE-9780) Add another level of explain for RDBMS audience

2015-03-27 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9780: -- Attachment: HIVE-9780.06.patch following [~mmokhtar]'s suggestion, add cbo info for this

[jira] [Commented] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-03-23 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14376639#comment-14376639 ] Pengcheng Xiong commented on HIVE-10062: The explain results told us: {code}

[jira] [Updated] (HIVE-9780) Add another level of explain for RDBMS audience

2015-04-02 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9780: -- Attachment: HIVE-9780.08.patch address Ashutosh's comments, take into consideration of Mostafa's

[jira] [Updated] (HIVE-9780) Add another level of explain for RDBMS audience

2015-04-03 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9780: -- Attachment: HIVE-9780.09.patch add a missing import package Add another level of explain for

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

2015-04-20 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14503683#comment-14503683 ] Pengcheng Xiong commented on HIVE-10120: [~jpullokkaran] and [~ashutoshc], I

[jira] [Updated] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10455: --- Attachment: HIVE-10455.02.patch CBO (Calcite Return Path): Different data types at Reducer

[jira] [Commented] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-25 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14512819#comment-14512819 ] Pengcheng Xiong commented on HIVE-10455: [~jcamachorodriguez], I agree with you

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

2015-04-22 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14507458#comment-14507458 ] Pengcheng Xiong commented on HIVE-10391: [~ashutoshc], im not sure if we can

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

2015-04-22 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14507594#comment-14507594 ] Pengcheng Xiong commented on HIVE-10391: [~ashutoshc], as I just tested,

[jira] [Commented] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-24 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14511455#comment-14511455 ] Pengcheng Xiong commented on HIVE-10455: [~jcamachorodriguez], as per

[jira] [Updated] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-24 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10455: --- Attachment: HIVE-10455.01.patch CBO (Calcite Return Path): Different data types at Reducer

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

2015-04-20 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14503189#comment-14503189 ] Pengcheng Xiong commented on HIVE-10400: Tested this with cbo_limit.q. Test

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

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

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

2015-04-28 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10522: --- Attachment: HIVE-10522.02.patch It seems that it needs more work. CBO (Calcite Return

[jira] [Commented] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-04-30 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14521792#comment-14521792 ] Pengcheng Xiong commented on HIVE-9392: --- [~prasanth_j] and [~mohammedmostafa], could

[jira] [Commented] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-30 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522081#comment-14522081 ] Pengcheng Xiong commented on HIVE-10455: As per [~jpullokkaran]'s request,

[jira] [Commented] (HIVE-10549) CBO (Calcite Return Path): Enable NonBlockingOpDeDupProc

2015-05-01 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523424#comment-14523424 ] Pengcheng Xiong commented on HIVE-10549: The test failures are not related.

[jira] [Commented] (HIVE-10546) genFileSinkPlan should use the generated SEL's RR for the partition col of FS

2015-05-01 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14523426#comment-14523426 ] Pengcheng Xiong commented on HIVE-10546: [~ashutoshc] and [~jpullokkaran], the

[jira] [Commented] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-30 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14522591#comment-14522591 ] Pengcheng Xiong commented on HIVE-10455: We need HIVE-10479 so that all the cbo

[jira] [Updated] (HIVE-10455) CBO (Calcite Return Path): Different data types at Reducer before JoinOp

2015-04-30 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10455: --- Attachment: HIVE-10455.03.patch rebased the patch according to [~ashutoshc]'s comments. Now,

[jira] [Updated] (HIVE-10549) CBO (Calcite Return Path): Enable NonBlockingOpDeDupProc

2015-04-29 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10549: --- Summary: CBO (Calcite Return Path): Enable NonBlockingOpDeDupProc (was: Enable

[jira] [Updated] (HIVE-10549) CBO (Calcite Return Path): Enable NonBlockingOpDeDupProc

2015-04-29 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10549: --- Attachment: HIVE-10549.01.patch CBO (Calcite Return Path): Enable NonBlockingOpDeDupProc

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

2015-04-28 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10522: --- Attachment: HIVE-10522.01.patch CBO (Calcite Return Path): fix the wrong needed column names

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: (was: HIVE-9392.01.patch) JoinStatsRule miscalculates join cardinality as

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.3.patch JoinStatsRule miscalculates join cardinality as incorrect NDV is

[jira] [Commented] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529626#comment-14529626 ] Pengcheng Xiong commented on HIVE-9392: --- rename the patch to get QA run.

[jira] [Commented] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529623#comment-14529623 ] Pengcheng Xiong commented on HIVE-9392: --- [~mmokhtar], could you please take a look?

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.4.patch JoinStatsRule miscalculates join cardinality as incorrect NDV is

[jira] [Assigned] (HIVE-8769) Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected)

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-8769: - Assignee: Pengcheng Xiong (was: Prasanth Jayachandran) Physical optimizer : Incorrect

[jira] [Commented] (HIVE-8769) Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected)

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14529498#comment-14529498 ] Pengcheng Xiong commented on HIVE-8769: --- [~mohammedmostafa], I ran it with 1GB TPCDS

[jira] [Resolved] (HIVE-10547) CBO (Calcite Return Path) : genFileSinkPlan uses wrong partition col to create FS

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10547?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong resolved HIVE-10547. Resolution: Fixed CBO (Calcite Return Path) : genFileSinkPlan uses wrong partition col to

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-05 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.01.patch After discussing with [~jpullokkaran], we assume that this patch

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-07 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.5.patch JoinStatsRule miscalculates join cardinality as incorrect NDV is

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-06 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: (was: HIVE-9392.4.patch) JoinStatsRule miscalculates join cardinality as

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-06 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.4.patch JoinStatsRule miscalculates join cardinality as incorrect NDV is

[jira] [Updated] (HIVE-9392) JoinStatsRule miscalculates join cardinality as incorrect NDV is used due to column names having duplicated fqColumnName

2015-05-10 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9392: -- Attachment: HIVE-9392.6.patch patch without q files updated. JoinStatsRule miscalculates join

[jira] [Updated] (HIVE-8769) Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected)

2015-05-12 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-8769: -- Attachment: HIVE-8769.01.patch Physical optimizer : Incorrect CE results in a shuffle join

[jira] [Commented] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).

2015-05-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14544177#comment-14544177 ] Pengcheng Xiong commented on HIVE-10698: According to [~jpullokkaran]'s comments,

[jira] [Assigned] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).

2015-05-13 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-10698: -- Assignee: Pengcheng Xiong query on view results fails with table not found error if

[jira] [Updated] (HIVE-8769) Physical optimizer : Incorrect CE results in a shuffle join instead of a Map join (PK/FK pattern not detected)

2015-05-13 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-8769: -- Attachment: HIVE-8769.02.patch Physical optimizer : Incorrect CE results in a shuffle join

[jira] [Commented] (HIVE-9897) Issue a warning when using an existing table/view name as an alias in a with statement.

2015-05-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9897?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14544680#comment-14544680 ] Pengcheng Xiong commented on HIVE-9897: --- I agree with [~hagleitn] and [~jpullokkaran]

[jira] [Commented] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).

2015-05-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14544679#comment-14544679 ] Pengcheng Xiong commented on HIVE-10698: We will address this in this patch, i.e.,

[jira] [Commented] (HIVE-10731) NullPointerException in HiveParser.g

2015-05-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14546282#comment-14546282 ] Pengcheng Xiong commented on HIVE-10731: Could you post the environment and the

[jira] [Commented] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).

2015-05-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14545781#comment-14545781 ] Pengcheng Xiong commented on HIVE-10698: [~jpullokkaran], the failed tests are

[jira] [Updated] (HIVE-10731) NullPointerException in HiveParser.g

2015-05-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10731: --- Attachment: HIVE-10731.01.patch NullPointerException in HiveParser.g

[jira] [Commented] (HIVE-10731) NullPointerException in HiveParser.g

2015-05-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14549302#comment-14549302 ] Pengcheng Xiong commented on HIVE-10731: I see that you are leveraging HiveParser

[jira] [Assigned] (HIVE-10731) NullPointerException in HiveParser.g

2015-05-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-10731: -- Assignee: Pengcheng Xiong NullPointerException in HiveParser.g

[jira] [Updated] (HIVE-10698) query on view results fails with table not found error if view is created with subquery alias (CTE).

2015-05-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10698: --- Attachment: HIVE-10698.01.patch first patch, may need to update q files. query on view

[jira] [Resolved] (HIVE-6950) Parsing Error in GROUPING SETS

2015-04-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-6950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong resolved HIVE-6950. --- Resolution: Fixed Fix Version/s: 1.2.0 Assignee: Pengcheng Xiong Release

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

2015-04-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10344: --- Summary: CBO (Calcite Return Path): Use newInstance to create ExprNodeGenericFuncDesc rather

[jira] [Updated] (HIVE-10332) CBO (Calcite Return Path): Use SortExchange rather than LogicalExchange for HiveOpConverter

2015-04-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10332: --- Summary: CBO (Calcite Return Path): Use SortExchange rather than LogicalExchange for

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

2015-04-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10344: --- Attachment: HIVE-10344.01.patch CBO (Calcite Return Path): Use newInstance to create

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

2015-04-15 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14496884#comment-14496884 ] Pengcheng Xiong commented on HIVE-10344: [~jpullokkaran], after this patch, the

[jira] [Updated] (HIVE-10377) CBO (Calcite Return Path): move qbid from RelOptHiveTable to HiveTableScan

2015-04-17 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10377: --- Attachment: HIVE-10377.01.patch passed the cbo tests. [~ashutoshc], could you please take a

[jira] [Assigned] (HIVE-10375) CBO (Calcite Return Path): disable the identity project remover for some union operators

2015-04-17 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-10375: -- Assignee: Pengcheng Xiong CBO (Calcite Return Path): disable the identity project

[jira] [Commented] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-04-13 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14492637#comment-14492637 ] Pengcheng Xiong commented on HIVE-10062: [~hagleitn], the test failures are not

[jira] [Updated] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-04-12 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10062: --- Attachment: HIVE-10062.04.patch address test failures HiveOnTez: Union followed by Multi-GB

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

2015-04-17 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14500756#comment-14500756 ] Pengcheng Xiong commented on HIVE-10380: This patch + (HIVE-10375) works for

[jira] [Resolved] (HIVE-10375) CBO (Calcite Return Path): disable the identity project remover for some union operators

2015-04-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong resolved HIVE-10375. Resolution: Fixed CBO (Calcite Return Path): disable the identity project remover for some

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

2015-04-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-10391: -- Assignee: Pengcheng Xiong CBO (Calcite Return Path): HiveOpConverter always assumes

[jira] [Commented] (HIVE-10375) CBO (Calcite Return Path): disable the identity project remover for some union operators

2015-04-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14501649#comment-14501649 ] Pengcheng Xiong commented on HIVE-10375: resolved in HIVE-10386 CBO (Calcite

[jira] [Commented] (HIVE-10332) Use SortExchange rather than LogicalExchange for HiveOpConverter

2015-04-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14495448#comment-14495448 ] Pengcheng Xiong commented on HIVE-10332: [~ashutoshc], could u please review it

[jira] [Updated] (HIVE-10332) Use SortExchange rather than LogicalExchange for HiveOpConverter

2015-04-14 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10332?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10332: --- Attachment: HIVE-10332.01.patch [~jcamachorodriguez], if LogicalExchange is never used later,

[jira] [Updated] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-04-06 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9647: -- Attachment: HIVE-9647.02.patch address the metastore configuration flag Discrepancy in

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

2015-04-07 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10120: --- Attachment: HIVE-10120.02.patch address [~swarnim]'s comments. Disallow create table with

[jira] [Commented] (HIVE-9780) Add another level of explain for RDBMS audience

2015-04-04 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14395590#comment-14395590 ] Pengcheng Xiong commented on HIVE-9780: --- [~ashutoshc], the test failures are

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

2015-04-08 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14485523#comment-14485523 ] Pengcheng Xiong commented on HIVE-10120: [~ashutoshc], the test failures are

[jira] [Updated] (HIVE-10062) HiveOnTez: Union followed by Multi-GB followed by Multi-insert loses data

2015-04-09 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-10062: --- Attachment: HIVE-10062.02.patch address [~hagleitn]'s comments. HiveOnTez: Union followed

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

2015-04-08 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14486058#comment-14486058 ] Pengcheng Xiong commented on HIVE-10190: I would prefer a BFS rather than a DFS.

  1   2   3   4   5   6   7   8   9   10   >