| drop table date_join1; |
| |
| -- SORT_QUERY_RESULTS |
| |
| create table date_join1 ( |
| ORIGIN_CITY_NAME string, |
| DEST_CITY_NAME string, |
| FL_DATE date, |
| ARR_DELAY float, |
| FL_NUM int |
| ); |
| |
| LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE date_join1; |
| |
| -- 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); |
| |
| drop table date_join1; |