[jira] [Updated] (HIVE-22646) CTASing a dynamically partitioned MM table results in unreadable table

["Karen Coppage (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-22646?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Karen Coppage updated HIVE-22646:
---------------------------------
    Attachment: HIVE-22646.01.patch
        Status: Patch Available  (was: Open)

> CTASing a dynamically partitioned MM table results in unreadable table
> ----------------------------------------------------------------------
>
>                 Key: HIVE-22646
>                 URL: https://issues.apache.org/jira/browse/HIVE-22646
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Karen Coppage
>            Assignee: Karen Coppage
>            Priority: Major
>         Attachments: HIVE-22646.01.patch
>
>
> Repro steps: 
> {code:java}
> create table plain (i int, j int, s string);
> insert into plain values (1,1,'1');
> create table ctas partitioned by (s) tblproperties ('transactional'='true', 'transactional_properties' = 'insert_only') as select * from plain;
> select * from ctas;
> {code}
>  
>  We get this error:
> {code:java}
> Error: java.io.IOException: java.io.IOException: Not a file: file:/Users/karencoppage/data/upstream/warehouse/ctas/s=1/delta_0000002_0000002_0000/delta_0000002_0000002_0000 (state=,code=0){code}
> This also happens when CTASing from a dynamically partitioned table.
>  As seen in the error message, the issue is that a new delta directory is created in the temp directory, and during MoveTask another delta dir is unnecessarily created, then the first delta dir is moved into the second. The table is unreadable since a file and not another delta dir is expected in the top delta dir.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)