Step:1 create table test_90855 (
uid string,
user_name string,
start_date date,
active boolean)
CLUSTERED BY (start_date) into 100 buckets
STORED AS ORC
TBLPROPERTIES ('transactional'='true'); Step 2: set hive.auto.convert.join.noconditionaltask.size=10000000;
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=1;
set hive.enforce.bucketing=true; Step 3: update test_90855 set user_name='xxx'; i have tried above steps and its not working. Help me to fix this issue
... View more
