[
https://issues.apache.org/jira/browse/DRILL-7707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17085793#comment-17085793
]
Arina Ielchiieva commented on DRILL-7707:
-----------------------------------------
Similar issue when trying to execute analyze command for that table without
indicating schema first:
{noformat}
apache drill> analyze table t refresh metadata;
Error: VALIDATION ERROR: Root schema is immutable. Creating or dropping
tables/views is not allowed in root schema.Select a schema using 'USE schema'
command.
{noformat}
It should say that table is absent though.
> Unable to analyze table metadata is it resides in non-writable workspace
> ------------------------------------------------------------------------
>
> Key: DRILL-7707
> URL: https://issues.apache.org/jira/browse/DRILL-7707
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.17.0
> Reporter: Arina Ielchiieva
> Assignee: Vova Vysotskyi
> Priority: Major
>
> Unable to analyze table metadata is it resides in non-writable workspace:
> {noformat}
> apache drill> analyze table cp.`employee.json` refresh metadata;
> Error: VALIDATION ERROR: Unable to create or drop objects. Schema [cp] is
> immutable.
> {noformat}
> Stacktrace:
> {noformat}
> [Error Id: b7f233cd-f090-491e-a487-5fc4c25444a4 ]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:657)
> at
> org.apache.drill.exec.planner.sql.SchemaUtilites.resolveToDrillSchemaInternal(SchemaUtilites.java:230)
> at
> org.apache.drill.exec.planner.sql.SchemaUtilites.resolveToDrillSchema(SchemaUtilites.java:208)
> at
> org.apache.drill.exec.planner.sql.handlers.DrillTableInfo.getTableInfoHolder(DrillTableInfo.java:101)
> at
> org.apache.drill.exec.planner.sql.handlers.MetastoreAnalyzeTableHandler.getPlan(MetastoreAnalyzeTableHandler.java:108)
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283)
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163)
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128)
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93)
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593)
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274)
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
