Hi!
I'm testing hive transactions. They work well, but compaction doesn't
launch.

I try reduce check interval and launch it manuallty with command "Alter
table tx_tbl compaction 'major';". Nothing helps.


Hive version: Hive 1.1.0-cdh5.8.3


Hive properties:

*set *hive.support.concurrency=*true*;
*set *hive.enforce.bucketing=*true*;
*set *hive.exec.dynamic.partition.mode=nonstrict;
*set *hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
*set *hive.compactor.initiator.on=*true*;
*set *hive.compactor.worker.threads=5;
*set *hive.compactor.check.interval=10;

Hive table:
*create table *tx_tbl (
     *id **int*,
     *name *string)
     clustered *by *(id) *into *2 buckets stored *as *orc
     tblproperties(
     "transactional"="true",
     "compactor.mapreduce.map.memory.mb"="2048",
     "compactorthreshold.hive.compactor.delta.num.threshold"="4",
     "compactorthreshold.hive.compactor.delta.pct.threshold"="0.2"
);

Hive inserts looks like this:
insert into tx_tbl value(1, "some");

What i can try else?

Thanks!

Reply via email to