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)