You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/02/25 02:18:04 UTC

[jira] [Created] (DRILL-2306) Add support for grouping function

Abhishek Girish created DRILL-2306:
--------------------------------------

             Summary: Add support for grouping function
                 Key: DRILL-2306
                 URL: https://issues.apache.org/jira/browse/DRILL-2306
             Project: Apache Drill
          Issue Type: Improvement
          Components: Query Planning & Optimization
    Affects Versions: 0.8.0
            Reporter: Abhishek Girish
            Assignee: Jinfeng Ni
             Fix For: Future


Add support for grouping function (grouping(<column>) returns 1 when column is used for grouping or 0 when column and all derivated values are NULL)

The following query fails to parse:

SELECT 
    grouping(c_first_name) 
FROM 
    customer
GROUP BY 
    c_first_name 
LIMIT 1;

Reference: TPC-DS queries (27, 36, ...) contain grouping functions



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)