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