[
https://issues.apache.org/jira/browse/TAJO-422?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi resolved TAJO-422.
-------------------------------
Resolution: Fixed
Fixed by TAJO-501.
> Support single row functions at GROUP BY clause.
> ------------------------------------------------
>
> Key: TAJO-422
> URL: https://issues.apache.org/jira/browse/TAJO-422
> Project: Tajo
> Issue Type: Bug
> Affects Versions: 0.8-incubating
> Reporter: Jaehwa Jung
> Fix For: 0.8-incubating
>
>
> Current tajo doesn't support single row functions at GROUP BY clause. I found
> some errors as follows:
> {code:xml}
> tajo> select floor(id), count(*) from table1 group by floor(id);
> ERROR: mismatched input '(' expecting {<EOF>, EXCEPT, HAVING, INTERSECT,
> LIMIT, ORDER, UNION, ';', ','}
> LINE 1:53 select floor(id), count(*) from table1 group by floor(id)
> ^
> tajo> select split_part(name, ' ', 1) from table1 group by split_part(name, '
> ', 1);
> ERROR: mismatched input '(' expecting {<EOF>, EXCEPT, HAVING, INTERSECT,
> LIMIT, ORDER, UNION, ';', ','}
> LINE 1:63 select split_part(name, ' ', 1) from table1 group by
> split_part(name, ' ', 1)
> ^
> tajo> select round(id * 10), count(*) from table1 group by round(id*10);
> ERROR: mismatched input '(' expecting {<EOF>, EXCEPT, HAVING, INTERSECT,
> LIMIT, ORDER, UNION, ';', ','}
> LINE 1:58 select round(id * 10), count(*) from table1 group by round(id*10)
> {code}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
