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

Aggregation with group by clause

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Not A Bug
    • Affects Version/s: 1.14.0
    • Fix Version/s: 1.14.0
    • Component/s: Functions - Drill
    • Labels:

      Description

      Facing some issues with the following case:

      Json file (sample.json) is having the following content:

      {"a":2,"b":null} {"a":2,"b":null} {"a":3,"b":null} {"a":4,"b":null}

      Query:

      SELECT a, sum(b) FROM dfs.`C:\\Users\\user\\Desktop
      sample.json` group by a;

      Error:

      UNSUPPORTED_OPERATION ERROR: Only COUNT, MIN and MAX aggregate functions supported for VarChar type

      Observation:

      If we query without using group by, then it is working fine without any error. If group by is used, then sum of null values is throwing the above error.

       

      Can anyone please let us know the solution for this or if there are any alternative.

        Attachments

          Activity

            People

            • Assignee:
              lhfei Hefei Li
              Reporter:
              Gayathri01 Gayathri
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: