| |
| create table tab_date ( |
| origin_city_name string, |
| dest_city_name string, |
| fl_date date, |
| arr_delay float, |
| fl_num int |
| ); |
| |
| -- insert some data |
| load data local inpath '../../data/files/flights_join.txt' overwrite into table tab_date; |
| |
| select count(*) from tab_date; |
| |
| -- compute statistical summary of data |
| select compute_stats(fl_date, 'hll') from tab_date; |
| |
| explain |
| analyze table tab_date compute statistics for columns fl_date; |
| |
| analyze table tab_date compute statistics for columns fl_date; |
| |
| describe formatted tab_date fl_date; |
| |
| -- Update stats manually. Try both yyyy-mm-dd and integer value for high/low value |
| alter table tab_date update statistics for column fl_date set ('numDVs'='19', 'highValue'='2015-01-01', 'lowValue'='0'); |
| |
| describe formatted tab_date fl_date; |