[SPARK-46106] If the hive table is a table, the outsourcing information will be displayed during ShowCreateTableCommand.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.5.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: guihuawen
• Created: 26/Nov/23 14:21
• Updated: 10/Mar/24 00:20

Description

For example:
CREATE EXTERNAL TABLE test_extaral_1 (a String);

When using SHOW CREATE TABLE test, if it is an external table, it is not displayed whether it is an external table.

spark-sql> show create table test_extaral_1;
createtab_stmt
CREATE TABLE `test`.`test_extaral_1` (
  `a` STRING)
USING orc
LOCATION '/test/test_extaral_1'

 

You can modify the display and see whether it is the appearance。

spark-sql> show create table test_extaral_1;
createtab_stmt

CREATE EXTERNAL TABLE `test`.`test_extaral_1` (
  `a` STRING)
USING orc
CREATE EXTERNAL TABLE `test`.`test_extaral_1` (
LOCATION '/test/test_extaral_1'

 

 

 

 

Issue Links

• links to: GitHub Pull Request #44018
• links to: GitHub Pull Request #44019