[jira] [Created] (HIVE-25907) IOW Directory queries fails to write data to final path when query result cache is enabled

["Syed Shameerur Rahman (Jira)" <ji...@apache.org>]

Syed Shameerur Rahman created HIVE-25907:
--------------------------------------------

             Summary: IOW Directory queries fails to write data to final path when query result cache is enabled
                 Key: HIVE-25907
                 URL: https://issues.apache.org/jira/browse/HIVE-25907
             Project: Hive
          Issue Type: Bug
          Components: Hive
            Reporter: Syed Shameerur Rahman
            Assignee: Syed Shameerur Rahman
             Fix For: 4.0.0


INSERT OVERWRITE DIRECTORY queries fails to write the data to the specified directory location when query result cache is enabled.

*Steps to reproduce*

{code:java}
1. create a data file with the following data

1 abc 10.5
2 def 11.5


2. create table pointing to that data

create external table iowd(strct struct<a:int, b:string, c:string>)
row format delimited
fields terminated by '\t'
collection items terminated by ' '
location '<data_location>';


3. run the following query

set hive.query.results.cache.enabled=true;
INSERT OVERWRITE DIRECTORY "<destination directory>" SELECT * FROM iowd;
{code}

After execution of the above query, It is expected that the destination directory contains data from the table iowd, But due to HIVE-21386 it is not happening anymore.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)