Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-422

Support single row functions at GROUP BY clause.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.8.0
    • Component/s: None
    • Labels:
      None

      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)
      

        Activity

        Hide
        hyunsik Hyunsik Choi added a comment -

        Fixed by TAJO-501.

        Show
        hyunsik Hyunsik Choi added a comment - Fixed by TAJO-501 .

          People

          • Assignee:
            Unassigned
            Reporter:
            blrunner Jaehwa Jung
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development