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)

Reply via email to