[HIVE-23128] SHOW CREATE TABLE Creates Incorrect Syntax When Database Specified

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.0, 3.1.2
• Fix Version/s: 4.0.0-alpha-1
• Target Version/s: 4.0.0
• Assignee: David Mollitor
• Reporter: David Mollitor
• Created: 02/Apr/20 03:54
• Updated: 17/Nov/22 08:50
• Resolved: 08/Apr/20 19:31

Description

show create table `sample_07`;
show create table `default`.`sample_07`;
show create table `default.sample_07`;

Results

CREATE TABLE `sample_07`(...)
CREATE TABLE `default.sample_07`(...)
CREATE TABLE `default.sample_07`(...);

All three show create table statements complete in Hive 2.x and 3.x and generate CREATE TABLE statements as show above. The first result is correct because it does not include the database name, however, the subsequent two results are invalid: each field must be quoted individually.  This causes a failure in recent versions of Hive because "SemanticException Table or database name may not contain dot(.) character."

If any components of a multiple-part name require quoting, quote them individually rather than quoting the name as a whole. For example, write `my-table`.`my-column`, not `my-table.my-column`.

• https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html

Issue Links

• is depended upon by: HIVE-23159 Cleanup ShowCreateTableOperation
• relates to: HIVE-11804 Different describe formatted behavior depending on whether the table name is qualified with database name or not
• relates to: HIVE-23149 Consistency of Parsing Object Identifiers