You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/05/29 18:59:03 UTC
[jira] [Resolved] (DRILL-615) TPCH: query 18 fails with
NullPointerException
[ https://issues.apache.org/jira/browse/DRILL-615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-615.
----------------------------------
Resolution: Fixed
> TPCH: query 18 fails with NullPointerException
> ----------------------------------------------
>
> Key: DRILL-615
> URL: https://issues.apache.org/jira/browse/DRILL-615
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Zhiyong Liu
> Priority: Blocker
>
> 1. Create TCP H dataset with a scale factor of about 500MB.
> 2. Run the following query in sqlline:
> select
> c.c_name,
> c.c_custkey,
> o.o_orderkey,
> o.o_orderdate,
> o.o_totalprice,
> sum(l.l_quantity)
> from
> customer c,
> orders o,
> lineitem l
> where
> o.o_orderkey in (
> select
> l_orderkey
> from
> lineitem
> group by
> l_orderkey having
> sum(l_quantity) > 300
> )
> and c.c_custkey = o.o_custkey
> and o.o_orderkey = l.l_orderkey
> group by
> c.c_name,
> c.c_custkey,
> o.o_orderkey,
> o.o_orderdate,
> o.o_totalprice
> order by
> o.o_totalprice desc,
> o.o_orderdate;
> The following exception is encountered:
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "f14b3f75-3d47-46cf-9af4-6ff80a34ca6b"
> endpoint {
> address: "perfnode104.perf.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < NullPointerException:[ Schema is currently null. You must call buildSchema(SelectionVectorMode) before this container can return a schema. ]"
> ]
> Error: exception while executing query (state=,code=0)
> In contrast, if this data source is used:
> http://apache-drill.s3.amazonaws.com/files/sf-0.01_tpc-h_parquet.tgz
> then query went through successfully.
--
This message was sent by Atlassian JIRA
(v6.2#6252)