[ 
https://issues.apache.org/jira/browse/HIVE-15729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16272612#comment-16272612
 ] 

Hive QA commented on HIVE-15729:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12899990/HIVE-15729.02.patch

{color:red}ERROR:{color} -1 due to no test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 9 failed/errored test(s), 11481 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_complex_join] 
(batchId=44)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_2]
 (batchId=157)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata]
 (batchId=165)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid_fast]
 (batchId=160)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb] 
(batchId=160)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints 
(batchId=227)
org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=233)
org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=233)
org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=233)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/8056/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/8056/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-8056/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 9 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12899990 - PreCommit-HIVE-Build

> 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
>    Affects Versions: 2.3.0
>            Reporter: Marcus T
>            Assignee: 靳峥
>             Fix For: 2.4.0
>
>         Attachments: HIVE-15729.01.patch, HIVE-15729.02.patch
>
>
> When using CREATE TEMPORARY TABLE with a LOCATION clause, Hive doesn't remove 
> the created files when the session ends.
> Steps to reproduce:
> {noformat}
> 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"
> {noformat}
> 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.4.14#64029)

Reply via email to