You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Barclay (Drill) (JIRA)" <ji...@apache.org> on 2015/04/21 06:22:58 UTC
[jira] [Commented] (DRILL-2833) Exception on select * from
INFORMATION_SCHEMA
[ https://issues.apache.org/jira/browse/DRILL-2833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14504291#comment-14504291 ]
Daniel Barclay (Drill) commented on DRILL-2833:
-----------------------------------------------
What does your data look like? (What are the data types of the columns in tables from HBase?)
Also, what is the output of
select * from INFORMATION_SCHEMA.SCHEMATA;
and
select * from INFORMATION_SCHEMA.`TABLES`;
?
> Exception on select * from INFORMATION_SCHEMA
> ---------------------------------------------
>
> Key: DRILL-2833
> URL: https://issues.apache.org/jira/browse/DRILL-2833
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 0.9.0
> Reporter: Victoria Markman
> Assignee: Daniel Barclay (Drill)
>
> #Sat Apr 18 21:26:53 EDT 2015
> git.commit.id.abbrev=9ec257e
> {code}
> 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)
> {code}
> Only happens when Hbase plugin is enabled. Thanks Rahul for helping diagnose the problem !
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)