Yuming Wang created SPARK-31033:
-----------------------------------
Summary: Support 'SHOW views' command
Key: SPARK-31033
URL: https://issues.apache.org/jira/browse/SPARK-31033
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 3.1.0
Reporter: Yuming Wang
Attachments: PowerBI.png
{noformat}
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
-----------^^^
{noformat}
Hive 3.1 support this command:
{noformat}
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
{noformat}
*PowerBI* also need this command:
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
