You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Boaz Ben-Zvi (JIRA)" <ji...@apache.org> on 2016/09/23 17:38:20 UTC

[jira] [Created] (DRILL-4904) NPE from backquoted LIKE argument

Boaz Ben-Zvi created DRILL-4904:
-----------------------------------

             Summary: 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


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
(v6.3.4#6332)