Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

inserting consecutive dates in impala

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
Super Guru
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.

View solution in original post

3 REPLIES 3

avatar
Super Guru
Hi Tom, which "while" loop you refer to?

avatar
Explorer

the  while loop  that works  in  microsoft SQL

looks like cloudera does not support  it ?

avatar
Super Guru
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.