wangyum commented on a change in pull request #32852:
URL: https://github.com/apache/spark/pull/32852#discussion_r654096009
##########
File path: sql/core/src/test/resources/sql-tests/inputs/cte-ddl.sql
##########
@@ -0,0 +1,133 @@
+-- Test data.
+CREATE NAMESPACE IF NOT EXISTS query_ddl_namespace;
+USE NAMESPACE query_ddl_namespace;
+CREATE TABLE test_show_tables(a INT, b STRING, c INT) using parquet;
+CREATE TABLE test_show_table_properties (a INT, b STRING, c INT) USING parquet
TBLPROPERTIES('p1'='v1', 'p2'='v2');
+CREATE TABLE test_show_partitions(a String, b Int, c String, d String) USING
parquet PARTITIONED BY (c, d);
+ALTER TABLE test_show_partitions ADD PARTITION (c='Us', d=1);
+ALTER TABLE test_show_partitions ADD PARTITION (c='Us', d=2);
+ALTER TABLE test_show_partitions ADD PARTITION (c='Cn', d=1);
+CREATE VIEW view_1 AS SELECT * FROM test_show_tables;
+CREATE VIEW view_2 AS SELECT * FROM test_show_tables WHERE c=1;
+CREATE TEMPORARY VIEW test_show_views(e int) USING parquet;
+CREATE GLOBAL TEMP VIEW test_global_show_views AS SELECT 1 as col1;
+
+-- SHOW NAMESPACES
+SHOW NAMESPACES;
+WITH s AS (SHOW NAMESPACES) SELECT * FROM s;
+WITH s AS (SHOW NAMESPACES) SELECT namespace FROM s;
+WITH s AS (SHOW NAMESPACES) SELECT * FROM s WHERE namespace =
'query_ddl_namespace';
+WITH s AS (SHOW NAMESPACES) SELECT namespace FROM s WHERE namespace =
'query_ddl_namespace';
+WITH s(n) AS (SHOW NAMESPACES) SELECT * FROM s;
+WITH s(n) AS (SHOW NAMESPACES) SELECT n FROM s;
+WITH s(n) AS (SHOW NAMESPACES) SELECT * FROM s WHERE n = 'query_ddl_namespace';
+WITH s(n) AS (SHOW NAMESPACES) SELECT n FROM s WHERE n = 'query_ddl_namespace';
+WITH s AS (SHOW NAMESPACES) SELECT namespace FROM s ORDER BY namespace;
+WITH s AS (SHOW NAMESPACES) SELECT namespace FROM s GROUP BY namespace;
+WITH s(n) AS (SHOW NAMESPACES) SELECT n FROM s ORDER BY n;
+WITH s(n) AS (SHOW NAMESPACES) SELECT n FROM s GROUP BY n;
+
+-- SHOW TABLES
+SHOW TABLES;
+WITH s AS (SHOW TABLES) SELECT * FROM s;
+WITH s AS (SHOW TABLES) SELECT tableName FROM s;
+WITH s AS (SHOW TABLES) SELECT * FROM s WHERE tableName = 'test_show_tables';
+WITH s AS (SHOW TABLES) SELECT tableName FROM s WHERE tableName =
'test_show_tables';
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT * FROM s;
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT tn FROM s;
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT * FROM s WHERE tn =
'test_show_tables';
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT tn FROM s WHERE tn =
'test_show_tables';
+WITH s AS (SHOW TABLES) SELECT tableName FROM s ORDER BY namespace, tableName;
+WITH s AS (SHOW TABLES) SELECT COUNT(tableName) FROM s GROUP BY namespace;
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT tn FROM s ORDER BY ns, tn;
+WITH s(ns, tn, t) AS (SHOW TABLES) SELECT COUNT(tn) FROM s GROUP BY ns;
+
+-- SHOW TABLE EXTENDED
+SHOW TABLE EXTENDED LIKE 'test_show_table*';
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT * FROM s;
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT isTemporary
FROM s;
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT * FROM s WHERE
tableName = 'test_show_tables';
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT isTemporary
FROM s WHERE tableName = 'test_show_tables';
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT * FROM s;
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT t FROM s;
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT * FROM s WHERE tn = 'test_show_tables';
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT t FROM s WHERE tn = 'test_show_tables';
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT * FROM s ORDER
BY tableName;
+WITH s AS (SHOW TABLE EXTENDED LIKE 'test_show_table*') SELECT
COUNT(tableName) FROM s GROUP BY namespace;
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT * FROM s ORDER BY tn;
+WITH s(ns, tn, t, info) AS (SHOW TABLE EXTENDED LIKE 'test_show_table*')
SELECT COUNT(tn) FROM s GROUP BY ns;
+
+-- SHOW TBLPROPERTIES
+SHOW TBLPROPERTIES test_show_table_properties;
+WITH s AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT * FROM s;
+WITH s AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT key FROM s;
+WITH s AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT * FROM s
WHERE key = 'p1';
+WITH s AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT key FROM s
WHERE key = 'p1';
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT * FROM
s;
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT k FROM
s;
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT * FROM
s WHERE k = 'p1';
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT k FROM
s WHERE k = 'p1';
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT k FROM
s ORDER BY v;
+WITH s(k, v) AS (SHOW TBLPROPERTIES test_show_table_properties) SELECT
COUNT(k) FROM s GROUP BY v;
+
+-- SHOW PARTITIONS
+SHOW PARTITIONS test_show_partitions;
+WITH s AS (SHOW PARTITIONS test_show_partitions) SELECT * FROM s;
+WITH s AS (SHOW PARTITIONS test_show_partitions) SELECT partition FROM s;
+WITH s AS (SHOW PARTITIONS test_show_partitions) SELECT * FROM s WHERE
partition = 'c=Us/d=1';
+WITH s AS (SHOW PARTITIONS test_show_partitions) SELECT partition FROM s WHERE
partition = 'c=Us/d=1';
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT * FROM s;
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT p FROM s;
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT * FROM s WHERE p =
'c=Us/d=1';
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT p FROM s WHERE p =
'c=Us/d=1';
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT p FROM s ORDER BY p;
+WITH s(p) AS (SHOW PARTITIONS test_show_partitions) SELECT p FROM s GROUP BY p;
+
+-- SHOW COLUMNS
+SHOW COLUMNS in test_show_tables;
+WITH s AS (SHOW COLUMNS in test_show_tables) SELECT * FROM s;
+WITH s AS (SHOW COLUMNS in test_show_tables) SELECT col_name FROM s;
+WITH s AS (SHOW COLUMNS in test_show_tables) SELECT * FROM s WHERE col_name =
'a';
+WITH s AS (SHOW COLUMNS in test_show_tables) SELECT col_name FROM s WHERE
col_name = 'a';
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT * FROM s;
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT c FROM s;
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT * FROM s WHERE c = 'a';
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT c FROM s WHERE c = 'a';
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT c FROM s ORDER BY c;
+WITH s(c) AS (SHOW COLUMNS in test_show_tables) SELECT c FROM s GROUP BY c;
+
+-- SHOW VIEWS
+SHOW VIEWS;
+WITH s AS (SHOW VIEWS) SELECT * FROM s;
+WITH s AS (SHOW VIEWS) SELECT viewName FROM s;
+WITH s AS (SHOW VIEWS) SELECT * FROM s WHERE viewName = 'test_show_views';
+WITH s AS (SHOW VIEWS) SELECT viewName FROM s WHERE viewName =
'test_show_views';
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT * FROM s;
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT vn FROM s;
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT * FROM s WHERE vn = 'test_show_views';
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT vn FROM s WHERE vn =
'test_show_views';
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT vn FROM s ORDER BY vn;
+WITH s(ns, vn, t) AS (SHOW VIEWS) SELECT COUNT(vn) FROM s GROUP BY ns;
+
+-- SHOW FUNCTIONS
+WITH s AS (SHOW FUNCTIONS) SELECT * FROM s LIMIT 3;
+WITH s AS (SHOW FUNCTIONS) SELECT function FROM s LIMIT 3;
+WITH s AS (SHOW FUNCTIONS) SELECT * FROM s WHERE function LIKE 'an%';
+WITH s AS (SHOW FUNCTIONS) SELECT function FROM s WHERE function LIKE 'an%';
+WITH s(f) AS (SHOW FUNCTIONS) SELECT * FROM s LIMIT 3;
+WITH s(f) AS (SHOW FUNCTIONS) SELECT f FROM s LIMIT 3;
+WITH s(f) AS (SHOW FUNCTIONS) SELECT * FROM s WHERE f LIKE 'an%';
+WITH s(f) AS (SHOW FUNCTIONS) SELECT f FROM s WHERE f LIKE 'an%';
+WITH s(f) AS (SHOW FUNCTIONS) SELECT f FROM s ORDER BY f LIMIT 3;
+WITH s(f) AS (SHOW FUNCTIONS) SELECT f FROM s GROUP BY f LIMIT 3;
+
+-- Clean Up
+DROP VIEW global_temp.test_global_show_views;
+DROP VIEW test_show_views;
+DROP VIEW view_2;
+DROP VIEW view_1;
+DROP TABLE test_show_partitions;
+DROP TABLE test_show_table_properties;
+DROP TABLE test_show_tables;
+USE default;
+DROP NAMESPACE query_ddl_namespace;
Review comment:
newline character?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
