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

query with empty over clause throws an exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • None
    • None
    • SQL Parser
    • None

    Description

      Using an over clause without a "partition by" nor a "order by" clauses throws a ForemanException (complete message attached)

      For example the following query throws an exception:

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

      Attachments

        1. DRILL-1863 error.txt
          4 kB
          Abdel Hakim Deneche

        Issue Links

          Activity

            People

              amansinha100 Aman Sinha
              adeneche Abdel Hakim Deneche
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: