[
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
