[
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)
