[DRILL-1833] Views cannot be registered into the INFORMATION_SCHEMA.`TABLES` after wiping out ZooKeeper data

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Storage - Information Schema
• Labels: no_verified_test

Environment

git.commit.id.abbrev=2396670

• Assignee: Venki Korukanti
• Reporter: Xiaomeng Huang
• Created: 09/Dec/14 22:16
• Updated: 07/May/15 19:29
• Resolved: 02/Apr/15 17:38

Description

After wiping out the ZooKeeper data, the drillbit cannot automatically register the view into INFORMATION_SCHEMA.`TABLES` even after we query the view.

For example, for a workspace dfs.tmp, there is a view file `varchar_view.view.drill` under the corresponding directory '/tmp'.
We can query:

select * from dfs.test.`varchar_view`

But this view still won't show up in INFORMATION_SCHEMA.`TABLES`.
After I recreate the view based on the contents of `varchar_view.view.drill`, the view shows in the INFORMATION_SCHEMA.`TABLES`.

Issue Links

• is depended upon by: DRILL-2413 FileSystemPlugin refactoring: avoid sharing DrillFileSystem across schemas