[DRILL-1119] Bad error message for view creation in non writeable workspaces

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Client - ODBC
• Assignee: DrillCommitter
• Reporter: George Chow
• Created: 09/Jul/14 00:40
• Updated: 27/Jul/14 18:51
• Resolved: 27/Jul/14 18:51

Description

The error message when Drill fails to create a view looks as follow:

[7/7/2014 3:43:11 PM]  Executing Query: CREATE VIEW `dfs.default`.`test` AS SELECT CAST(R_NAME as varchar(20))Country,CAST(R_COMMENT as varchar(200))Comments, R_RegionKey  FROM `dfs`.`default`.`./opt/mapr/drill/drill-1.0.0.BETA1/sample-data/region.parquet`
[7/7/2014 3:43:11 PM]  Failed to create view test
[7/7/2014 3:43:11 PM]  Current schema 'dfs.default' is not a mutable schema. Can't create views in this schema.

This looks daunting. Some improvement please.