[ 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)