/
describe.sql
81 lines (48 loc) · 1.47 KB
/
describe.sql
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
CREATE TABLE t (a STRING, b INT, c STRING, d STRING) USING parquet
OPTIONS (a '1', b '2')
PARTITIONED BY (c, d) CLUSTERED BY (a) SORTED BY (b ASC) INTO 2 BUCKETS
COMMENT 'table_comment';
CREATE TEMPORARY VIEW temp_v AS SELECT * FROM t;
CREATE TEMPORARY VIEW temp_Data_Source_View
USING org.apache.spark.sql.sources.DDLScanSource
OPTIONS (
From '1',
To '10',
Table 'test1');
CREATE VIEW v AS SELECT * FROM t;
ALTER TABLE t SET TBLPROPERTIES (e = '3');
ALTER TABLE t ADD PARTITION (c='Us', d=1);
DESCRIBE t;
DESC default.t;
DESC TABLE t;
DESC FORMATTED t;
DESC EXTENDED t;
DESC t PARTITION (c='Us', d=1);
DESC EXTENDED t PARTITION (c='Us', d=1);
DESC FORMATTED t PARTITION (c='Us', d=1);
-- NoSuchPartitionException: Partition not found in table
DESC t PARTITION (c='Us', d=2);
-- AnalysisException: Partition spec is invalid
DESC t PARTITION (c='Us');
-- ParseException: PARTITION specification is incomplete
DESC t PARTITION (c='Us', d);
-- DESC Temp View
DESC temp_v;
DESC TABLE temp_v;
DESC FORMATTED temp_v;
DESC EXTENDED temp_v;
DESC temp_Data_Source_View;
-- AnalysisException DESC PARTITION is not allowed on a temporary view
DESC temp_v PARTITION (c='Us', d=1);
-- DESC Persistent View
DESC v;
DESC TABLE v;
DESC FORMATTED v;
DESC EXTENDED v;
-- AnalysisException DESC PARTITION is not allowed on a view
DESC v PARTITION (c='Us', d=1);
-- DROP TEST TABLES/VIEWS
DROP TABLE t;
DROP VIEW temp_v;
DROP VIEW temp_Data_Source_View;
DROP VIEW v;