You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "JaeHwa Jung (JIRA)" <ji...@apache.org> on 2013/09/05 18:50:52 UTC
[jira] [Created] (TAJO-163) CountValueFunctionExpr can't handle
DISTNCT clause
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