You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2019/03/11 13:55:00 UTC
[jira] [Commented] (DRILL-4904) NPE from backquoted LIKE argument
[ https://issues.apache.org/jira/browse/DRILL-4904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16789590#comment-16789590 ]
Arina Ielchiieva commented on DRILL-4904:
-----------------------------------------
Current behavior not ideal but at least there is not NPE.
{noformat}
0: jdbc:drill:zk=local> select version from sys.version where version like `24518133617%` group by version;
Error: VALIDATION ERROR: From line 1, column 53 to line 1, column 66: Column '24518133617%' not found in any table
{noformat}
> NPE from backquoted LIKE argument
> ----------------------------------
>
> Key: DRILL-4904
> URL: https://issues.apache.org/jira/browse/DRILL-4904
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.8.0
> Reporter: Boaz Ben-Zvi
> Priority: Major
>
> By mistakenly using backquotes (instead of regular single quotes) in the argument for LIKE, an NPE shows:
> 0: jdbc:drill:zk=local> select col from test1 where col like `24518133617%` group by col;
> Error: SYSTEM ERROR: NullPointerException
> Fragment 3:1
> [Error Id: 5c8317c3-3b1c-415b-8967-56696eeff764 on 10.250.57.63:31010]
> (java.lang.NullPointerException) null
> org.apache.drill.exec.expr.fn.impl.StringFunctionHelpers.toStringFromUTF8():199
> org.apache.drill.exec.test.generated.FiltererGen58.doSetup():84
> org.apache.drill.exec.test.generated.FiltererGen58.setup():54
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.generateSV2Filterer():195
> org.apache.drill.exec.physical.impl.filter.FilterRecordBatch.setupNewSchema():107
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():78
> org.apache.drill.exec.record.AbstractRecordBatch.next():162
> org.apache.drill.exec.record.AbstractRecordBatch.next():119
> org.apache.drill.exec.record.AbstractRecordBatch.next():109
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
> org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.innerNext():94
> org.apache.drill.exec.record.AbstractRecordBatch.next():162
> org.apache.drill.exec.record.AbstractRecordBatch.next():119
> org.apache.drill.exec.record.AbstractRecordBatch.next():109
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135
> org.apache.drill.exec.record.AbstractRecordBatch.next():162
> org.apache.drill.exec.record.AbstractRecordBatch.next():119
> org.apache.drill.exec.record.AbstractRecordBatch.next():109
> org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.buildSchema():97
> org.apache.drill.exec.record.AbstractRecordBatch.next():142
> org.apache.drill.exec.record.AbstractRecordBatch.next():119
> org.apache.drill.exec.record.AbstractRecordBatch.next():109
> org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
> org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135
> org.apache.drill.exec.record.AbstractRecordBatch.next():162
> org.apache.drill.exec.physical.impl.BaseRootExec.next():104
> org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext():92
> org.apache.drill.exec.physical.impl.BaseRootExec.next():94
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232
> org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226
> java.security.AccessController.doPrivileged():-2
> javax.security.auth.Subject.doAs():422
> org.apache.hadoop.security.UserGroupInformation.doAs():1657
> org.apache.drill.exec.work.fragment.FragmentExecutor.run():226
> org.apache.drill.common.SelfCleaningRunnable.run():38
> java.util.concurrent.ThreadPoolExecutor.runWorker():1142
> java.util.concurrent.ThreadPoolExecutor$Worker.run():617
> java.lang.Thread.run():745 (state=,code=0)
> More info: Table is json ; single varchar column.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)