You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "wtf (Jira)" <ji...@apache.org> on 2021/05/18 15:57:00 UTC
[jira] [Created] (DRILL-7931) Rowtype mismatch
wtf created DRILL-7931:
--------------------------
Summary: Rowtype mismatch
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
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)