sql-tests/inputs/show-tblproperties.sql

0001 -- create a table with properties
0002 CREATE TABLE tbl (a INT, b STRING, c INT) USING parquet
0003 TBLPROPERTIES('p1'='v1', 'p2'='v2');
0004
0005 SHOW TBLPROPERTIES tbl;
0006 SHOW TBLPROPERTIES tbl("p1");
0007 SHOW TBLPROPERTIES tbl("p3");
0008
0009 DROP TABLE tbl;
0010
0011 -- create a view with properties
0012 CREATE VIEW view TBLPROPERTIES('p1'='v1', 'p2'='v2') AS SELECT 1 AS c1;
0013
0014 SHOW TBLPROPERTIES view;
0015 SHOW TBLPROPERTIES view("p1");
0016 SHOW TBLPROPERTIES view("p3");
0017
0018 DROP VIEW view;
0019
0020 -- create a temporary view with properties
0021 CREATE TEMPORARY VIEW tv TBLPROPERTIES('p1'='v1') AS SELECT 1 AS c1;
0022
0023 -- Properties for a temporary view should be empty
0024 SHOW TBLPROPERTIES tv;
0025
0026 DROP VIEW tv;