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)
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: