Yuming Wang created SPARK-33630:
-----------------------------------
Summary: Support save SHOW command result to table
Key: SPARK-33630
URL: https://issues.apache.org/jira/browse/SPARK-33630
Project: Spark
Issue Type: Improvement
Components: SQL
Affects Versions: 3.1.0
Reporter: Yuming Wang
The Scala interface support save SHOW command result to table:
{code:scala}
spark.sql("CREATE TABLE AS SHOW TABLES IN default").write.saveAsTable("t")
{code}
But SQL interface does not support it:
{code:sql}
spark-sql> create table t using parquet as SHOW TABLES IN default;
Error in query:
mismatched input 'SHOW' expecting {'(', 'FROM', 'MAP', 'REDUCE', 'SELECT',
'TABLE', 'VALUES', 'WITH'}(line 1, pos 32)
== SQL ==
create table t using parquet as SHOW TABLES IN default
--------------------------------^^^
{code}
It would be great if SQL interface can support it.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
