question Re: inserting consecutive dates in impala in Support Questions

inserting consecutive dates in impala

Tome — Fri, 16 Sep 2022 14:03:17 GMT

Hi, i am sorry if i am postiing this where it should not be posted.New to impala/hive , new to this community site but i need to populate an empty table of one field (date) with dates (from 1990-01-01 till 2099-12-31) and the "while" loop does not seem to be working here. Any suggestions,or links you guys can provide please?

Thanks,

Tom

Re: inserting consecutive dates in impala

EricL — Wed, 16 Jan 2019 06:59:32 GMT

Hi Tom, which "while" loop you refer to?

Re: inserting consecutive dates in impala

Tome — Sun, 20 Jan 2019 17:11:55 GMT

the while loop that works in microsoft SQL

looks like cloudera does not support it ?

Re: inserting consecutive dates in impala

EricL — Sun, 20 Jan 2019 23:58:35 GMT

I am not familiar with Microsoft SQL, so I am still not sure which while loop you meant. But most likely not supported in Impala.