[
https://issues.apache.org/jira/browse/DRILL-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16030902#comment-16030902
]
Arina Ielchiieva commented on DRILL-5537:
-----------------------------------------
[~jni] thank you for code review. You are right, for example, count function
does the same:
{noformat}
0: jdbc:drill:zk=local> explain plan for select count(1) as cnt from
sys.version;
+------+------+
| text | json |
+------+------+
| 00-00 Screen
00-01 Project(cnt=[$0])
00-02 StreamAgg(group=[{}], cnt=[COUNT($0)])
00-03 Project($f0=[1])
00-04 Scan(groupscan=[SystemTableScan [table=VERSION,
distributed=false]])
{noformat}
> Display columns alias for queries with sum() when RDBMS storage plugin is
> enabled
> ---------------------------------------------------------------------------------
>
> Key: DRILL-5537
> URL: https://issues.apache.org/jira/browse/DRILL-5537
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: Arina Ielchiieva
> Assignee: Arina Ielchiieva
> Labels: ready-to-commit
>
> When [RDBMS storage
> plugin|https://drill.apache.org/docs/rdbms-storage-plugin/] is enabled,
> alias is not displayed for column with sum function:
> {noformat}
> 0: jdbc:drill:zk=local> select version, sum(1) as s from sys.version group by
> version;
> +------------------+------+
> | version | $f1 |
> +------------------+------+
> | 1.11.0-SNAPSHOT | 1 |
> +------------------+------+
> 1 row selected (0.444 seconds)
> {noformat}
> Other functions like avg, count are not affected.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
