Some sql tips

sequence and streams

CREATE SEQUENCE some_sequence
  START WITH -1
  INCREMENT BY -100

Convert the delimited string to list

select (column_value).getstringval()
from xmltable('"a","b","c"');