tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (TAJO-422) Support single row functions at GROUP BY clause.
Date Mon, 20 Jan 2014 01:51:19 GMT

     [ 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)

Mime
View raw message