[
https://issues.apache.org/jira/browse/HIVE-27636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18003466#comment-18003466
]
Neeraj Khatri commented on HIVE-27636:
--------------------------------------
[~rtrivedi12] can you provide me with the repro steps as I am not able to repro
this bug
> Exception in HiveMaterializedViewsRegistry is leaving staging directories
> behind
> --------------------------------------------------------------------------------
>
> Key: HIVE-27636
> URL: https://issues.apache.org/jira/browse/HIVE-27636
> Project: Hive
> Issue Type: Bug
> Components: Materialized views
> Reporter: Riju Trivedi
> Assignee: Neeraj Khatri
> Priority: Major
> Labels: hive-4.1.1-must
>
> In case of any exception while query parsing in
> `HiveMaterializedViewsRegistry.createMaterialization`, we bail out and there
> is no hdfs dir cleanup until JVM exit. This leaves behind the staging
> directories. For a long-running HS2, these staging directories keeps on
> increasing and can cause limit reached exception.
> {code:java}
> Error: Error while compiling statement: FAILED: RuntimeException Cannot
> create staging directory
> 'hdfs://aidaprd01/warehouse/tablespace/managed/hive/test.db/testTable/.hive-staging_hive_2023-08-05_06-17-06_711_5516272990801215078-168329':
> The directory item limit of
> /warehouse/tablespace/managed/hive/test.db/testTable is exceeded:
> limit=1048576 items=1048576 {code}
> We should do hdfs directory cleanup for `HiveMaterializedViewsRegistry`
> thread
> [here|https://github.com/apache/hive/blob/1a574783afee13e33ecf3ed6fc60bdc94fe47bb1/ql/src/java/org/apache/hadoop/hive/ql/metadata/HiveMaterializedViewsRegistry.java#L231]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
