[SPARK-31033] Support 'SHOW views' command

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 04/Mar/20 05:13
• Updated: 03/May/20 11:24
• Resolved: 03/May/20 11:24

Description

spark-sql> show views;
Error in query:
missing 'FUNCTIONS' at '<EOF>'(line 1, pos 10)

== SQL ==
show views
----------^^^

spark-sql> show views in default;
Error in query:
missing 'FUNCTIONS' at 'in'(line 1, pos 11)

== SQL ==
show views in default
-----------^^^

Hive 3.1 support this command:

hive> select version();
OK
3.1.2 r8190d2be7b7165effa62bd21b7d60ef81fb0e4af
Time taken: 4.874 seconds, Fetched: 1 row(s)
hive> show views in default;
OK
Time taken: 0.01 seconds
hive> show views;
OK
Time taken: 0.013 seconds
hive> show views in default;
OK
Time taken: 0.013 seconds

PowerBI also need this command:

Issue Links

• duplicates: SPARK-31113 Support DDL "SHOW VIEWS"