#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
PREHOOK: Output: default@header_footer_table_1
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
POSTHOOK: Output: database:default
POSTHOOK: Output: default@header_footer_table_1
PREHOOK: query: SELECT * FROM header_footer_table_1
PREHOOK: type: QUERY
PREHOOK: Input: default@header_footer_table_1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM header_footer_table_1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@header_footer_table_1
#### A masked pattern was here ####
steven	hive	1
dave	oozie	2
xifa	phd	3
chuan	hadoop	4
shanyu	senior	5
steven2	hive	11
dave2	oozie	12
xifa2	phd	13
chuan2	hadoop	14
shanyu2	senior	15
david3	oozie	22
PREHOOK: query: SELECT * FROM header_footer_table_1 WHERE id < 50
PREHOOK: type: QUERY
PREHOOK: Input: default@header_footer_table_1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM header_footer_table_1 WHERE id < 50
POSTHOOK: type: QUERY
POSTHOOK: Input: default@header_footer_table_1
#### A masked pattern was here ####
steven	hive	1
dave	oozie	2
xifa	phd	3
chuan	hadoop	4
shanyu	senior	5
steven2	hive	11
dave2	oozie	12
xifa2	phd	13
chuan2	hadoop	14
shanyu2	senior	15
david3	oozie	22
PREHOOK: query: CREATE EXTERNAL TABLE header_footer_table_2 (name string, message string, id int) PARTITIONED BY (year int, month int, day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@header_footer_table_2
POSTHOOK: query: CREATE EXTERNAL TABLE header_footer_table_2 (name string, message string, id int) PARTITIONED BY (year int, month int, day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' tblproperties ("skip.header.line.count"="1", "skip.footer.line.count"="2")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@header_footer_table_2
#### A masked pattern was here ####
PREHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
PREHOOK: Output: default@header_footer_table_2
#### A masked pattern was here ####
POSTHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
POSTHOOK: Output: default@header_footer_table_2
POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=1
#### A masked pattern was here ####
PREHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
PREHOOK: Output: default@header_footer_table_2
#### A masked pattern was here ####
POSTHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
POSTHOOK: Output: default@header_footer_table_2
POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=2
#### A masked pattern was here ####
PREHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
PREHOOK: Output: default@header_footer_table_2
#### A masked pattern was here ####
POSTHOOK: type: ALTERTABLE_ADDPARTS
#### A masked pattern was here ####
POSTHOOK: Output: default@header_footer_table_2
POSTHOOK: Output: default@header_footer_table_2@year=2012/month=1/day=3
PREHOOK: query: SELECT * FROM header_footer_table_2
PREHOOK: type: QUERY
PREHOOK: Input: default@header_footer_table_2
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM header_footer_table_2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@header_footer_table_2
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3
#### A masked pattern was here ####
steven	hive	1	2012	1	1
dave	oozie	2	2012	1	1
xifa	phd	3	2012	1	1
chuan	hadoop	4	2012	1	1
shanyu	senior	5	2012	1	1
steven2	hive	11	2012	1	2
dave2	oozie	12	2012	1	2
xifa2	phd	13	2012	1	2
chuan2	hadoop	14	2012	1	2
shanyu2	senior	15	2012	1	2
david3	oozie	22	2012	1	3
PREHOOK: query: SELECT * FROM header_footer_table_2 WHERE id < 50
PREHOOK: type: QUERY
PREHOOK: Input: default@header_footer_table_2
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2
PREHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM header_footer_table_2 WHERE id < 50
POSTHOOK: type: QUERY
POSTHOOK: Input: default@header_footer_table_2
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=1
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=2
POSTHOOK: Input: default@header_footer_table_2@year=2012/month=1/day=3
#### A masked pattern was here ####
steven	hive	1	2012	1	1
dave	oozie	2	2012	1	1
xifa	phd	3	2012	1	1
chuan	hadoop	4	2012	1	1
shanyu	senior	5	2012	1	1
steven2	hive	11	2012	1	2
dave2	oozie	12	2012	1	2
xifa2	phd	13	2012	1	2
chuan2	hadoop	14	2012	1	2
shanyu2	senior	15	2012	1	2
david3	oozie	22	2012	1	3
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
PREHOOK: Output: default@emptytable
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
POSTHOOK: Output: database:default
POSTHOOK: Output: default@emptytable
PREHOOK: query: SELECT * FROM emptytable
PREHOOK: type: QUERY
PREHOOK: Input: default@emptytable
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM emptytable
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emptytable
#### A masked pattern was here ####
PREHOOK: query: SELECT * FROM emptytable WHERE id < 50
PREHOOK: type: QUERY
PREHOOK: Input: default@emptytable
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM emptytable WHERE id < 50
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emptytable
#### A masked pattern was here ####
PREHOOK: query: DROP TABLE header_footer_table_1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@header_footer_table_1
PREHOOK: Output: default@header_footer_table_1
POSTHOOK: query: DROP TABLE header_footer_table_1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@header_footer_table_1
POSTHOOK: Output: default@header_footer_table_1
PREHOOK: query: DROP TABLE header_footer_table_2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@header_footer_table_2
PREHOOK: Output: default@header_footer_table_2
POSTHOOK: query: DROP TABLE header_footer_table_2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@header_footer_table_2
POSTHOOK: Output: default@header_footer_table_2
PREHOOK: query: DROP TABLE emptytable
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@emptytable
PREHOOK: Output: default@emptytable
POSTHOOK: query: DROP TABLE emptytable
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@emptytable
POSTHOOK: Output: default@emptytable
#### A masked pattern was here ####