drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Cliff Buchanan (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1145) Select from view created from a view returns NPE
Date Tue, 15 Jul 2014 21:39:13 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Cliff Buchanan updated DRILL-1145:
----------------------------------

    Assignee: Venki Korukanti

> 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
>            Assignee: Venki Korukanti
>
> 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)

Mime
View raw message