[
https://issues.apache.org/jira/browse/DRILL-5768?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16318476#comment-16318476
]
Volodymyr Vysotskyi commented on DRILL-5768:
--------------------------------------------
On Drill with Calcite 1.15 error is thrown for this query. Added unit test in
https://github.com/apache/drill/pull/1066/commits/06f809baac88e230760bb3a1ce864c1e6bbafa33
> Drill planer should not allow select * with group by clause
> -----------------------------------------------------------
>
> Key: DRILL-5768
> URL: https://issues.apache.org/jira/browse/DRILL-5768
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.11.0
> Reporter: Jinfeng Ni
> Assignee: Roman Kulyk
>
> The following query should not be allowed in Drill planner.
> {code}
> select * from cp.`tpch/nation.parquet` group by n_regionkey;
> +----+
> | * |
> +----+
> | 0 |
> | 1 |
> | 4 |
> | 3 |
> | 2 |
> +----+
> {code}
> However, Drill allow such query to run and even worse the result is
> incorrect. It would make sense that we block such type of query.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
