Rahul Challapalli created DRILL-3785:
----------------------------------------
Summary: AssertionError in FindPartitionConditions.java
Key: DRILL-3785
URL: https://issues.apache.org/jira/browse/DRILL-3785
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Rahul Challapalli
Assignee: Jinfeng Ni
git.commit.id.abbrev=240a455
I am running the drillbits with assertions enabled and the below query is
producing an AssertionError
{code}
explain plan for
select
l_returnflag,
l_linestatus,
sum(l_quantity) as sum_qty,
sum(l_extendedprice) as sum_base_price,
sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
avg(l_quantity) as avg_qty,
avg(l_extendedprice) as avg_price,
avg(l_discount) as avg_disc,
count(*) as count_order
from
`lineitem`
where
dir0=2006 or dir0=2007 and
l_shipdate <= date '1998-12-01' - interval '120' day (3)
group by
l_returnflag,
l_linestatus
order by
l_returnflag,
l_linestatus;
{code}
I tried running the same query immediately again, but the error did not show up.
The data set used is tpch sf100 where the lineitem data set is split into 200K
parquet files and stored using the below structure
Data Set Structure :
{code}
lineitem
-- 2006 (year)
-- 1 (month)
-- 1 (day)
..
..
-- 31(day)
..
-- 12 (month)
..
..
2015(year)
{code}
Log file is attached
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
