Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6725

Drill 1.15 cannot use existing views if they reference tables with mixed case schemas

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Bug
    • Affects Version/s: 1.15.0
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              bbevens Bridget Bevens
              Reporter:
              rhou Robert Hou
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: