Hi All,
I know probably this should not post here. I posted it in the user maillist without any response, so I moved it here. Thanks in advance for any help. I am trying to use the new transaction feature in Hive-0.14. According to its document, every transaction table have a base directory and one delta directory for each transaction in HDFS for data storage. But I can not find the base directory under the datawarehouse directory in HDFS, there is only delta directories. Even the initial data is stored in a delta directory. Following is the commands I used. create table test_txn (id int ,name string ) clustered by (id) into 2 buckets stored as orc TBLPROPERTIES('transactional'='true'); insert into table test_txn select * from test_text; update test_txn set name="liu" where id = 10; P.S. I have configured the parameters required by the transaction feature: hive.support.concurrency, hive.enforce.bucketing, hive.exec.dynamic.partition.mode, hive.txn.manager, hive.compactor.initiator.on hive.compactor.worker.threads. Although I cannot find the base directory in HDFS, all SELECT, UPDATE and DELETE statements works fine and the data in the table is correct. I am wondering where the base directory is. Any help is appreciated. Thanks, Wantao