[ 
https://issues.apache.org/jira/browse/DRILL-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026925#comment-16026925
 ] 

Jinfeng Ni commented on DRILL-5537:
-----------------------------------

>From the change made in the PR, I'm not clear how/why the query result would 
>be impacted by an RDBMS storage plugin for the query.

{code}
select version, sum(1) as s from sys.version group by version;
{code}

Does the enabled RDBMS storage plugin have some impact on 
DrillReduceAggregatesRule.java rule? 

> 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
>
> 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)

Reply via email to