[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284045#comment-15284045 ] Nemon Lou commented on HIVE-13602: -- Thanks [~pxiong] .It will be nice to provide a patch

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282881#comment-15282881 ] Pengcheng Xiong commented on HIVE-13602: Also thank [~nemon] for discovering this

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282880#comment-15282880 ] Pengcheng Xiong commented on HIVE-13602: rerun all the failed tests, none of them

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282660#comment-15282660 ] Hive QA commented on HIVE-13602: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15279583#comment-15279583 ] Pengcheng Xiong commented on HIVE-13602: attached a new patch to address the virtu

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15277859#comment-15277859 ] Hive QA commented on HIVE-13602: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15275236#comment-15275236 ] Hive QA commented on HIVE-13602: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272858#comment-15272858 ] Ashutosh Chauhan commented on HIVE-13602: - +1 pending tests > TPCH q16 return wro

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272740#comment-15272740 ] Pengcheng Xiong commented on HIVE-13602: [~aihuaxu], i submitted a new patch just

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272728#comment-15272728 ] Aihua Xu commented on HIVE-13602: - The patch makes sense to me. +1. Not sure if the fail

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272701#comment-15272701 ] Pengcheng Xiong commented on HIVE-13602: [~ashutoshc] and [~aihuaxu], could u plea

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15268689#comment-15268689 ] Aihua Xu commented on HIVE-13602: - [~pxiong] Can you create a RB so it will be easier to r

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15267031#comment-15267031 ] Hive QA commented on HIVE-13602: Here are the results of testing the latest attachment:

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15257398#comment-15257398 ] Nemon Lou commented on HIVE-13602: -- It's 24581 on my computer. I must have checked the wr

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15257234#comment-15257234 ] Pengcheng Xiong commented on HIVE-13602: [~nemon], I tried the following query (I

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15257042#comment-15257042 ] Pengcheng Xiong commented on HIVE-13602: [~ashutoshc], enable the CBO, set hive.op

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256543#comment-15256543 ] Ashutosh Chauhan commented on HIVE-13602: - [~nemon] If HIVE-11104 is the culprit t

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15256275#comment-15256275 ] Nemon Lou commented on HIVE-13602: -- The result is right when using hive 1.2.1. After som

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255976#comment-15255976 ] Nemon Lou commented on HIVE-13602: -- I just copy it from the result of "explain rewrite q1

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255964#comment-15255964 ] Nemon Lou commented on HIVE-13602: -- >From calcite rel plan ,we can see the p_brand column

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255953#comment-15255953 ] Pengcheng Xiong commented on HIVE-13602: what is {code} 1 = 1 {code} in the where

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255950#comment-15255950 ] Pengcheng Xiong commented on HIVE-13602: [~nemon], if p_brand is missing, i would

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255937#comment-15255937 ] Nemon Lou commented on HIVE-13602: -- The join order seems to be the same for both queries.

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255921#comment-15255921 ] Pengcheng Xiong commented on HIVE-13602: [~nemon], could u also post the explain p

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255914#comment-15255914 ] Nemon Lou commented on HIVE-13602: -- Another information : after rewrite q16 into the foll

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255900#comment-15255900 ] Pengcheng Xiong commented on HIVE-13602: [~nemon], do you have all the table/colum

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255897#comment-15255897 ] Nemon Lou commented on HIVE-13602: -- I used MR engine. The attachment is bigger than 50K

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15255892#comment-15255892 ] Pengcheng Xiong commented on HIVE-13602: cc'ing [~ashutoshc] and [~hagleitn]. [~ne