[DRILL-2833] Exception on select * from INFORMATION_SCHEMA.COLUMNS caused by enabled HBase storage plug in where HBase is not installed

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: Storage - HBase
• Assignee: Aditya Kishore
• Reporter: Victoria Markman
• Created: 21/Apr/15 00:19
• Updated: 08/Oct/15 22:39

Description

#Sat Apr 18 21:26:53 EDT 2015
git.commit.id.abbrev=9ec257e

0: jdbc:drill:schema=dfs> select * from INFORMATION_SCHEMA.COLUMNS;
Query failed: SYSTEM ERROR: null

Fragment 0:0

[bd2a0477-90ea-423b-ad77-ad9784f4116b on atsqa4-133.qa.lab:31010]

  (java.lang.NullPointerException) null
    org.eigenbase.sql.type.IntervalSqlType.<init>():41
    org.eigenbase.sql.type.SqlTypeFactoryImpl.createSqlIntervalType():104
    org.apache.drill.exec.dotdrill.View.getRowType():236
    org.apache.drill.exec.planner.logical.DrillViewTable.getRowType():46
    org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema():123
    org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema():109
    org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema():109
    org.apache.drill.exec.store.ischema.RecordGenerator.scanSchema():97
    org.apache.drill.exec.store.ischema.SelectedTable.getRecordReader():47
    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():35
    org.apache.drill.exec.store.ischema.InfoSchemaBatchCreator.getBatch():30
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():62
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():39
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitSubScan():127
    org.apache.drill.exec.physical.base.AbstractSubScan.accept():39
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():74
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():62
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():39
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitIteratorValidator():215
    org.apache.drill.exec.physical.config.IteratorValidator.accept():34
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():74
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():62
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():39
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitProject():77
    org.apache.drill.exec.physical.config.Project.accept():51
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():74
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():62
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():39
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitIteratorValidator():215
    org.apache.drill.exec.physical.config.IteratorValidator.accept():34
    org.apache.drill.exec.physical.impl.ImplCreator.getChildren():74
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():59
    org.apache.drill.exec.physical.impl.ImplCreator.visitOp():39
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitStore():132
    org.apache.drill.exec.physical.base.AbstractPhysicalVisitor.visitScreen():195
    org.apache.drill.exec.physical.config.Screen.accept():97
    org.apache.drill.exec.physical.impl.ImplCreator.getExec():87
    org.apache.drill.exec.work.fragment.FragmentExecutor.run():148
    org.apache.drill.common.SelfCleaningRunnable.run():38
    java.util.concurrent.ThreadPoolExecutor.runWorker():1145
    java.util.concurrent.ThreadPoolExecutor$Worker.run():615
    java.lang.Thread.run():745

Error: exception while executing query: Failure while executing query. (state=,code=0)

Only happens when Hbase plugin is enabled. Thanks Rahul for helping diagnose the problem !