You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/10/09 18:39:26 UTC

[jira] [Updated] (DRILL-3785) AssertionError in FindPartitionConditions.java

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

Rahul Challapalli updated DRILL-3785:
-------------------------------------
    Fix Version/s:     (was: Future)
                   1.3.0

> 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
>             Fix For: 1.3.0
>
>         Attachments: error (4).log
>
>
> 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)