| 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-29 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-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 |