[HIVE-24951] Table created with Uppercase name using CTAS does not produce result for select queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Metastore
• Labels: metastore_translator pull-request-available
• Assignee: Rajkumar Singh
• Reporter: Rajkumar Singh
• Created: 27/Mar/21 06:18
• Updated: 17/Nov/22 08:48
• Resolved: 21/Jun/21 16:47

Description

Steps to repro:

CREATE EXTERNAL TABLE MY_TEST AS SELECT * FROM source

Table created with Location but does not have any data moved to it.
/warehouse/tablespace/external/hive/MY_TEST

Issue Links

• is duplicated by: HIVE-25198 CTAS external table with camelcase and HMS translation ON is returning 0 records
• relates to: HIVE-25517 Follow up on HIVE-24951: External Table created with Uppercase name using CTAS does not produce result for select queries
• links to: GitHub Pull Request #2125
• links to: PR HIVE-24951