blob: a4f411258dabec4943c55d7793790d14b5edea1c (
plain) (
tree)
|
|
-- 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
|