[TAJO-422] Support single row functions at GROUP BY clause.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Assignee: Unassigned
• Reporter: JaeHwa Jung
• Created: 16/Dec/13 09:49
• Updated: 20/Jan/14 01:50
• Resolved: 20/Jan/14 01:50

Description

Current tajo doesn't support single row functions at GROUP BY clause. I found some errors as follows:

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)