drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim Scott (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1248) group by with an alias fails
Date Sat, 02 Aug 2014 03:51:38 GMT
Jim Scott created DRILL-1248:
--------------------------------

             Summary: group by with an alias fails
                 Key: DRILL-1248
                 URL: https://issues.apache.org/jira/browse/DRILL-1248
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
            Reporter: Jim Scott


when I select using a function and alias the resultant function value it won't parse properly
saying the alias is ambiguous. I know that this is a debatable / questionable topic, but with
this engine being so flexible it seems that in order to support all of the formatting, casting,
etc.. that will likely occur having the group by support an alias would be a big deal. This
in my opinion is nothing like an ordinal group by. 

This works:
select extract(year from to_date(crimes.datetime, 'MM/DD/YYYY hh:mm:ss a')) from BLAH group
by extract(year from to_date(crimes.datetime, 'MM/DD/YYYY hh:mm:ss a'));

This doesn't:
select extract(year from to_date(crimes.datetime, 'MM/DD/YYYY hh:mm:ss a')) as mygroup from
BLAH group by mygroup




--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message