hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marcus T (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15729) Temporary table with LOCATION clause not removed after session ends
Date Wed, 25 Jan 2017 22:21:26 GMT
Marcus T created HIVE-15729:
-------------------------------

             Summary: Temporary table with LOCATION clause not removed after session ends
                 Key: HIVE-15729
                 URL: https://issues.apache.org/jira/browse/HIVE-15729
             Project: Hive
          Issue Type: Bug
            Reporter: Marcus T
            Priority: Minor


When using CREATE TEMPORARY TABLE with a LOCATION clause, Hive doesn't remove the created
files when the session ends.

Steps to reproduce:
    beeline
      CREATE TEMPORARY TABLE this_gets_removed AS SELECT 'OK';
      CREATE TEMPORARY TABLE this_stays LOCATION '/tmp/this_stays' AS SELECT 'BAD';
      !quit

    hdfs dfs -ls -R "/tmp/hive/${USER}" "/tmp/this_stays"

Expected result: files and directories for `this_gets_removed` and `this_stays` are removed.
Actual result: files and directories for `this_gets_removed` are removed, files and directories
for `this_stays` are still present.

Ideally, it would be great if the LOCATION clause worked with the TEMPORARY clause.  If they
can't be made to work together, perhaps the LOCATION clause should be illegal when using TEMPORARY.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message