[ https://issues.apache.org/jira/browse/HIVE-19891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16532932#comment-16532932 ]
Hive QA commented on HIVE-19891: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12930150/HIVE-19891.04.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 14638 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12376/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12376/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12376/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12930150 - PreCommit-HIVE-Build > inserting into external tables with custom partition directories may cause > data loss > ------------------------------------------------------------------------------------ > > Key: HIVE-19891 > URL: https://issues.apache.org/jira/browse/HIVE-19891 > Project: Hive > Issue Type: Bug > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Priority: Major > Attachments: HIVE-19891.01.patch, HIVE-19891.02.patch, > HIVE-19891.03.patch, HIVE-19891.04.patch, HIVE-19891.patch > > > tbl1 is just used as a prop to create data, could be an existing directory > for an external table. > Due to weird behavior of LoadTableDesc (some ancient code for overriding old > partition path), custom partition path is overwritten after the query and the > data in it ceases being a part of the table (can be seen in desc formatted > output with masking commented out in QTestUtil) > This affects branch-1 too, so it's pretty old. > {noformat}drop table tbl1; > CREATE TABLE tbl1 (index int, value int ) PARTITIONED BY ( created_date > string ); > insert into tbl1 partition(created_date='2018-02-01') VALUES (2, 2); > CREATE external TABLE tbl2 (index int, value int ) PARTITIONED BY ( > created_date string ); > ALTER TABLE tbl2 ADD PARTITION(created_date='2018-02-01'); > ALTER TABLE tbl2 PARTITION(created_date='2018-02-01') SET LOCATION > 'file:/Users/sergey/git/hivegit/itests/qtest/target/warehouse/tbl1/created_date=2018-02-01'; > select * from tbl2; > describe formatted tbl2 partition(created_date='2018-02-01'); > insert into tbl2 partition(created_date='2018-02-01') VALUES (1, 1); > select * from tbl2; > describe formatted tbl2 partition(created_date='2018-02-01'); > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)