You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Jim Scott (JIRA)" <ji...@apache.org> on 2014/08/02 05:51:38 UTC
[jira] [Created] (DRILL-1248) group by with an alias fails
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)