[ https://issues.apache.org/jira/browse/HIVE-25907 ]
Syed Shameerur Rahman deleted comment on HIVE-25907: ---------------------------------------------- was (Author: srahman): [~kgyrtkirk] - Could you please review the PR? Thanks > 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 > Affects Versions: 4.0.0 > Reporter: Syed Shameerur Rahman > Assignee: Syed Shameerur Rahman > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 2.5h > Remaining Estimate: 0h > > 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.7#820007)