Drill 1.14 changes schemas to be case-insensitive (
DRILL-6492). If an existing view was created before ( DRILL-6492) was committed, and this view references a file that includes a schema which has upper case letters, the view needs to be rebuilt. There may be variations on this issue that I have not seen.
To reproduce this problem, create a dfs workspace like this:
Use Drill commit ddb35ce71837376c7caef28c25327ba556bb32f2 and execute this command:
Then use Drill commit ddb35ce71837376c7caef28c25327ba556bb32f2 and execute this query:
Drill will return an exception:
I have attached the student parquet file I used.
This is what the .view.drill file looks like:
This means that users may not be able to access views that they have created using previous versions of Drill. We should maintain backwards compatibiliity where possible.
As work-around, these views can be re-created. It would be helpful to users if the error message explains that these views need to be re-created.