-- Test that CREATE TABLE LIKE commands can take explicit table properties

CREATE TABLE test_table LIKE src TBLPROPERTIES('key'='value');

DESC FORMATTED test_table;

set hive.table.parameters.default=key1=value1;

--Test that CREATE TABLE LIKE commands can take default table properties

CREATE TABLE test_table1 LIKE src;

DESC FORMATTED test_table1;

-- Test that CREATE TABLE LIKE commands can take default and explicit table properties

CREATE TABLE test_table2 LIKE src TBLPROPERTIES('key2' = 'value2');

DESC FORMATTED test_table2;

set hive.ddl.createtablelike.properties.whitelist=key2;

-- Test that properties inherited are overwritten by explicitly set ones

CREATE TABLE test_table3 LIKE test_table2 TBLPROPERTIES('key2' = 'value3');

DESC FORMATTED test_table3;

--Test that CREATE TALBE LIKE on a view can take explicit table properties

CREATE VIEW test_view (key, value) AS SELECT * FROM src;

CREATE TABLE test_table4 LIKE test_view TBLPROPERTIES('key'='value');

DESC FORMATTED test_table4;