| drop table over10k_n15; |
| |
| create table over10k_n15( |
| t tinyint, |
| si smallint, |
| i int, |
| b bigint, |
| f float, |
| d double, |
| bo boolean, |
| s string, |
| ts timestamp, |
| `dec` decimal(4,2), |
| bin binary) |
| row format delimited |
| fields terminated by '|'; |
| |
| load data local inpath '../../data/files/over10k' into table over10k_n15; |
| |
| EXPLAIN |
| SELECT fv |
| FROM (SELECT distinct first_value(t) OVER ( PARTITION BY si ORDER BY i ) AS fv |
| FROM over10k_n15) sq |
| ORDER BY fv |
| LIMIT 10; |
| |
| SELECT fv |
| FROM (SELECT distinct first_value(t) OVER ( PARTITION BY si ORDER BY i ) AS fv |
| FROM over10k_n15) sq |
| ORDER BY fv |
| LIMIT 10; |
| |
| EXPLAIN |
| SELECT lv |
| FROM (SELECT distinct last_value(i) OVER ( PARTITION BY si ORDER BY i ) AS lv |
| FROM over10k_n15) sq |
| ORDER BY lv |
| LIMIT 10; |
| |
| SELECT lv |
| FROM (SELECT distinct last_value(i) OVER ( PARTITION BY si ORDER BY i ) AS lv |
| FROM over10k_n15) sq |
| ORDER BY lv |
| LIMIT 10; |
| |
| EXPLAIN |
| SELECT lv, fv |
| FROM (SELECT distinct last_value(i) OVER ( PARTITION BY si ORDER BY i ) AS lv, |
| first_value(t) OVER ( PARTITION BY si ORDER BY i ) AS fv |
| FROM over10k_n15) sq |
| ORDER BY lv, fv |
| LIMIT 50; |
| |
| SELECT lv, fv |
| FROM (SELECT distinct last_value(i) OVER ( PARTITION BY si ORDER BY i ) AS lv, |
| first_value(t) OVER ( PARTITION BY si ORDER BY i ) AS fv |
| FROM over10k_n15) sq |
| ORDER BY lv, fv |
| LIMIT 50; |