phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geoffrey Jacoby (JIRA)" <>
Subject [jira] [Commented] (PHOENIX-3377) Support DROP VIEW CASCADE
Date Tue, 03 Jul 2018 23:22:00 GMT


Geoffrey Jacoby commented on PHOENIX-3377:

[~tdsilva] - Looks like the lack of support for DROP VIEW CASCADE from a global view to one
or more tenant views is a known issue. 

I looked at ViewIndexIT, and altered the testUpdateOnTenantViewWithGlobalView() to omit the
manual drop of the tenant view on line 384, and to add a CASCADE to the drop of the global
view on line 386. The test fails because neither the global view nor the tenant view are correctly
dropped. In the logs I see this comming from the DROP statement of the global view:
2018-07-03 16:13:25,010 WARN [main] org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil(658):
Unable to find parent table "PLATFORM_ENTITY.V_T000002" of table "PLATFORM_ENTITY.I_T000003"
to determine USE_STATS_FOR_PARALLELIZATION org.apache.phoenix.schema.TableNotFoundException:
ERROR 1012 (42M03): Table undefined. tableName=PLATFORM_ENTITY.V_T000002 at org.apache.phoenix.schema.PMetaDataImpl.getTableRef(
at org.apache.phoenix.jdbc.PhoenixConnection.getTable( at org.apache.phoenix.mapreduce.util.PhoenixConfigurationUtil.getStatsForParallelizationProp(
at org.apache.phoenix.iterate.ParallelIterators.<init>( at
org.apache.phoenix.iterate.ParallelIterators.<init>( at org.apache.phoenix.execute.AggregatePlan.newIterator(
at org.apache.phoenix.execute.BaseQueryPlan.iterator( at org.apache.phoenix.execute.BaseQueryPlan.iterator(
at org.apache.phoenix.execute.BaseQueryPlan.iterator( at org.apache.phoenix.execute.BaseQueryPlan.iterator(
at org.apache.phoenix.compile.PostDDLCompiler$2.execute( at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(
at org.apache.phoenix.query.DelegateConnectionQueryServices.updateData(
at org.apache.phoenix.schema.MetaDataClient.dropTable( at org.apache.phoenix.schema.MetaDataClient.dropTable(
at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableDropTableStatement$1.execute(
at org.apache.phoenix.jdbc.PhoenixStatement$ at org.apache.phoenix.jdbc.PhoenixStatement$
at at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(
at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation( at
org.apache.phoenix.jdbc.PhoenixStatement.execute( at org.apache.phoenix.end2end.index.ViewIndexIT.testUpdateOnTenantViewWithGlobalView(


> -------------------------
>                 Key: PHOENIX-3377
>                 URL:
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: James Taylor
>            Priority: Major
> We currently do not produce an error for a DROP VIEW CASCADE command, but at the same
time we don't cascade drop all child views. We should either produce an error message for
this command or recursively drop all child views.
> See ViewIndexIT.testUpdateOnTenantViewWithGlobalView() for an example.

This message was sent by Atlassian JIRA

View raw message