You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2017/09/05 21:15:00 UTC
[jira] [Created] (DRILL-5768) Drill planer should not allow select
* with group by clause
Jinfeng Ni created DRILL-5768:
---------------------------------
Summary: 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
Reporter: Jinfeng Ni
Assignee: Jinfeng Ni
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)