You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2014/07/15 23:25:05 UTC
[jira] [Commented] (DRILL-1145) Select from view created from a
view returns NPE
[ https://issues.apache.org/jira/browse/DRILL-1145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14062672#comment-14062672 ]
Krystal commented on DRILL-1145:
--------------------------------
server error:
java.lang.NullPointerException
org.eigenbase.sql2rel.SqlToRelConverter$3.expandView(SqlToRelConverter.java:2733) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.apache.drill.exec.planner.logical.DrillViewTable.toRel(DrillViewTable.java:59) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
net.hydromatic.optiq.prepare.RelOptTableImpl.toRel(RelOptTableImpl.java:151) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.toRel(SqlToRelConverter.java:2739) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.convertFrom(SqlToRelConverter.java:1693) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.convertSelectImpl(SqlToRelConverter.java:493) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.convertSelect(SqlToRelConverter.java:473) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.convertQueryRecursive(SqlToRelConverter.java:2616) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:431) ~[optiq-core-0.7-20140710.204128-10.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl$ViewExpanderImpl.expandView(PlannerImpl.java:224) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter$3.expandView(SqlToRelConverter.java:2733) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.apache.drill.exec.planner.logical.DrillViewTable.toRel(DrillViewTable.java:59) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
net.hydromatic.optiq.prepare.RelOptTableImpl.toRel(RelOptTableImpl.java:151) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.RelStructuredTypeFlattener.rewriteRel(RelStructuredTypeFlattener.java:662) ~[optiq-core-0.7-20140710.204128-10.jar:na]
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)(NativeMethodAccessorImpl.java) ~[na:1.7.0_45]
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_45]
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_45]
java.lang.reflect.Method.invoke(Method.java:606) ~[na:1.7.0_45]
org.eigenbase.util.ReflectUtil.invokeVisitorInternal(ReflectUtil.java:252) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.util.ReflectUtil.invokeVisitor(ReflectUtil.java:209) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.util.ReflectUtil$1.invokeVisitor(ReflectUtil.java:473) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:690) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.rel.SingleRel.childrenAccept(SingleRel.java:69) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.rel.RelVisitor.visit(RelVisitor.java:45) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:686) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.rel.SingleRel.childrenAccept(SingleRel.java:69) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.rel.RelVisitor.visit(RelVisitor.java:45) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.RelStructuredTypeFlattener$RewriteRelVisitor.visit(RelStructuredTypeFlattener.java:686) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.RelStructuredTypeFlattener.rewrite(RelStructuredTypeFlattener.java:127) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.eigenbase.sql2rel.SqlToRelConverter.flattenTypes(SqlToRelConverter.java:334) ~[optiq-core-0.7-20140710.204128-10.jar:na]
net.hydromatic.optiq.prepare.PlannerImpl.convert(PlannerImpl.java:193) ~[optiq-core-0.7-20140710.204128-10.jar:na]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.convertToRel(DefaultSqlHandler.java:132) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:114) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:400) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:216) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:242) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-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]
> Select from view created from a view returns NPE
> ------------------------------------------------
>
> Key: DRILL-1145
> URL: https://issues.apache.org/jira/browse/DRILL-1145
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Information Schema
> Reporter: Krystal
>
> git.commit.id.abbrev=699851b
> I created a view from a view within the same schema. When I performed a select from the new view, I got a NPE.
> 0: jdbc:drill:schema=dfs> create view student_v1 as select * from student_v;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | true | View 'student_v1' created successfully in 'dfs.default' schema |
> +------------+------------+
> 1 row selected (0.683 seconds)
> 0: jdbc:drill:schema=dfs> select * from student_v1 limit 5;
> message: "Failure while parsing sql. < NullPointerException"
> Here is the definition of the new view:
> [root@qa-node56 ~]# hadoop fs -cat /drill/testdata/p1tests/student_v1.view.drill
> {
> "name" : "student_v1",
> "sql" : "SELECT *\nFROM `student_v`",
> "fields" : [ {
> "name" : "student_id",
> "type" : "INTEGER"
> }, {
> "name" : "name",
> "type" : "ANY"
> }, {
> "name" : "age",
> "type" : "INTEGER"
> }, {
> "name" : "gpa",
> "type" : "DECIMAL",
> "precision" : 4,
> "scale" : 0
> }, {
> "name" : "student_num",
> "type" : "BIGINT"
> }, {
> "name" : "create_date",
> "type" : "TIMESTAMP"
> } ]
--
This message was sent by Atlassian JIRA
(v6.2#6252)