hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From unmesha sreeveni <unmeshab...@gmail.com>
Subject Re: Where is the base directory of a transaction table?
Date Tue, 02 Dec 2014 07:50:47 GMT
Check the base directory in Hive warehouse.

On Tue, Dec 2, 2014 at 12:42 PM, vic0777 <vic0777@163.com> wrote:

> Hi All,
>
> 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
> where the base directory is in HDFS, there is only delta directories.
> 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
>
>
>
>
>


-- 
*Thanks & Regards *


*Unmesha Sreeveni U.B*
*Hadoop, Bigdata Developer*
*Centre for Cyber Security | Amrita Vishwa Vidyapeetham*
http://www.unmeshasreeveni.blogspot.in/

Mime
View raw message