[
https://issues.apache.org/jira/browse/DRILL-7931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
wtf updated DRILL-7931:
-----------------------
Description:
It's work correct for example in case when there is only one aggregation:
select col1, stddev(col2) FROM(values ('UA', 3), ('USA', 2), ('UA', 3), ('USA',
5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1 LIMIT 6;
Or when it's after other aggregations:
select col1, SUM(col2), stddev(col2) FROM (values ('UA', 3), ('USA', 2), ('UA',
3), ('USA', 5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1 LIMIT 6;
But when we try to put it before an aggregation, like SUM:
select col1, stddev(col2), SUM(col2) FROM (values ('UA', 3), ('USA', 2), ('UA',
3), ('USA', 5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1 LIMIT 6;
It's failed with error:
SYSTEM ERROR: AssertionError: Type mismatch:
rowtype of new rel:
RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL $f3,
BIGINT $f4) NOT NULL
rowtype of set:
RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL $f3,
BIGINT NOT NULL $f4) NOT NULL
Same for stddev_samp
was:
It's work correct for example in case when there is only one aggregation:
{{select col1, stddev(col2) FROM}}
{{ (values ('UA', 3), ('USA', 2), ('UA', 3), ('USA', 5), ('USA', 1), ('UA',
9)) x(col1, col2) GROUP BY col1 LIMIT 6;}}
{{}}Or when it's after other aggregations:
{{select col1, SUM(col2), stddev(col2) FROM}}
{{ (values ('UA', 3), ('USA', 2), ('UA', 3), ('USA', 5), ('USA', 1), ('UA',
9)) x(col1, col2) GROUP BY col1 LIMIT 6;}}
{{}}But when we try to put it before an aggregation, like SUM:
{{}}
{{}}{{select col1, stddev(col2), SUM(col2) FROM}}
{{ (values ('UA', 3), ('USA', 2), ('UA', 3), ('USA', 5), ('USA', 1), ('UA',
9)) x(col1, col2) GROUP BY col1 LIMIT 6;}}{{}}
{{}}It's failed with error:
{{SYSTEM ERROR: AssertionError: Type mismatch:}}
{{rowtype of new rel:}}
{{RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL
$f3, BIGINT $f4) NOT NULL}}
{{rowtype of set:}}
{{RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL
$f3, BIGINT NOT NULL $f4) NOT NULL}}
{{}}Same for {{stddev_samp}}
Summary: Rowtype mismatch in DrillReduceAggregatesRule (was: Rowtype
mismatch)
> Rowtype mismatch in DrillReduceAggregatesRule
> ---------------------------------------------
>
> Key: DRILL-7931
> URL: https://issues.apache.org/jira/browse/DRILL-7931
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.18.0
> Reporter: wtf
> Assignee: wtf
> Priority: Major
>
> It's work correct for example in case when there is only one aggregation:
> select col1, stddev(col2) FROM(values ('UA', 3), ('USA', 2), ('UA', 3),
> ('USA', 5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1 LIMIT 6;
> Or when it's after other aggregations:
> select col1, SUM(col2), stddev(col2) FROM (values ('UA', 3), ('USA', 2),
> ('UA', 3), ('USA', 5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1
> LIMIT 6;
> But when we try to put it before an aggregation, like SUM:
> select col1, stddev(col2), SUM(col2) FROM (values ('UA', 3), ('USA', 2),
> ('UA', 3), ('USA', 5), ('USA', 1), ('UA', 9)) x(col1, col2) GROUP BY col1
> LIMIT 6;
> It's failed with error:
> SYSTEM ERROR: AssertionError: Type mismatch:
> rowtype of new rel:
> RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL
> $f3, BIGINT $f4) NOT NULL
> rowtype of set:
> RecordType(CHAR(3) NOT NULL col1, BIGINT $f1, BIGINT $f2, BIGINT NOT NULL
> $f3, BIGINT NOT NULL $f4) NOT NULL
> Same for stddev_samp
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
