Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2833

Exception on select * from INFORMATION_SCHEMA.COLUMNS caused by enabled HBase storage plug in where HBase is not installed

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: Storage - HBase
    • Labels:
      None

      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 !

        Attachments

          Activity

            People

            • Assignee:
              adityakishore Aditya Kishore
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: