The Most Important Thing a Vertica Developer Needs to Know

For the first post, I wanted to set the basis for the blog. This blog is about learning how to develop in Vertica, the up-and-coming columnar database. Due to the relative newness of the product, I'm still learning. So I want this to be a hub for those experiences.

With that as preface, I want to give the most basic, helpful and wide-ranging bit of advice: When you aren't sure what the SQL syntax for Vertica is, just look up PostgreSQL's feature set.

Do you want to determine the value of the hour for a timestamp column? extract(hour from ) just like in Postgres.

The only caveat I would add is that analytical functions may or may not be implemented depending on the version of Vertica you are using.