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!