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 2015/04/30 21:51:06 UTC

[jira] [Closed] (DRILL-1086) Deleting a .view.drill file will cause INFORMATION_SCHEMA.`TABLES` to fail

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

Krystal closed DRILL-1086.
--------------------------

Verified that deleting the view definition from dfs also removes the view from drill.  

> Deleting a .view.drill file will cause INFORMATION_SCHEMA.`TABLES` to fail
> --------------------------------------------------------------------------
>
>                 Key: DRILL-1086
>                 URL: https://issues.apache.org/jira/browse/DRILL-1086
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Information Schema
>            Reporter: Norris Lee
>            Assignee: DrillCommitter
>              Labels: no_verified_test
>             Fix For: 0.4.0
>
>         Attachments: DRILL-1086.1.patch.txt
>
>
> If a view is created by "CREATE VIEW .....", the view gets placed into INFORMATION_SCHEMA.`TABLES` as expected. If you go into the file system and delete the .view.drill file, then query SELECT * FROM INFORMATION_SCHEMA.`TABLES`, a null pointer exception will be thrown and nothing will be returned. 
> Note that re-creating the deleted file will amend the issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)