[
https://issues.apache.org/jira/browse/HIVE-9510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14298032#comment-14298032
]
Julian Hyde commented on HIVE-9510:
-----------------------------------
In Calcite, metadata providers are adapters. The Calcite engine will call into
the adapter, provided in this case by Hive, to get extra information. In this
case it only asks for extra information when you increase the logging level.
Calcite is assuming Hive implemented its metadata provider correctly but I am
guessing that it did not -- in which case, the error is in Hive code.
> 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)
