[ https://issues.apache.org/jira/browse/HIVE-9510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14298018#comment-14298018 ]
asko commented on HIVE-9510: ---------------------------- Thanks! When i set org.apache.calcite.plan.RelOptPlanner.level=FINE , it could be executed correctly. So i don't agree with you say.What do you think? > Throwing null point exception , when get join distinct row count from > RelMdUtil.java class > ------------------------------------------------------------------------------------------ > > Key: HIVE-9510 > URL: https://issues.apache.org/jira/browse/HIVE-9510 > Project: Hive > Issue Type: Bug > Components: CBO > Reporter: asko > Assignee: Julian Hyde > Attachments: log.txt, log3_cbo5 > > > Setting log level in logging.properties file as following: > {noformat} > handlers=java.util.logging.ConsoleHandler.level=INFO > org.apache.calcite.plan.RelOptPlanner.level=ALL > java.util.logging.ConsoleHandler.level=ALL > {noformat} > Running Q3 in TPCH-full after modifying , in order to test join reorder, > but running failed. > QL: > {code:sql} > set hive.cbo.enable=true; > --ANALYZE TABLE customer COMPUTE STATISTICS for columns; > --ANALYZE TABLE orders COMPUTE STATISTICS for columns; > --ANALYZE TABLE lineitem COMPUTE STATISTICS for columns; > --Q3 > -- the query > select > l_orderkey, sum(l_extendedprice*(1-l_discount)) as revenue, o_orderdate, > o_shippriority > from > lineitem l join orders o > on l.l_orderkey = o.o_orderkey > join customer c > on c.c_mktsegment = 'BUILDING' and c.c_custkey = o.o_custkey > where > o_orderdate < '1995-03-15' and l_shipdate > '1995-03-15' > group by l_orderkey, o_orderdate, o_shippriority > order by revenue desc, o_orderdate > limit 10; > {code} > LOG: > <see log.txt> -- This message was sent by Atlassian JIRA (v6.3.4#6332)