Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- minval + delta
- FROM
- (
- SELECT
- min(year) minval,
- max(year) maxval,
- split('0 1 2 3 4 5 6 7 8 9 10 11 12 13 ... ... ... 298 299 300', ' ') delta_list
- FROM
- table
- ) t
- LATERAL VIEW explode(delta_list) dlist AS delta
- )
- t1
- WHERE (maxval-minval) >= delta
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement