My settings regarding transactions are: hive.txn.acid.dir.cache.duration=120
| | hive.txn.acid.metrics.delta.num.threshold=100 | |
hive.txn.acid.metrics.delta.pct.threshold=0.01 | |
hive.txn.acid.metrics.max.cache.size=100 | |
hive.txn.acid.metrics.obsolete.delta.num.threshold=100 | |
hive.txn.acid.metrics.reporting.interval=30s | |
hive.txn.ext.locking.enabled=true | |
hive.txn.filter.delete.events=true | |
hive.txn.heartbeat.threadpool.size=5 | |
hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager | |
hive.txn.manager.dump.lock.state.on.acquire.timeout=false | |
hive.txn.max.open.batch=1000 | |
hive.txn.nonacid.read.locks=true | |
hive.txn.operational.properties=1 | |
hive.txn.read.locks=true | |
hive.txn.readonly.enabled=false | |
hive.txn.retrysnapshot.max.count=5 | |
hive.txn.stats.enabled=true | |
hive.txn.strict.locking.mode=false | | hive.txn.timeout=300s
| | hive.txn.write.acid.version.file=true
| | hive.txn.xlock.ctas=true | |
hive.txn.xlock.iow=true | |
hive.txn.xlock.mergeinsert=false | |
hive.txn.xlock.write=true | after LOCK TABLE
example EXCLUSIVE; I get: org.apache.hadoop.hive.ql.metadata.HiveException:
Current transaction manager does not support explicit lock requests.
Transaction manager: org.apache.hadoop.hive.ql.lockmgr.DbTxnManager It
seams that HIVE-26258 did not enabled explicit locking with HQL with that
transaction manager. Any other options to exclusively lock partition? Dnia
30 stycznia 2023 23:29 Sai Hemanth Gantasala <saihema...@cloudera.com>
napisał(a): Hi Wojtek Meler, Have you tried setting the below config before
running the queries? set hive.txn.ext.locking.enabled=true On Fri, Jan
27, 2023 at 1:48 PM Wojtek Meler < wme...@wp.pl > wrote: I've
enabled external tables locking with issues.apache.org [HIVE-26258] Provide an
option for enable locking of external tables - ASF JIRA (apache.org) but still
locking with HQL is not posible:
org.apache.hadoop.hive.ql.metadata.HiveException: Current transaction manager
does not support explicit lock requests. Transaction manager:
org.apache.hadoop.hive.ql.lockmgr.DbTxnManager How to lock external table
partition in hive4 to perform any maintenance on it? Regards, Wojtek
