Say I Have table A with partition column P1 in HIVE External Table. I am running a complex query and while the query is running, one alter the partition P1 of Table A to point to different location. will the query execute successfully OR it will throw an error.
it will depend on whether you have enabled concurrency or not (hive.support.concurrency), with concurrency enabled and txn manager set as DbTxManager, while the query is running it will take a write lock on table and once you fire alter table set partition location, this DDL statement will wait for query to complete and release lock to perform alter operation or will time out (controlled by hive.txn.timeout)
Correct me if i am wrong. These properties are for the Transaction type tables. Will it impact non transaction type tables.