[IMPALA-7037] Create table if not exists "foo" loads metadata for the table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.12.0
• Component/s: Frontend
• Epic Color: ghx-label-9
• Assignee: Unassigned
• Reporter: Mostafa Mokhtar
• Created: 15/May/18 22:13
• Updated: 15/May/18 22:13

Description

While trying to create a table if it doesn't exists, the statement took a long while as the frontend tried to load metadata for the table.

I0515 15:10:24.017038  8702 Frontend.java:935] Analyzing query: CREATE EXTERNAL TABLE IF NOT EXISTS 100k_partitions_1m_files (
 c1 STRING,
 c2 STRING
 )
 PARTITIONED BY (
 part STRING
 )
 STORED AS TEXTFILE
 LOCATION '/user/hive/warehouse/metadata_benchmarks.db/metrics_table'
I0515 15:10:24.065743  8702 FeSupport.java:274] Requesting prioritized load of table(s): metadata_benchmarks.100k_partitions_1m_files