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

Window function usage throws CompileException

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0
    • Fix Version/s: 1.1.0
    • Component/s: Execution - Flow
    • Labels:
    • Environment:

      faec150598840c40827e6493992d81209aa936da

      Description

      PARTITION BY date ORDER BY timestamp

      0: jdbc:drill:schema=dfs.tmp> SELECT MAX(columns[0]) OVER (PARTITION BY columns[6] ORDER BY columns[4]) FROM `allTypData2.csv`;
      Error: SYSTEM ERROR: org.codehaus.commons.compiler.CompileException: Line 330, Column 31: Unknown variable or type "incoming"
      
      Fragment 0:0
      
      [Error Id: 285af8f1-ddb4-4d3e-a2d7-bfaef20df5e0 on centos-02.qa.lab:31010] (state=,code=0)
      

      I will add more details in a bit.

        Attachments

        1. drillbit_DRILL_3218.log
          77 kB
          Khurram Faraaz

          Issue Links

            Activity

              People

              • Assignee:
                adeneche Abdel Hakim Deneche
                Reporter:
                khfaraaz Khurram Faraaz
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: