This message was deleted.

Hi Cactus -- here's one way ...

insert into new_table
WITH seq10 AS (
  SELECT * FROM TABLE(EXTERN(
    '{"type":"inline","data":"0\n1\n2\n3\n4\n5\n6\n7\n8\n9\n"}',
    '{"type":"csv","findColumnsFromHeader":false,"columns":["val"]}',
    '[{"name":"val","type":"long"}]'
  ))
)
SELECT TIMESTAMPADD(DAY, b.val*10 + c.val, CURRENT_TIMESTAMP) __time, '-' flag from seq10 b CROSS JOIN seq10 c
PARTITIONED BY ALL

Let me know if you have any questions. Thanks. John

Thank you!

in the Imply release, there is a DATE_EXPAND function which (I believe) does that

Yes. And coming to open-source very soon