tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JaeHwa Jung (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-422) Support single row functions at GROUP BY clause.
Date Mon, 16 Dec 2013 09:51:07 GMT
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)

Mime
View raw message