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)