diff options
Diffstat (limited to 'sql/core/src/test/resources/sql-tests/results/show-tables.sql.out')
-rw-r--r-- | sql/core/src/test/resources/sql-tests/results/show-tables.sql.out | 187 |
1 files changed, 187 insertions, 0 deletions
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 + |