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

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.13.0
    • Fix Version/s: None
    • Component/s: Functions - Drill
    • Labels:
    • Environment:

      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

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

              Dates

              • Created:
                Updated: