hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Damien Carol (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-9510) Throwing null point exception , when get join distinct row count from RelMdUtil.java class
Date Thu, 29 Jan 2015 20:07:36 GMT

     [ https://issues.apache.org/jira/browse/HIVE-9510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Damien Carol updated HIVE-9510:
-------------------------------
    Attachment: log.txt

> 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
>            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:



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message