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] [Created] (TAJO-163) CountValueFunctionExpr can't handle DISTNCT clause
Date Thu, 05 Sep 2013 16:50:52 GMT
JaeHwa Jung created TAJO-163:
--------------------------------

             Summary: 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