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/12/16 10:51:07 UTC
[jira] [Created] (TAJO-422) Support single row functions at GROUP
BY clause.
JaeHwa Jung created TAJO-422:
--------------------------------
Summary: 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.4#6159)