PREHOOK: query: drop table if exists date_2 PREHOOK: type: DROPTABLE POSTHOOK: query: drop table if exists date_2 POSTHOOK: type: DROPTABLE PREHOOK: query: create table date_2 ( 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_2 POSTHOOK: query: create table date_2 ( 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_2 PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2 PREHOOK: type: LOAD #### A masked pattern was here #### PREHOOK: Output: default@date_2 POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt.1' OVERWRITE INTO TABLE date_2 POSTHOOK: type: LOAD #### A masked pattern was here #### POSTHOOK: Output: default@date_2 PREHOOK: query: select fl_date, fl_num from date_2 order by fl_date asc, fl_num desc PREHOOK: type: QUERY PREHOOK: Input: default@date_2 #### A masked pattern was here #### POSTHOOK: query: select fl_date, fl_num from date_2 order by fl_date asc, fl_num desc POSTHOOK: type: QUERY POSTHOOK: Input: default@date_2 #### A masked pattern was here #### 2010-10-20 7291 2010-10-20 3198 2010-10-20 3014 2010-10-20 2630 2010-10-20 1610 2010-10-20 1599 2010-10-20 1531 2010-10-20 1142 2010-10-20 1064 2010-10-20 897 2010-10-20 361 2010-10-21 7291 2010-10-21 3198 2010-10-21 3014 2010-10-21 2646 2010-10-21 2630 2010-10-21 1610 2010-10-21 1599 2010-10-21 1531 2010-10-21 1142 2010-10-21 1064 2010-10-21 897 2010-10-21 361 2010-10-22 3198 2010-10-22 3014 2010-10-22 2646 2010-10-22 2630 2010-10-22 1610 2010-10-22 1599 2010-10-22 1531 2010-10-22 1142 2010-10-22 1064 2010-10-22 897 2010-10-22 361 2010-10-23 7274 2010-10-23 5917 2010-10-23 5904 2010-10-23 5832 2010-10-23 3171 2010-10-23 3085 2010-10-23 2932 2010-10-23 1805 2010-10-23 650 2010-10-23 426 2010-10-23 384 2010-10-23 272 2010-10-24 7282 2010-10-24 3198 2010-10-24 3014 2010-10-24 2646 2010-10-24 2630 2010-10-24 2571 2010-10-24 2254 2010-10-24 1610 2010-10-24 1599 2010-10-24 1531 2010-10-24 897 2010-10-24 361 2010-10-25 7291 2010-10-25 3198 2010-10-25 3014 2010-10-25 2646 2010-10-25 2630 2010-10-25 1610 2010-10-25 1599 2010-10-25 1531 2010-10-25 1142 2010-10-25 1064 2010-10-25 897 2010-10-25 361 2010-10-26 7291 2010-10-26 3198 2010-10-26 3014 2010-10-26 2662 2010-10-26 2646 2010-10-26 2630 2010-10-26 1610 2010-10-26 1599 2010-10-26 1531 2010-10-26 1142 2010-10-26 1064 2010-10-26 897 2010-10-26 361 2010-10-27 7291 2010-10-27 3198 2010-10-27 3014 2010-10-27 2630 2010-10-27 1610 2010-10-27 1599 2010-10-27 1531 2010-10-27 1142 2010-10-27 1064 2010-10-27 897 2010-10-27 361 2010-10-28 7291 2010-10-28 3198 2010-10-28 3014 2010-10-28 2646 2010-10-28 2630 2010-10-28 1610 2010-10-28 1599 2010-10-28 1531 2010-10-28 1142 2010-10-28 1064 2010-10-28 897 2010-10-28 361 2010-10-29 7291 2010-10-29 3198 2010-10-29 3014 2010-10-29 2646 2010-10-29 2630 2010-10-29 1610 2010-10-29 1599 2010-10-29 1531 2010-10-29 1142 2010-10-29 1064 2010-10-29 897 2010-10-29 361 2010-10-30 5917 2010-10-30 5904 2010-10-30 3171 2010-10-30 3085 2010-10-30 2932 2010-10-30 2018 2010-10-30 1805 2010-10-30 650 2010-10-30 426 2010-10-30 384 2010-10-30 272 2010-10-31 7282 2010-10-31 3198 2010-10-31 2571 2010-10-31 1610 2010-10-31 1599 2010-10-31 1531 2010-10-31 897 2010-10-31 361 PREHOOK: query: select fl_date, fl_num from date_2 order by fl_date desc, fl_num asc PREHOOK: type: QUERY PREHOOK: Input: default@date_2 #### A masked pattern was here #### POSTHOOK: query: select fl_date, fl_num from date_2 order by fl_date desc, fl_num asc POSTHOOK: type: QUERY POSTHOOK: Input: default@date_2 #### A masked pattern was here #### 2010-10-31 361 2010-10-31 897 2010-10-31 1531 2010-10-31 1599 2010-10-31 1610 2010-10-31 2571 2010-10-31 3198 2010-10-31 7282 2010-10-30 272 2010-10-30 384 2010-10-30 426 2010-10-30 650 2010-10-30 1805 2010-10-30 2018 2010-10-30 2932 2010-10-30 3085 2010-10-30 3171 2010-10-30 5904 2010-10-30 5917 2010-10-29 361 2010-10-29 897 2010-10-29 1064 2010-10-29 1142 2010-10-29 1531 2010-10-29 1599 2010-10-29 1610 2010-10-29 2630 2010-10-29 2646 2010-10-29 3014 2010-10-29 3198 2010-10-29 7291 2010-10-28 361 2010-10-28 897 2010-10-28 1064 2010-10-28 1142 2010-10-28 1531 2010-10-28 1599 2010-10-28 1610 2010-10-28 2630 2010-10-28 2646 2010-10-28 3014 2010-10-28 3198 2010-10-28 7291 2010-10-27 361 2010-10-27 897 2010-10-27 1064 2010-10-27 1142 2010-10-27 1531 2010-10-27 1599 2010-10-27 1610 2010-10-27 2630 2010-10-27 3014 2010-10-27 3198 2010-10-27 7291 2010-10-26 361 2010-10-26 897 2010-10-26 1064 2010-10-26 1142 2010-10-26 1531 2010-10-26 1599 2010-10-26 1610 2010-10-26 2630 2010-10-26 2646 2010-10-26 2662 2010-10-26 3014 2010-10-26 3198 2010-10-26 7291 2010-10-25 361 2010-10-25 897 2010-10-25 1064 2010-10-25 1142 2010-10-25 1531 2010-10-25 1599 2010-10-25 1610 2010-10-25 2630 2010-10-25 2646 2010-10-25 3014 2010-10-25 3198 2010-10-25 7291 2010-10-24 361 2010-10-24 897 2010-10-24 1531 2010-10-24 1599 2010-10-24 1610 2010-10-24 2254 2010-10-24 2571 2010-10-24 2630 2010-10-24 2646 2010-10-24 3014 2010-10-24 3198 2010-10-24 7282 2010-10-23 272 2010-10-23 384 2010-10-23 426 2010-10-23 650 2010-10-23 1805 2010-10-23 2932 2010-10-23 3085 2010-10-23 3171 2010-10-23 5832 2010-10-23 5904 2010-10-23 5917 2010-10-23 7274 2010-10-22 361 2010-10-22 897 2010-10-22 1064 2010-10-22 1142 2010-10-22 1531 2010-10-22 1599 2010-10-22 1610 2010-10-22 2630 2010-10-22 2646 2010-10-22 3014 2010-10-22 3198 2010-10-21 361 2010-10-21 897 2010-10-21 1064 2010-10-21 1142 2010-10-21 1531 2010-10-21 1599 2010-10-21 1610 2010-10-21 2630 2010-10-21 2646 2010-10-21 3014 2010-10-21 3198 2010-10-21 7291 2010-10-20 361 2010-10-20 897 2010-10-20 1064 2010-10-20 1142 2010-10-20 1531 2010-10-20 1599 2010-10-20 1610 2010-10-20 2630 2010-10-20 3014 2010-10-20 3198 2010-10-20 7291 PREHOOK: query: select fl_date, count(*) from date_2 group by fl_date PREHOOK: type: QUERY PREHOOK: Input: default@date_2 #### A masked pattern was here #### POSTHOOK: query: select fl_date, count(*) from date_2 group by fl_date POSTHOOK: type: QUERY POSTHOOK: Input: default@date_2 #### A masked pattern was here #### 2010-10-20 11 2010-10-21 12 2010-10-22 11 2010-10-23 12 2010-10-24 12 2010-10-25 12 2010-10-26 13 2010-10-27 11 2010-10-28 12 2010-10-29 12 2010-10-30 11 2010-10-31 8 PREHOOK: query: drop table date_2 PREHOOK: type: DROPTABLE PREHOOK: Input: default@date_2 PREHOOK: Output: default@date_2 POSTHOOK: query: drop table date_2 POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@date_2 POSTHOOK: Output: default@date_2