You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/09/06 15:52:52 UTC
[jira] [Work started] (TAJO-163) CountValueFunctionExpr can't
handle DISTINCT clause
[ https://issues.apache.org/jira/browse/TAJO-163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on TAJO-163 started by Hyunsik Choi.
> 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