[ https://issues.apache.org/jira/browse/DRILL-613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-613:
--------------------------------
Component/s: Query Planning & Optimization
> TPCH: query 10 fails with IndexOutOfBoundsException
> ---------------------------------------------------
>
> Key: DRILL-613
> URL: https://issues.apache.org/jira/browse/DRILL-613
> 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_custkey,
> c.c_name,
> sum(l.l_extendedprice * (1 - l.l_discount)) as revenue,
> c.c_acctbal,
> n.n_name,
> c.c_address,
> c.c_phone,
> c.c_comment
> from
> customer c,
> orders o,
> lineitem l,
> nation n
> where
> c.c_custkey = o.o_custkey
> and l.l_orderkey = o.o_orderkey
> and o.o_orderdate >= date '1994-03-01'
> and o.o_orderdate < date '1994-03-01' + interval '3' month
> and l.l_returnflag = 'R'
> and c.c_nationkey = n.n_nationkey
> group by
> c.c_custkey,
> c.c_name,
> c.c_acctbal,
> c.c_phone,
> n.n_name,
> c.c_address,
> c.c_comment
> order by
> revenue desc;
> The following exception is encountered:
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "31f98f15-fc8b-44f2-b4fc-d63475b51862"
> 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)