Added a flag which allows disabling locks with Hive catalog #7959

Job	Run time
integration-test-s3	1s
integration-test	1s
cibw-dev-env-smoke-test	1s
lint-and-unit-test (3.12)	1s
lint-and-unit-test (3.10)	1s
integration-test-adls	1s
integration-test-gcs	1s
lint-and-unit-test (3.11)	1s
lint-and-unit-test (3.13)	1s
integration-coverage-report	1s
	10s

Provide feedback