[ https://issues.apache.org/jira/browse/HIVE-25907?focusedWorklogId=761714&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-761714 ]
ASF GitHub Bot logged work on HIVE-25907: ----------------------------------------- Author: ASF GitHub Bot Created on: 25/Apr/22 11:18 Start Date: 25/Apr/22 11:18 Worklog Time Spent: 10m Work Description: shameersss1 commented on PR #2978: URL: https://github.com/apache/hive/pull/2978#issuecomment-1108438926 @kgyrtkirk Could you please review the changes? Issue Time Tracking ------------------- Worklog Id: (was: 761714) Time Spent: 1h 50m (was: 1h 40m) > 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: 1h 50m > 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)