drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2306) Add support for grouping function
Date Wed, 25 Feb 2015 01:18:04 GMT
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)

Mime
View raw message