Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

inserting consecutive dates in impala

Solved Go to solution

inserting consecutive dates in impala

New Contributor

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

Accepted Solutions

Re: inserting consecutive dates in impala

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.
3 REPLIES 3
Highlighted

Re: inserting consecutive dates in impala

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

Re: inserting consecutive dates in impala

New Contributor

the  while loop  that works  in  microsoft SQL

looks like cloudera does not support  it ?

Re: inserting consecutive dates in impala

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.