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 DISTNCT clause
Date Thu, 05 Sep 2013 16:50:53 GMT

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

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

    Description: 
  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.


  was:
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.


    
> CountValueFunctionExpr can't handle DISTNCT 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