[
https://issues.apache.org/jira/browse/HIVE-29609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Soumyakanti Das resolved HIVE-29609.
------------------------------------
Fix Version/s: 4.3.0
Resolution: Fixed
Thanks for the PR [~Dayakar]. Merged at
[https://github.com/apache/hive/commit/23102669476ceb6dd83b3e19f6311be03efc1dee]
> HPL/SQL leaving behind hive-staging directories
> -----------------------------------------------
>
> Key: HIVE-29609
> URL: https://issues.apache.org/jira/browse/HIVE-29609
> Project: Hive
> Issue Type: Bug
> Components: hpl/sql
> Reporter: Dayakar M
> Assignee: Dayakar M
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.3.0
>
>
> After executing an INSERT statement in _hplsql_ mode, the "Hive staging
> directory" is not cleaned up when the query is finished.
> Beeline console:
> {noformat}
> beeline -u 'jdbc:hive2://localhost:2181/default;mode=hplsql'
> .
> .
> 0: jdbc:hive2://localhost> insert into test values(900);
> . . . . . . . . . . . . .> /
> INFO : Compiling
> command(queryId=hive_20260513105648_9ce98b42-70de-4fbd-8bdb-1740c9dbaa17):
> INSERT INTO TABLE test VALUES
> (900)
> .
> .
> INFO : Completed executing
> command(queryId=hive_20260513105648_9ce98b42-70de-4fbd-8bdb-1740c9dbaa17);
> Time taken: 31.05 seconds
> INFO : OK
> No rows affected (32.332 seconds)
> 0: jdbc:hive2://localhost>{noformat}
> HDFS Path:
> {noformat}
> [hive@localhost root]$ hdfs dfs -ls /warehouse/tablespace/managed/hive/test
> Found 2 items
> drwxrwx---+ - hive hive 0 2026-05-13 10:57
> /warehouse/tablespace/managed/hive/test/.hive-staging_hive_2026-05-13_10-56-49_176_4248431493501088272-3
> drwxrwx---+ - hive hive 0 2026-05-13 10:57
> /warehouse/tablespace/managed/hive/test/delta_0000001_0000001_0000
> [hive@localhost root]${noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
