sql-tests/inputs/describe.sql

0001 CREATE TABLE t (a STRING, b INT, c STRING, d STRING) USING parquet
0002   OPTIONS (a '1', b '2')
0003   PARTITIONED BY (c, d) CLUSTERED BY (a) SORTED BY (b ASC) INTO 2 BUCKETS
0004   COMMENT 'table_comment'
0005   TBLPROPERTIES (t 'test');
0006
0007 CREATE TEMPORARY VIEW temp_v AS SELECT * FROM t;
0008
0009 CREATE TEMPORARY VIEW temp_Data_Source_View
0010   USING org.apache.spark.sql.sources.DDLScanSource
0011   OPTIONS (
0012     From '1',
0013     To '10',
0014     Table 'test1');
0015
0016 CREATE VIEW v AS SELECT * FROM t;
0017
0018 ALTER TABLE t SET TBLPROPERTIES (e = '3');
0019
0020 ALTER TABLE t ADD PARTITION (c='Us', d=1);
0021
0022 DESCRIBE t;
0023
0024 DESC default.t;
0025
0026 DESC TABLE t;
0027
0028 DESC FORMATTED t;
0029
0030 DESC EXTENDED t;
0031
0032 ALTER TABLE t UNSET TBLPROPERTIES (e);
0033
0034 DESC EXTENDED t;
0035
0036 ALTER TABLE t UNSET TBLPROPERTIES (comment);
0037
0038 DESC EXTENDED t;
0039
0040 DESC t PARTITION (c='Us', d=1);
0041
0042 DESC EXTENDED t PARTITION (c='Us', d=1);
0043
0044 DESC FORMATTED t PARTITION (c='Us', d=1);
0045
0046 -- NoSuchPartitionException: Partition not found in table
0047 DESC t PARTITION (c='Us', d=2);
0048
0049 -- AnalysisException: Partition spec is invalid
0050 DESC t PARTITION (c='Us');
0051
0052 -- ParseException: PARTITION specification is incomplete
0053 DESC t PARTITION (c='Us', d);
0054
0055 -- DESC Temp View
0056
0057 DESC temp_v;
0058
0059 DESC TABLE temp_v;
0060
0061 DESC FORMATTED temp_v;
0062
0063 DESC EXTENDED temp_v;
0064
0065 DESC temp_Data_Source_View;
0066
0067 -- AnalysisException DESC PARTITION is not allowed on a temporary view
0068 DESC temp_v PARTITION (c='Us', d=1);
0069
0070 -- DESC Persistent View
0071
0072 DESC v;
0073
0074 DESC TABLE v;
0075
0076 DESC FORMATTED v;
0077
0078 DESC EXTENDED v;
0079
0080 -- AnalysisException DESC PARTITION is not allowed on a view
0081 DESC v PARTITION (c='Us', d=1);
0082
0083 -- Explain Describe Table
0084 EXPLAIN DESC t;
0085 EXPLAIN DESC EXTENDED t;
0086 EXPLAIN EXTENDED DESC t;
0087 EXPLAIN DESCRIBE t b;
0088 EXPLAIN DESCRIBE t PARTITION (c='Us', d=2);
0089
0090 -- DROP TEST TABLES/VIEWS
0091 DROP TABLE t;
0092
0093 DROP VIEW temp_v;
0094
0095 DROP VIEW temp_Data_Source_View;
0096
0097 DROP VIEW v;