diff options
Diffstat (limited to 'sql/core/src/test/resources/sql-tests')
-rw-r--r-- | sql/core/src/test/resources/sql-tests/inputs/show-tables.sql | 31 | ||||
-rw-r--r-- | sql/core/src/test/resources/sql-tests/results/show-tables.sql.out | 187 |
2 files changed, 218 insertions, 0 deletions
diff --git a/sql/core/src/test/resources/sql-tests/inputs/show-tables.sql b/sql/core/src/test/resources/sql-tests/inputs/show-tables.sql new file mode 100644 index 0000000000..a16c39819a --- /dev/null +++ b/sql/core/src/test/resources/sql-tests/inputs/show-tables.sql @@ -0,0 +1,31 @@ +-- Test data. +CREATE DATABASE showdb; +USE showdb; +CREATE TABLE show_t1(a String, b Int) PARTITIONED BY (c String, d String); +ALTER TABLE show_t1 ADD PARTITION (c='Us', d=1); +CREATE TABLE show_t2(b String, d Int); +CREATE TEMPORARY VIEW show_t3(e int) USING parquet; +CREATE GLOBAL TEMP VIEW show_t4 AS SELECT 1 as col1; + +-- SHOW TABLES +SHOW TABLES; +SHOW TABLES IN showdb; + +-- SHOW TABLES WITH wildcard match +SHOW TABLES 'show_t*'; +SHOW TABLES LIKE 'show_t1*|show_t2*'; +SHOW TABLES IN showdb 'show_t*'; + +-- SHOW TABLES EXTENDED +-- Ignore these because there exist timestamp results, e.g. `Created`. +-- SHOW TABLES EXTENDED LIKE 'show_t*'; +SHOW TABLES EXTENDED; +SHOW TABLES EXTENDED LIKE 'show_t1' PARTITION(c='Us'); + +-- Clean Up +DROP TABLE show_t1; +DROP TABLE show_t2; +DROP VIEW show_t3; +DROP VIEW global_temp.show_t4; +USE default; +DROP DATABASE showdb; diff --git a/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out b/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out new file mode 100644 index 0000000000..a4f411258d --- /dev/null +++ b/sql/core/src/test/resources/sql-tests/results/show-tables.sql.out @@ -0,0 +1,187 @@ +-- Automatically generated by SQLQueryTestSuite +-- Number of queries: 20 + + +-- !query 0 +CREATE DATABASE showdb +-- !query 0 schema +struct<> +-- !query 0 output + + + +-- !query 1 +USE showdb +-- !query 1 schema +struct<> +-- !query 1 output + + + +-- !query 2 +CREATE TABLE show_t1(a String, b Int) PARTITIONED BY (c String, d String) +-- !query 2 schema +struct<> +-- !query 2 output + + + +-- !query 3 +ALTER TABLE show_t1 ADD PARTITION (c='Us', d=1) +-- !query 3 schema +struct<> +-- !query 3 output + + + +-- !query 4 +CREATE TABLE show_t2(b String, d Int) +-- !query 4 schema +struct<> +-- !query 4 output + + + +-- !query 5 +CREATE TEMPORARY VIEW show_t3(e int) USING parquet +-- !query 5 schema +struct<> +-- !query 5 output + + + +-- !query 6 +CREATE GLOBAL TEMP VIEW show_t4 AS SELECT 1 as col1 +-- !query 6 schema +struct<> +-- !query 6 output + + + +-- !query 7 +SHOW TABLES +-- !query 7 schema +struct<database:string,tableName:string,isTemporary:boolean> +-- !query 7 output +arraydata +mapdata +show_t1 +show_t2 +show_t3 +testdata + + +-- !query 8 +SHOW TABLES IN showdb +-- !query 8 schema +struct<database:string,tableName:string,isTemporary:boolean> +-- !query 8 output +arraydata +mapdata +show_t1 +show_t2 +show_t3 +testdata + + +-- !query 9 +SHOW TABLES 'show_t*' +-- !query 9 schema +struct<database:string,tableName:string,isTemporary:boolean> +-- !query 9 output +show_t1 +show_t2 +show_t3 + + +-- !query 10 +SHOW TABLES LIKE 'show_t1*|show_t2*' +-- !query 10 schema +struct<database:string,tableName:string,isTemporary:boolean> +-- !query 10 output +show_t1 +show_t2 + + +-- !query 11 +SHOW TABLES IN showdb 'show_t*' +-- !query 11 schema +struct<database:string,tableName:string,isTemporary:boolean> +-- !query 11 output +show_t1 +show_t2 +show_t3 + + +-- !query 12 +SHOW TABLES EXTENDED +-- !query 12 schema +struct<> +-- !query 12 output +org.apache.spark.sql.catalyst.parser.ParseException + +SHOW TABLES EXTENDED must have identifier_with_wildcards specified. +== SQL == +SHOW TABLES EXTENDED + + +-- !query 13 +SHOW TABLES EXTENDED LIKE 'show_t1' PARTITION(c='Us') +-- !query 13 schema +struct<> +-- !query 13 output +org.apache.spark.sql.catalyst.parser.ParseException + +Operation not allowed: SHOW TABLES [EXTENDED] ... PARTITION(line 1, pos 0) + +== SQL == +SHOW TABLES EXTENDED LIKE 'show_t1' PARTITION(c='Us') +^^^ + + +-- !query 14 +DROP TABLE show_t1 +-- !query 14 schema +struct<> +-- !query 14 output + + + +-- !query 15 +DROP TABLE show_t2 +-- !query 15 schema +struct<> +-- !query 15 output + + + +-- !query 16 +DROP VIEW show_t3 +-- !query 16 schema +struct<> +-- !query 16 output + + + +-- !query 17 +DROP VIEW global_temp.show_t4 +-- !query 17 schema +struct<> +-- !query 17 output + + + +-- !query 18 +USE default +-- !query 18 schema +struct<> +-- !query 18 output + + + +-- !query 19 +DROP DATABASE showdb +-- !query 19 schema +struct<> +-- !query 19 output + |