Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5768

Drill planer should not allow select * with group by clause

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.11.0
    • 1.13.0
    • None
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              RomanKulyk Roman Kulyk
              jni Jinfeng Ni
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: