1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
|
-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 26
-- !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 LIKE 'show_t*'
-- !query 12 schema
struct<database:string,tableName:string,isTemporary:boolean,information:string>
-- !query 12 output
show_t3 true Table: show_t3
Created [not included in comparison]
Last Access [not included in comparison]
Type: VIEW
Schema: root
|-- e: integer (nullable = true)
showdb show_t1 false Database: showdb
Table: show_t1
Created [not included in comparison]
Last Access [not included in comparison]
Type: MANAGED
Provider: parquet
Location [not included in comparison]sql/core/spark-warehouse/showdb.db/show_t1
Partition Provider: Catalog
Partition Columns: [`c`, `d`]
Schema: root
|-- a: string (nullable = true)
|-- b: integer (nullable = true)
|-- c: string (nullable = true)
|-- d: string (nullable = true)
showdb show_t2 false Database: showdb
Table: show_t2
Created [not included in comparison]
Last Access [not included in comparison]
Type: MANAGED
Provider: parquet
Location [not included in comparison]sql/core/spark-warehouse/showdb.db/show_t2
Schema: root
|-- b: string (nullable = true)
|-- d: integer (nullable = true)
-- !query 13
SHOW TABLE EXTENDED
-- !query 13 schema
struct<>
-- !query 13 output
org.apache.spark.sql.catalyst.parser.ParseException
mismatched input '<EOF>' expecting 'LIKE'(line 1, pos 19)
== SQL ==
SHOW TABLE EXTENDED
-------------------^^^
-- !query 14
SHOW TABLE EXTENDED LIKE 'show_t1' PARTITION(c='Us', d=1)
-- !query 14 schema
struct<database:string,tableName:string,isTemporary:boolean,information:string>
-- !query 14 output
showdb show_t1 false Partition Values: [c=Us, d=1]
Location [not included in comparison]sql/core/spark-warehouse/showdb.db/show_t1/c=Us/d=1
-- !query 15
SHOW TABLE EXTENDED PARTITION(c='Us', d=1)
-- !query 15 schema
struct<>
-- !query 15 output
org.apache.spark.sql.catalyst.parser.ParseException
mismatched input 'PARTITION' expecting 'LIKE'(line 1, pos 20)
== SQL ==
SHOW TABLE EXTENDED PARTITION(c='Us', d=1)
--------------------^^^
-- !query 16
SHOW TABLE EXTENDED LIKE 'show_t*' PARTITION(c='Us', d=1)
-- !query 16 schema
struct<>
-- !query 16 output
org.apache.spark.sql.catalyst.analysis.NoSuchTableException
Table or view 'show_t*' not found in database 'showdb';
-- !query 17
SHOW TABLE EXTENDED LIKE 'show_t1' PARTITION(c='Us')
-- !query 17 schema
struct<>
-- !query 17 output
org.apache.spark.sql.AnalysisException
Partition spec is invalid. The spec (c) must match the partition spec (c, d) defined in table '`showdb`.`show_t1`';
-- !query 18
SHOW TABLE EXTENDED LIKE 'show_t1' PARTITION(a='Us', d=1)
-- !query 18 schema
struct<>
-- !query 18 output
org.apache.spark.sql.AnalysisException
Partition spec is invalid. The spec (a, d) must match the partition spec (c, d) defined in table '`showdb`.`show_t1`';
-- !query 19
SHOW TABLE EXTENDED LIKE 'show_t1' PARTITION(c='Ch', d=1)
-- !query 19 schema
struct<>
-- !query 19 output
org.apache.spark.sql.catalyst.analysis.NoSuchPartitionException
Partition not found in table 'show_t1' database 'showdb':
c -> Ch
d -> 1;
-- !query 20
DROP TABLE show_t1
-- !query 20 schema
struct<>
-- !query 20 output
-- !query 21
DROP TABLE show_t2
-- !query 21 schema
struct<>
-- !query 21 output
-- !query 22
DROP VIEW show_t3
-- !query 22 schema
struct<>
-- !query 22 output
-- !query 23
DROP VIEW global_temp.show_t4
-- !query 23 schema
struct<>
-- !query 23 output
-- !query 24
USE default
-- !query 24 schema
struct<>
-- !query 24 output
-- !query 25
DROP DATABASE showdb
-- !query 25 schema
struct<>
-- !query 25 output
|
