[
https://issues.apache.org/jira/browse/DRILL-615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Parth Chandra updated DRILL-615:
--------------------------------
Component/s: Query Planning & Optimization
> TPCH: query 18 fails with NullPointerException
> ----------------------------------------------
>
> Key: DRILL-615
> URL: https://issues.apache.org/jira/browse/DRILL-615
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Zhiyong Liu
> Priority: Blocker
> Fix For: 0.4.0
>
>
> 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.3.4#6332)
