sql-tests/inputs/show-create-table.sql

0001 -- simple
0002 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet;
0003
0004 SHOW CREATE TABLE tbl;
0005 DROP TABLE tbl;
0006
0007
0008 -- options
0009 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0010 OPTIONS ('a' 1);
0011
0012 SHOW CREATE TABLE tbl;
0013 DROP TABLE tbl;
0014
0015
0016 -- path option
0017 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0018 OPTIONS ('path' '/path/to/table');
0019
0020 SHOW CREATE TABLE tbl;
0021 DROP TABLE tbl;
0022
0023
0024 -- location
0025 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0026 LOCATION '/path/to/table';
0027
0028 SHOW CREATE TABLE tbl;
0029 DROP TABLE tbl;
0030
0031
0032 -- partition by
0033 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0034 PARTITIONED BY (a);
0035
0036 SHOW CREATE TABLE tbl;
0037 DROP TABLE tbl;
0038
0039
0040 -- clustered by
0041 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0042 CLUSTERED BY (a) SORTED BY (b ASC) INTO 2 BUCKETS;
0043
0044 SHOW CREATE TABLE tbl;
0045 DROP TABLE tbl;
0046
0047
0048 -- comment
0049 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0050 COMMENT 'This is a comment';
0051
0052 SHOW CREATE TABLE tbl;
0053 DROP TABLE tbl;
0054
0055
0056 -- tblproperties
0057 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0058 TBLPROPERTIES ('a' = '1');
0059
0060 SHOW CREATE TABLE tbl;
0061 DROP TABLE tbl;
0062
0063 -- float alias real and decimal alias numeric
0064 CREATE TABLE tbl (a REAL, b NUMERIC, c NUMERIC(10), d NUMERIC(10,1)) USING parquet;
0065 SHOW CREATE TABLE tbl;
0066 DROP TABLE tbl;
0067
0068
0069 -- show create table for view
0070 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet;
0071
0072 -- simple
0073 CREATE VIEW view_SPARK_30302 (aaa, bbb)
0074 AS SELECT a, b FROM tbl;
0075
0076 SHOW CREATE TABLE view_SPARK_30302 AS SERDE;
0077
0078 SHOW CREATE TABLE view_SPARK_30302;
0079
0080 DROP VIEW view_SPARK_30302;
0081
0082
0083 -- comment
0084 CREATE VIEW view_SPARK_30302 (aaa COMMENT 'comment with \'quoted text\' for aaa', bbb)
0085 COMMENT 'This is a comment with \'quoted text\' for view'
0086 AS SELECT a, b FROM tbl;
0087
0088 SHOW CREATE TABLE view_SPARK_30302 AS SERDE;
0089
0090 SHOW CREATE TABLE view_SPARK_30302;
0091
0092 DROP VIEW view_SPARK_30302;
0093
0094
0095 -- tblproperties
0096 CREATE VIEW view_SPARK_30302 (aaa, bbb)
0097 TBLPROPERTIES ('a' = '1', 'b' = '2')
0098 AS SELECT a, b FROM tbl;
0099
0100 SHOW CREATE TABLE view_SPARK_30302 AS SERDE;
0101
0102 SHOW CREATE TABLE view_SPARK_30302;
0103
0104 DROP VIEW view_SPARK_30302;
0105
0106 DROP TABLE tbl;