[ 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/column stats for all the tables? Could u attach the explain results for CBO on and off? Thanks. > TPCH q16 return wrong result when CBO is on > ------------------------------------------- > > Key: HIVE-13602 > URL: https://issues.apache.org/jira/browse/HIVE-13602 > Project: Hive > Issue Type: Bug > Components: CBO, Logical Optimizer > Affects Versions: 1.2.1 > Reporter: Nemon Lou > Assignee: Pengcheng Xiong > > Running tpch with factor 2, > q16 returns 1,160 rows when CBO is on, > while returns 59,616 rows when CBO is off. > See attachment for detail . -- This message was sent by Atlassian JIRA (v6.3.4#6332)