[DRILL-1129] Get NPE when select from information_schema after updating storage plugins

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Information Schema
• Assignee: Unassigned
• Reporter: Krystal
• Created: 10/Jul/14 22:54
• Updated: 21/Apr/15 22:22
• Resolved: 21/Jul/14 03:21

Description

git.commit.id.abbrev=5b57294

After updating the Storage plugins from the UI, selecting from INFORMATION_SCHEMA gives a NPE. For example, I have the following setting in dfs schema:

"default" :

{ "location" : "/drill/testdata/p1tests", "writable" : true, "storageformat" : null }

,

I updated the location to "location" : "/drill/testdata",

After this, I went to sqlline and ran the following query:
0: jdbc:drill:schema=dfs> SELECT * FROM INFORMATION_SCHEMA.`TABLES`;
message: "Failure while running fragment. < NullPointerException"

After I changed the location back to its previous value, the query runs successfully.

Issue Links

• duplicates: DRILL-1086 Deleting a .view.drill file will cause INFORMATION_SCHEMA.`TABLES` to fail