[DRILL-5768] Drill planer should not allow select * with group by clause

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.0
• Fix Version/s: 1.13.0
• Assignee: Roman Kulyk
• Reporter: Jinfeng Ni
• Created: 05/Sep/17 21:14
• Updated: 19/Jan/18 11:23
• Resolved: 19/Jan/18 09:38

Description

The following query should not be allowed in Drill planner.

select * from cp.`tpch/nation.parquet` group by n_regionkey;
+----+
| *  |
+----+
| 0  |
| 1  |
| 4  |
| 3  |
| 2  |
+----+

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.

Issue Links

• incorporates: DRILL-3993 Rebase Drill on Calcite master branch