[
https://issues.apache.org/jira/browse/DRILL-6395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16469541#comment-16469541
]
Khurram Faraaz commented on DRILL-6395:
---------------------------------------
Here is the stack trace from drillbit.log,
seen on Drill 1.14.0-SNAPSHOT , commit :
c6c5d27d91468a29656bee2acba55d3321978aab
{noformat}
2018-05-09 14:21:57,085 [250c998a-5917-1cc5-9364-4d7cf441f209:foreman] INFO
o.a.drill.exec.work.foreman.Foreman - Query text for query id
250c998a-5917-1cc5-9364-4d7cf441f209: 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
...
2018-05-09 14:21:57,600 [250c998a-5917-1cc5-9364-4d7cf441f209:frag:0:0] ERROR
o.a.d.e.w.fragment.FragmentExecutor - 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, 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)", "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,
org.apache.drill.exec.expr.holders.VarCharHolder)"
Fragment 0:0
[Error Id: 71fc40fc-0b52-4c9b-b3ae-1ddad76ea120 on qa102-45.qa.lab:31010]
org.apache.drill.common.exceptions.UserException: 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, 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)", "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,
org.apache.drill.exec.expr.holders.VarCharHolder)"
Fragment 0:0
[Error Id: 71fc40fc-0b52-4c9b-b3ae-1ddad76ea120 on qa102-45.qa.lab:31010]
at
org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633)
~[drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:359)
[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:214)
[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:325)
[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38)
[drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
[na:1.8.0_161]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
[na:1.8.0_161]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
Caused by: org.apache.drill.common.exceptions.DrillRuntimeException:
org.apache.drill.exec.exception.SchemaChangeException: Exception when creating
the schema
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:167)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:118)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:108)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:137)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:164)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:118)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:108)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:137)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:164)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:105)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:95)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:292)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:279)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at java.security.AccessController.doPrivileged(Native Method) ~[na:1.8.0_161]
at javax.security.auth.Subject.doAs(Subject.java:422) ~[na:1.8.0_161]
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1595)
~[hadoop-common-2.7.0-mapr-1707.jar:na]
at
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:279)
[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
... 4 common frames omitted
Caused by: org.apache.drill.exec.exception.SchemaChangeException: Exception
when creating the schema
at
org.apache.drill.exec.physical.impl.window.WindowFrameRecordBatch.buildSchema(WindowFrameRecordBatch.java:249)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
at
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:144)
~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
... 23 common frames omitted
{noformat}
> Value Window Function - LEAD and LAG on VarChar result in "No applicable
> constructor/method found" error
> ---------------------------------------------------------------------------------------------------------
>
> Key: DRILL-6395
> URL: https://issues.apache.org/jira/browse/DRILL-6395
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.13.0
> Environment: windows 10, apache drill 1.13.0, 32GB Ram
> Reporter: Raymond Wong
> Priority: Major
>
> {code:java}
> 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;
> {code}
> Causes error
> {code:java}
> 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)"
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
