I had a problem creating a table with just SQL that is supported by Vertica. Most of the solutions that I came across online were using procedures. But after a lot of playing around and reading vertica documentation I found a solution to my problem. read more about the problem and the solution at Stackoverflow
Vertica - Calendar table with dates from a start date to an end date using analytical SQL
How to build a calendar table of every date between a start and end date in Vertica using plain SQL rather than a stored procedure, with a Stack Overflow link.
