PREHOOK: query: create table alter2(a int, b int) partitioned by (insertdate string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table alter2(a int, b int) partitioned by (insertdate string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@alter2 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01' PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@alter2 POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01' POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2@insertdate=2008-01-01 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02' PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@alter2 POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02' POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2@insertdate=2008-01-02 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 insertdate=2008-01-02 PREHOOK: query: drop table alter2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@alter2 PREHOOK: Output: default@alter2 POSTHOOK: query: drop table alter2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2 PREHOOK: query: create external table alter2(a int, b int) partitioned by (insertdate string) PREHOOK: type: CREATETABLE POSTHOOK: query: create external table alter2(a int, b int) partitioned by (insertdate string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@alter2 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01' PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@alter2 POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-01') location '2008/01/01' POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2@insertdate=2008-01-01 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 PREHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02' PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@alter2 POSTHOOK: query: alter table alter2 add partition (insertdate='2008-01-02') location '2008/01/02' POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2@insertdate=2008-01-02 PREHOOK: query: describe extended alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: describe extended alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: show partitions alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: show partitions alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 insertdate=2008-01-02 PREHOOK: query: -- Cleanup DROP TABLE alter2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@alter2 PREHOOK: Output: default@alter2 POSTHOOK: query: -- Cleanup DROP TABLE alter2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@alter2 POSTHOOK: Output: default@alter2 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: -- Using non-default Database CREATE DATABASE alter2_db PREHOOK: type: CREATEDATABASE POSTHOOK: query: -- Using non-default Database CREATE DATABASE alter2_db POSTHOOK: type: CREATEDATABASE PREHOOK: query: USE alter2_db PREHOOK: type: SWITCHDATABASE POSTHOOK: query: USE alter2_db POSTHOOK: type: SWITCHDATABASE PREHOOK: query: SHOW TABLES PREHOOK: type: SHOWTABLES POSTHOOK: query: SHOW TABLES POSTHOOK: type: SHOWTABLES PREHOOK: query: CREATE TABLE alter2(a int, b int) PARTITIONED BY (insertdate string) PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE TABLE alter2(a int, b int) PARTITIONED BY (insertdate string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: alter2_db@alter2 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: alter2_db@alter2 #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-01 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: alter2_db@alter2 #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-02 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 insertdate=2008-01-02 PREHOOK: query: DROP TABLE alter2 PREHOOK: type: DROPTABLE PREHOOK: Input: alter2_db@alter2 PREHOOK: Output: alter2_db@alter2 POSTHOOK: query: DROP TABLE alter2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2 PREHOOK: query: CREATE EXTERNAL TABLE alter2(a int, b int) PARTITIONED BY (insertdate string) PREHOOK: type: CREATETABLE POSTHOOK: query: CREATE EXTERNAL TABLE alter2(a int, b int) PARTITIONED BY (insertdate string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: alter2_db@alter2 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: alter2_db@alter2 #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-01 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 #### A masked pattern was here #### PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: alter2_db@alter2 #### A masked pattern was here #### POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2@insertdate=2008-01-02 PREHOOK: query: DESCRIBE EXTENDED alter2 PREHOOK: type: DESCTABLE POSTHOOK: query: DESCRIBE EXTENDED alter2 POSTHOOK: type: DESCTABLE a int b int insertdate string #### A masked pattern was here #### PREHOOK: query: SHOW PARTITIONS alter2 PREHOOK: type: SHOWPARTITIONS POSTHOOK: query: SHOW PARTITIONS alter2 POSTHOOK: type: SHOWPARTITIONS insertdate=2008-01-01 insertdate=2008-01-02 PREHOOK: query: DROP TABLE alter2 PREHOOK: type: DROPTABLE PREHOOK: Input: alter2_db@alter2 PREHOOK: Output: alter2_db@alter2 POSTHOOK: query: DROP TABLE alter2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: alter2_db@alter2 POSTHOOK: Output: alter2_db@alter2 PREHOOK: query: USE default PREHOOK: type: SWITCHDATABASE POSTHOOK: query: USE default POSTHOOK: type: SWITCHDATABASE PREHOOK: query: DROP DATABASE alter2_db PREHOOK: type: DROPDATABASE POSTHOOK: query: DROP DATABASE alter2_db POSTHOOK: type: DROPDATABASE