[ https://issues.apache.org/jira/browse/SPARK-27690?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dongjoon Hyun updated SPARK-27690: ---------------------------------- Summary: Remove materialized view first in `HiveClientImpl.reset` (was: Refactor HiveClientImpl#reset() to remove materialized view first ) > Remove materialized view first in `HiveClientImpl.reset` > -------------------------------------------------------- > > Key: SPARK-27690 > URL: https://issues.apache.org/jira/browse/SPARK-27690 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.0.0 > Reporter: Yuming Wang > Priority: Major > > {noformat} > Cause: > org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: > DELETE on table 'TBLS' caused a violation of foreign key constraint > 'MV_TABLES_USED_FK2' for key (4). The statement has been rolled back. > at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) > at > org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown > Source) > at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeBatchElement(Unknown > Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeBatch(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown > Source){noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org