-- 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, c String, d String) USING parquet PARTITIONED BY (c, d)
-- !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) USING parquet
-- !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 TABLE EXTENDED
-- !query 12 schema
struct<>
-- !query 12 output
org.apache.spark.sql.catalyst.parser.ParseException

mismatched input '<EOF>' expecting 'LIKE'(line 1, pos 19)

== SQL ==
SHOW TABLE EXTENDED
-------------------^^^


-- !query 13
SHOW TABLE 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 TABLE EXTENDED ... PARTITION(line 1, pos 0)

== SQL ==
SHOW TABLE 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