| drop table over10k; | |
| create table over10k( | |
| 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; | |
| select distinct last_value(i) over ( partition by si order by i ), | |
| distinct first_value(t) over ( partition by si order by i ) | |
| from over10k ; |