[SPARK-46629] SHOW CREATE TABLE shows incomplete information for STRUCT type fields.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Vitalii Li
• Reporter: Vitalii Li
• Created: 09/Jan/24 02:48
• Updated: 18/Jan/24 14:29
• Resolved: 18/Jan/24 14:29

Description

`SHOW CREATE TABLE` does not return struct fields `NOT NULL` qualifiers as well as comments.

E.g.
```
CREATE TABLE test(a STRUCT<b: INT NOT NULL, c: STRING COMMENT 'comment'>);
SHOW CREATE TABLE test;
```

Result:
```
CREATE TABLE test(a STRUCT<b: INT, c: STRING)
```

Issue Links

• links to: GitHub Pull Request #44644