Advertisement
Guest User

Untitled

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