[ https://issues.apache.org/jira/browse/DRILL-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-2103: --------------------------------- Priority: Critical (was: Major) > Queries with aggregate function on columns containing null values fail > ---------------------------------------------------------------------- > > Key: DRILL-2103 > URL: https://issues.apache.org/jira/browse/DRILL-2103 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Data Types > Reporter: Abhishek Girish > Assignee: Daniel Barclay (Drill/MapR) > Priority: Critical > Fix For: 0.9.0 > > Attachments: Create_views_store_sales.txt, agg_nulls.log > > > > describe store_sales; > ... > | ss_item_sk | INTEGER | NO | > ... > | ss_sales_price | DOUBLE | NO | > ... > > select count(*) from store_sales where ss_sales_price is NULL; > 129666 > > select count(*) from store_sales where ss_sales_price is NOT NULL; > 2750738 > > select avg(ss_item_sk) from store_sales; > Query failed: Query failed: Unexpected exception during fragment > initialization: Internal error: Error while applying rule > DrillReduceAggregatesRule, args > [rel#852769:AggregateRel.NONE.ANY([]).[](child=rel#852768:Subset#3.NONE.ANY([]).[],group={},EXPR$0=AVG($0))] > Error: exception while executing query: Failure while executing query. > (state=,code=0) > > select avg(ss_sales_price) from store_sales; > Query failed: Query failed: Unexpected exception during fragment > initialization: Internal error: Error while applying rule > DrillReduceAggregatesRule, args > [rel#851712:AggregateRel.NONE.ANY([]).[](child=rel#851711:Subset#3.NONE.ANY([]).[],group={},EXPR$0=AVG($0))] > Error: exception while executing query: Failure while executing query. > (state=,code=0) > Log attached. -- This message was sent by Atlassian JIRA (v6.3.4#6332)