[DRILL-1145] Select from view created from a view returns NPE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Information Schema
• Assignee: Venki Korukanti
• Reporter: Krystal
• Created: 15/Jul/14 21:23
• Updated: 15/Sep/15 16:13
• Resolved: 21/Jul/14 02:48

Description

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" }

]