[
https://issues.apache.org/jira/browse/DRILL-1277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14091139#comment-14091139
]
Krystal commented on DRILL-1277:
--------------------------------
Server Error:
java.lang.NullPointerException
org.eigenbase.reltype.RelDataTypeImpl.getField(RelDataTypeImpl.java:79)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorUtil.lookupField(SqlValidatorUtil.java:90)
~[optiq-core-0.9-20140730.000241-5.jar:na]
net.hydromatic.optiq.prepare.OptiqCatalogReader.field(OptiqCatalogReader.java:174)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3965)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3885)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1349)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1332)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.type.InferTypes$1.inferOperandTypes(InferTypes.java:52)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.inferUnknownTypes(SqlValidatorImpl.java:1524)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateWhereOrOn(SqlValidatorImpl.java:3000)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:2630)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2593)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2802)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:85)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:779)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:768)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:208)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:742)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:458)
~[optiq-core-0.9-20140730.000241-5.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:173)
~[optiq-core-0.9-20140730.000241-5.jar:na]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:137)
~[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:117)
~[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:128)
~[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:403)
[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:219)
[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:250)
[drill-java-exec-0.4.0-incubating-SNAPSHOT-rebuffed.jar:0.4.0-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> Join between 2 hbase/M7 tables using the dot notation fails
> -----------------------------------------------------------
>
> Key: DRILL-1277
> URL: https://issues.apache.org/jira/browse/DRILL-1277
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Reporter: Krystal
>
> git.commit.id.abbrev=98b208e
> I have the following join query between 2 hbase tables that runs successfully:
> select cast(student.onecf['name'] as varchar(35)) name,
> cast(student.twocf['age'] as integer) age, cast(student.threecf['gpa'] as
> decimal(4,2)) gpa, cast(voter.twocf['registration'] as varchar(20))
> registration from student join voter on (student.onecf['name'] =
> voter.onecf['name']);
> I converted the above query to use the dot notation:
> select cast(student.onecf.name as varchar(35)) name, cast(student.twocf.age
> as integer) age, cast(student.threecf.gpa as decimal(4,2)) gpa,
> cast(voter.twocf.registration as varchar(20)) registration from student join
> voter on (student.onecf.name = voter.onecf.name);
> However this query failed with the following error message:
> Query failed: Failure while parsing sql. java.lang.NullPointerException
> [90df667c-9041-45a2-96c2-8400a6a91f91]
> Error: exception while executing query: Failure while trying to get next
> result batch. (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
