You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Peter Vary (Jira)" <ji...@apache.org> on 2022/06/01 09:20:00 UTC

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

     [ 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)