[ https://issues.apache.org/jira/browse/DRILL-4473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau updated DRILL-4473: ---------------------------------- Assignee: Sean Hsuan-Yi Chu > Removing trivial projects reveals bugs in handling of nonexistent columns in > StreamingAggregate > ----------------------------------------------------------------------------------------------- > > Key: DRILL-4473 > URL: https://issues.apache.org/jira/browse/DRILL-4473 > Project: Apache Drill > Issue Type: Bug > Reporter: Jacques Nadeau > Assignee: Sean Hsuan-Yi Chu > > We see a couple unit test failures in working with nonexistent columns once > DRILL-4467 is fixed. This is because trivial projects no longer protect > StreamingAggregate from non-existent columns. This is likely due to an > incorrect check before throwing a Unsupported error. An unknown/ANY type > should probably be allowed in the case of using sum/max/stddev > {code:title=Plan before DRILL-4467} > VOLCANO:Physical Planning (71ms): > ScreenPrel: rowcount = 1.0, cumulative cost = {464.1 rows, 2375.1 cpu, 0.0 > io, 0.0 network, 0.0 memory}, id = 185 > ProjectPrel(col1=[$0], col2=[$1], col3=[$2], col4=[$3], col5=[$4]): > rowcount = 1.0, cumulative cost = {464.0 rows, 2375.0 cpu, 0.0 io, 0.0 > network, 0.0 memory}, id = 184 > StreamAggPrel(group=[{}], col1=[SUM($0)], col2=[SUM($1)], col3=[SUM($2)], > col4=[SUM($3)], col5=[SUM($4)]): rowcount = 1.0, cumulative cost = {464.0 > rows, 2375.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 183 > LimitPrel(offset=[0], fetch=[0]): rowcount = 1.0, cumulative cost = > {463.0 rows, 2315.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 182 > ProjectPrel(int_col=[$0], bigint_col=[$3], float4_col=[$4], > float8_col=[$1], interval_year_col=[$2]): rowcount = 463.0, cumulative cost = > {463.0 rows, 2315.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 181 > ScanPrel(groupscan=[EasyGroupScan > [selectionRoot=classpath:/employee.json, numFiles=1, columns=[`int_col`, > `bigint_col`, `float4_col`, `float8_col`, `interval_year_col`], > files=[classpath:/employee.json]]]): rowcount = 463.0, cumulative cost = > {463.0 rows, 2315.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 160 > {code} > {code:title=Plan after DRILL-4467} > VOLCANO:Physical Planning (63ms): > ScreenPrel: rowcount = 1.0, cumulative cost = {464.1 rows, 2375.1 cpu, 0.0 > io, 0.0 network, 0.0 memory}, id = 151 > ProjectPrel(col1=[$0], col2=[$1], col3=[$2], col4=[$3], col5=[$4]): > rowcount = 1.0, cumulative cost = {464.0 rows, 2375.0 cpu, 0.0 io, 0.0 > network, 0.0 memory}, id = 150 > StreamAggPrel(group=[{}], col1=[SUM($0)], col2=[SUM($1)], col3=[SUM($2)], > col4=[SUM($3)], col5=[SUM($4)]): rowcount = 1.0, cumulative cost = {464.0 > rows, 2375.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 149 > LimitPrel(offset=[0], fetch=[0]): rowcount = 1.0, cumulative cost = > {463.0 rows, 2315.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 148 > ScanPrel(groupscan=[EasyGroupScan > [selectionRoot=classpath:/employee.json, numFiles=1, columns=[`int_col`, > `bigint_col`, `float4_col`, `float8_col`, `interval_year_col`], > files=[classpath:/employee.json]]]): rowcount = 463.0, cumulative cost = > {463.0 rows, 2315.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 141 > Tests disabled referring to this bug in TestAggregateFunctions show multiple > examples of this behavior. -- This message was sent by Atlassian JIRA (v6.3.4#6332)