[ https://issues.apache.org/jira/browse/HIVE-25907?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Peter Vary resolved HIVE-25907. ------------------------------- Resolution: Fixed Pushed to master. Thanks for the fix [~srahman]! > 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: 4h 20m > 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)