[jira] [Resolved] (TAJO-163) CountValueFunctionExpr can't handle DISTINCT clause

["JaeHwa Jung (JIRA)" <ji...@apache.org>]

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

JaeHwa Jung resolved TAJO-163.
------------------------------

    Resolution: Fixed

Thank you Hyunsik.
After I applied TAJO-167 patch, I found that it worked normal. :)
 
                
> 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
>            Assignee: Hyunsik Choi
>
>   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