PREHOOK: query: drop table date_join1
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table date_join1
POSTHOOK: type: DROPTABLE
PREHOOK: query: -- SORT_QUERY_RESULTS

create table date_join1 (
  ORIGIN_CITY_NAME string,
  DEST_CITY_NAME string,
  FL_DATE date,
  ARR_DELAY float,
  FL_NUM int
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@date_join1
POSTHOOK: query: -- SORT_QUERY_RESULTS

create table date_join1 (
  ORIGIN_CITY_NAME string,
  DEST_CITY_NAME string,
  FL_DATE date,
  ARR_DELAY float,
  FL_NUM int
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@date_join1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@date_join1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@date_join1
PREHOOK: query: -- Note that there are 2 rows with date 2000-11-28, so we should expect 4 rows with that date in the join results
select t1.fl_num, t1.fl_date, t2.fl_num, t2.fl_date
  from date_join1 t1 
  join date_join1 t2 
  on (t1.fl_date = t2.fl_date)
PREHOOK: type: QUERY
PREHOOK: Input: default@date_join1
#### A masked pattern was here ####
POSTHOOK: query: -- Note that there are 2 rows with date 2000-11-28, so we should expect 4 rows with that date in the join results
select t1.fl_num, t1.fl_date, t2.fl_num, t2.fl_date
  from date_join1 t1 
  join date_join1 t2 
  on (t1.fl_date = t2.fl_date)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@date_join1
#### A masked pattern was here ####
1064	2000-11-20	1064	2000-11-20
1064	2000-11-28	1064	2000-11-28
1064	2000-11-28	1142	2000-11-28
1064	2010-10-20	1064	2010-10-20
1064	2010-10-28	1064	2010-10-28
1142	2000-11-21	1142	2000-11-21
1142	2000-11-28	1064	2000-11-28
1142	2000-11-28	1142	2000-11-28
1142	2010-10-21	1142	2010-10-21
1142	2010-10-29	1142	2010-10-29
1531	2000-11-25	1531	2000-11-25
1531	2010-10-25	1531	2010-10-25
1599	2000-11-22	1599	2000-11-22
1599	2010-10-22	1599	2010-10-22
1610	2000-11-26	1610	2000-11-26
1610	2010-10-26	1610	2010-10-26
3198	2000-11-27	3198	2000-11-27
3198	2010-10-27	3198	2010-10-27
361	2000-11-23	361	2000-11-23
361	2010-10-23	361	2010-10-23
897	2000-11-24	897	2000-11-24
897	2010-10-24	897	2010-10-24
PREHOOK: query: drop table date_join1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@date_join1
PREHOOK: Output: default@date_join1
POSTHOOK: query: drop table date_join1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@date_join1
POSTHOOK: Output: default@date_join1