PREHOOK: query: create table alter1(a int, b int) PREHOOK: type: CREATETABLE POSTHOOK: query: create table alter1(a int, b int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set tblproperties ('a'='1', 'c'='4', 'd'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='TRUE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='TRUE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='FALSE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set tblproperties ('EXTERNAL'='FALSE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set serdeproperties('s1'='9') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set serdeproperties('s1'='9') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set serdeproperties('s1'='10', 's2' ='20') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set serdeproperties('s1'='10', 's2' ='20') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties('s1'='9') PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties('s1'='9') POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a string from deserializer b string from deserializer #### A masked pattern was here #### PREHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 set serde 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe extended alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter1 POSTHOOK: type: DESCTABLE a string from deserializer b string from deserializer #### A masked pattern was here #### PREHOOK: query: alter table alter1 replace columns (a int, b int, c string) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: alter table alter1 replace columns (a int, b int, c string) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: describe alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: describe alter1 POSTHOOK: type: DESCTABLE a int None b int None c string None PREHOOK: query: -- Cleanup DROP TABLE alter1 PREHOOK: type: DROPTABLE PREHOOK: Input: default@alter1 PREHOOK: Output: default@alter1 POSTHOOK: query: -- Cleanup DROP TABLE alter1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@alter1 POSTHOOK: Output: default@alter1 PREHOOK: query: SHOW TABLES PREHOOK: type: SHOWTABLES POSTHOOK: query: SHOW TABLES POSTHOOK: type: SHOWTABLES src src1 src_json src_sequencefile src_thrift srcbucket srcbucket2 srcpart PREHOOK: query: -- With non-default Database CREATE DATABASE alter1_db PREHOOK: type: CREATEDATABASE POSTHOOK: query: -- With non-default Database CREATE DATABASE alter1_db POSTHOOK: type: CREATEDATABASE PREHOOK: query: USE alter1_db PREHOOK: type: SWITCHDATABASE POSTHOOK: query: USE alter1_db POSTHOOK: type: SWITCHDATABASE PREHOOK: query: SHOW TABLES PREHOOK: type: SHOWTABLES POSTHOOK: query: SHOW TABLES POSTHOOK: type: SHOWTABLES PREHOOK: query: CREATE TABLE alter1(a INT, b INT) PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE alter1(a INT, b INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a int None b int None #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a string from deserializer b string from deserializer #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE EXTENDED alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter1 POSTHOOK: type: DESCTABLE a string from deserializer b string from deserializer #### A masked pattern was here #### PREHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: DESCRIBE alter1 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE alter1 POSTHOOK: type: DESCTABLE a int None b int None c string None PREHOOK: query: DROP TABLE alter1 PREHOOK: type: DROPTABLE PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 POSTHOOK: query: DROP TABLE alter1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 PREHOOK: query: USE default PREHOOK: type: SWITCHDATABASE POSTHOOK: query: USE default POSTHOOK: type: SWITCHDATABASE PREHOOK: query: DROP DATABASE alter1_db PREHOOK: type: DROPDATABASE POSTHOOK: query: DROP DATABASE alter1_db POSTHOOK: type: DROPDATABASE