show-create-table.sql.out

-- Automatically generated by SQLQueryTestSuite
-- Number of queries: 38


-- !query 0
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
-- !query 0 schema
struct<>
-- !query 0 output



-- !query 1
SHOW CREATE TABLE tbl
-- !query 1 schema
struct<createtab_stmt:string>
-- !query 1 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet


-- !query 2
DROP TABLE tbl
-- !query 2 schema
struct<>
-- !query 2 output



-- !query 3
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
OPTIONS ('a' 1)
-- !query 3 schema
struct<>
-- !query 3 output



-- !query 4
SHOW CREATE TABLE tbl
-- !query 4 schema
struct<createtab_stmt:string>
-- !query 4 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
OPTIONS (
  `a` '1'
)


-- !query 5
DROP TABLE tbl
-- !query 5 schema
struct<>
-- !query 5 output



-- !query 6
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
OPTIONS ('path' '/path/to/table')
-- !query 6 schema
struct<>
-- !query 6 output



-- !query 7
SHOW CREATE TABLE tbl
-- !query 7 schema
struct<createtab_stmt:string>
-- !query 7 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
LOCATION 'file:/path/to/table'


-- !query 8
DROP TABLE tbl
-- !query 8 schema
struct<>
-- !query 8 output



-- !query 9
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
LOCATION '/path/to/table'
-- !query 9 schema
struct<>
-- !query 9 output



-- !query 10
SHOW CREATE TABLE tbl
-- !query 10 schema
struct<createtab_stmt:string>
-- !query 10 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
LOCATION 'file:/path/to/table'


-- !query 11
DROP TABLE tbl
-- !query 11 schema
struct<>
-- !query 11 output



-- !query 12
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
PARTITIONED BY (a)
-- !query 12 schema
struct<>
-- !query 12 output



-- !query 13
SHOW CREATE TABLE tbl
-- !query 13 schema
struct<createtab_stmt:string>
-- !query 13 output
CREATE TABLE `tbl` (`b` STRING, `c` INT, `a` INT)
USING parquet
PARTITIONED BY (a)


-- !query 14
DROP TABLE tbl
-- !query 14 schema
struct<>
-- !query 14 output



-- !query 15
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
CLUSTERED BY (a) SORTED BY (b ASC) INTO 2 BUCKETS
-- !query 15 schema
struct<>
-- !query 15 output



-- !query 16
SHOW CREATE TABLE tbl
-- !query 16 schema
struct<createtab_stmt:string>
-- !query 16 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
CLUSTERED BY (a)
SORTED BY (b)
INTO 2 BUCKETS


-- !query 17
DROP TABLE tbl
-- !query 17 schema
struct<>
-- !query 17 output



-- !query 18
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
COMMENT 'This is a comment'
-- !query 18 schema
struct<>
-- !query 18 output



-- !query 19
SHOW CREATE TABLE tbl
-- !query 19 schema
struct<createtab_stmt:string>
-- !query 19 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
COMMENT 'This is a comment'


-- !query 20
DROP TABLE tbl
-- !query 20 schema
struct<>
-- !query 20 output



-- !query 21
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
TBLPROPERTIES ('a' = '1')
-- !query 21 schema
struct<>
-- !query 21 output



-- !query 22
SHOW CREATE TABLE tbl
-- !query 22 schema
struct<createtab_stmt:string>
-- !query 22 output
CREATE TABLE `tbl` (`a` INT, `b` STRING, `c` INT)
USING parquet
TBLPROPERTIES (
  'a' = '1'
)


-- !query 23
DROP TABLE tbl
-- !query 23 schema
struct<>
-- !query 23 output



-- !query 24
CREATE TABLE tbl (a REAL, b NUMERIC, c NUMERIC(10), d NUMERIC(10,1)) USING parquet
-- !query 24 schema
struct<>
-- !query 24 output



-- !query 25
SHOW CREATE TABLE tbl
-- !query 25 schema
struct<createtab_stmt:string>
-- !query 25 output
CREATE TABLE `tbl` (`a` FLOAT, `b` DECIMAL(10,0), `c` DECIMAL(10,0), `d` DECIMAL(10,1))
USING parquet


-- !query 26
DROP TABLE tbl
-- !query 26 schema
struct<>
-- !query 26 output



-- !query 27
CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
-- !query 27 schema
struct<>
-- !query 27 output



-- !query 28
CREATE VIEW view_SPARK_30302 (aaa, bbb)
AS SELECT a, b FROM tbl
-- !query 28 schema
struct<>
-- !query 28 output



-- !query 29
SHOW CREATE TABLE view_SPARK_30302
-- !query 29 schema
struct<createtab_stmt:string>
-- !query 29 output
CREATE VIEW `view_SPARK_30302`(`aaa`, `bbb`)
AS SELECT a, b FROM tbl


-- !query 30
DROP VIEW view_SPARK_30302
-- !query 30 schema
struct<>
-- !query 30 output



-- !query 31
CREATE VIEW view_SPARK_30302 (aaa COMMENT 'comment with \'quoted text\' for aaa', bbb)
COMMENT 'This is a comment with \'quoted text\' for view'
AS SELECT a, b FROM tbl
-- !query 31 schema
struct<>
-- !query 31 output



-- !query 32
SHOW CREATE TABLE view_SPARK_30302
-- !query 32 schema
struct<createtab_stmt:string>
-- !query 32 output
CREATE VIEW `view_SPARK_30302`(`aaa` COMMENT 'comment with \'quoted text\' for aaa', `bbb`)
COMMENT 'This is a comment with \'quoted text\' for view'
AS SELECT a, b FROM tbl


-- !query 33
DROP VIEW view_SPARK_30302
-- !query 33 schema
struct<>
-- !query 33 output



-- !query 34
CREATE VIEW view_SPARK_30302 (aaa, bbb)
TBLPROPERTIES ('a' = '1', 'b' = '2')
AS SELECT a, b FROM tbl
-- !query 34 schema
struct<>
-- !query 34 output



-- !query 35
SHOW CREATE TABLE view_SPARK_30302
-- !query 35 schema
struct<createtab_stmt:string>
-- !query 35 output
CREATE VIEW `view_SPARK_30302`(`aaa`, `bbb`)
TBLPROPERTIES (
  'a' = '1',
  'b' = '2'
)
AS SELECT a, b FROM tbl


-- !query 36
DROP VIEW view_SPARK_30302
-- !query 36 schema
struct<>
-- !query 36 output



-- !query 37
DROP TABLE tbl
-- !query 37 schema
struct<>
-- !query 37 output