tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JaeHwa Jung (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (TAJO-163) CountValueFunctionExpr can't handle DISTINCT clause
Date Thu, 05 Sep 2013 16:50:54 GMT

     [ https://issues.apache.org/jira/browse/TAJO-163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

JaeHwa Jung updated TAJO-163:
-----------------------------

    Summary: CountValueFunctionExpr can't handle DISTINCT clause  (was: CountValueFunctionExpr
can't handle DISTNCT clause)
    
> CountValueFunctionExpr can't handle DISTINCT clause
> ---------------------------------------------------
>
>                 Key: TAJO-163
>                 URL: https://issues.apache.org/jira/browse/TAJO-163
>             Project: Tajo
>          Issue Type: Bug
>            Reporter: JaeHwa Jung
>
>   I tested COUNT function as follows:
> {code:xml}
> select reg_date, count(distinct(member_id)) from member_info group by reg_date order
by reg_date
> {code}
> As a result, SQLAnalyzer printed as follows:
> {code:xml}
> {
>   "all": false,
>   "distinct": false,
>   "targets": [
>     {
>       "expr": {
>         "name": "reg_date",
>         "opType": "Column"
>       },
>       "opType": "Target"
>     },
>     {
>       "alias": "member_id",
>       "opType": "Target"
>     }
>   ],
>   "child": {
>     "sortSpecs": [
>       {
>         "key": {
>           "name": "reg_date",
>           "opType": "Column"
>         },
>         "asc": true,
>         "null_first": false
>       }
>     ],
>     "child": {
>       "groups": [
>         {
>           "group_type": "OrdinaryGroup",
>           "columns": [
>             {
>               "name": "reg_date",
>               "opType": "Column"
>             }
>           ]
>         }
>       ],
>       "child": {
>         "relations": [
>           {
>             "tableName": "member_info",
>             "opType": "Relation"
>           }
>         ],
>         "opType": "RelationList"
>       },
>       "opType": "Aggregation"
>     },
>     "opType": "Sort"
>   },
>   "opType": "Projection"
> }
> {code}
> I wrote DISTINCT clause before member_id field. But SQLAnalyzer didn't print distinct
information about member_id field.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message