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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Information Schema
• Labels: no_verified_test
• Assignee: DrillCommitter
• Reporter: Norris Lee
• Created: 26/Jun/14 22:10
• Updated: 30/Apr/15 19:50
• Resolved: 27/Jul/14 18:50

Description

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.

Issue Links

• is duplicated by: DRILL-1129 Get NPE when select from information_schema after updating storage plugins