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 [HIVE-26258] Provide an option
> for enable locking of external tables - ASF JIRA (apache.org)
> <https://issues.apache.org/jira/browse/HIVE-26258> 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
>

Reply via email to