[DRILL-6725] Drill 1.15 cannot use existing views if they reference tables with mixed case schemas

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.15.0
• Component/s: Documentation
• Assignee: Bridget Bevens
• Reporter: Robert Hou
• Created: 01/Sep/18 02:14
• Updated: 26/Nov/18 16:56
• Resolved: 26/Nov/18 16:56

Description

Drill 1.15 changes schemas to be case-insensitive (DRILL-6492). If a view references a schema which has upper case letters, the view needs to be rebuilt. For example:

create or replace view `dfs.drillTestDirP1`.student_parquet_v as select * from `dfs.drillTestDirP1`.student;

If a query references this schema, Drill will return an exception:

java.sql.SQLException: VALIDATION ERROR: Failure while attempting to expand view. Requested schema drillTestDirP1 not available in schema dfs.

Do we have release notes? If so, this should be documented.