[
https://issues.apache.org/jira/browse/HIVE-22646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998027#comment-16998027
]
Karen Coppage commented on HIVE-22646:
--------------------------------------
Patch 01's quick fix broke other stuff. I'm shelving this. Feel free to pick up.
> 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)
