[IMPALA-11356] CDP_BUILD_NUMBER 27992803 failing because of new Hive behaviour

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.1.0
• Component/s: Infrastructure
• Labels: iceberg impala-iceberg
• Target Version: Impala 4.2.0
• Epic Color: ghx-label-3
• Assignee: Tamas Mate
• Reporter: Tamas Mate
• Created: 14/Jun/22 08:33
• Updated: 21/Jun/22 16:59
• Resolved: 21/Jun/22 16:59

Description

HIVE-24920 results in the change in HMS' behavior. Specifically, after this Hive commit, creation of an external table under the managed directory will be allowed if the HMS configuration of 'hive.metastore.warehouse.external.dir' is not explicitly set, i.e., isExternalWarehouseSet() evaluates to false.

test_sfs is failing with:

query_test/test_sfs.py:52: in test_sfs
    self.run_test_case('QueryTest/sfs', vector, unique_database)
common/impala_test_suite.py:741: in run_test_case
    expected_str, query)
E   AssertionError: Expected exception: An external table's location should not be located within managed warehouse root directory
E   
E   when running:
E   
E   CREATE EXTERNAL TABLE test_tbl_03 (s STRING, i INT) STORED AS PARQUET
E   LOCATION 'sfs+hdfs://localhost:20500/test-warehouse/managed/test_sfs_833dc94f.db/sfs_d3.parq/#SINGLEFILE#'