@Test
  public void testLoadAcidFile() throws Exception {
    MetastoreConf.setBoolVar(hiveConf, MetastoreConf.ConfVars.CREATE_TABLES_AS_ACID, true);
    runStatementOnDriver("drop table if exists T");
    runStatementOnDriver("drop table if exists T2");
    runStatementOnDriver(
        "create table T (a int, b int) stored as orc");
    //This is just a simple way to generate test data
    runStatementOnDriver("create table T2(a int, b int) stored as orc");
    runStatementOnDriver("insert into T values(1,2)");
    List<String> rs = runStatementOnDriver("select INPUT__FILE__NAME from T");
    Assert.assertEquals(1, rs.size());
    Assert.assertTrue("Unexpcted file name", rs.get(0)
        .endsWith("t/delta_0000001_0000001_0000/bucket_00000_0"));
    //T2 is an acid table so this should fail
    CommandProcessorException e =
        runStatementOnDriverNegative("load data local inpath '" + rs.get(0) + "' into table T2");
    Assert.assertEquals("Unexpected error code",
        ErrorMsg.LOAD_DATA_ACID_FILE.getErrorCode(), e.getErrorCode());
  }
Make sure Load Data assigns ROW_IDs correctly when there is statementId suffix on delta dir
For example, delta_x_x_0001.
ql/src/test/org/apache/hadoop/hive/ql/TestTxnLoadData.java