Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1862

over clause with only order by clause throws an exception

    XMLWordPrintableJSON

    Details

      Description

      When using over clause without a "partition by" clause but with an "order by" clause, an ForemanException is thrown (complete error message attached).

      For example the following query throws and exception:

      SELECT employee_id, position_id, salary, SUM(salary) OVER(ORDER BY salary) FROM cp.`employee.json` LIMIT 20;
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                amansinha100 Aman Sinha
                Reporter:
                adeneche Deneche A. Hakim
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: