You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Syed Shameerur Rahman (Jira)" <ji...@apache.org> on 2022/05/26 11:56:00 UTC

[jira] (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 ]


    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)