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

Value Window Function - LEAD and LAG on VarChar result in "No applicable constructor/method found" error

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.13.0
    • None
    • Functions - Drill
    • windows 10, apacheĀ drill 1.13.0, 32GB Ram

    Description

      SELECT 
      col2,
      LEAD(col1, 1) OVER (ORDER BY col2) AS nxtCol1
      FROM (
      SELECT 'A' AS col1, 1 AS col2
      UNION 
      SELECT 'B' AS col1, 2 AS col2
      UNION 
      SELECT 'C' AS col1, 3 AS col2
      ) AS A;
      

      Causes errorĀ 

      SQL Error: SYSTEM ERROR: CompileException: Line 37, Column 40: 
      No applicable constructor/method found for actual parameters "int, int, int, io.netty.buffer.DrillBuf"; 
      candidates are: 
      "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, org.apache.drill.exec.expr.holders.VarCharHolder)", 
      "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, org.apache.drill.exec.expr.holders.NullableVarCharHolder)", 
      "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, byte[], int, int)", 
      "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, java.nio.ByteBuffer, int, int)", 
      "public void org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setSafe(int, int, int, int, io.netty.buffer.DrillBuf)"
      
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            rwong Raymond Wong
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: