Dayakar M created HIVE-29609:
--------------------------------
Summary: 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
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)
