blob: 904601bf1133c73482b6878bf59e80b9aa3214a2 (
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 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
|