I know Vertica employs a lot of SQL experts.
How about Vertica creates a book with advanced Vertica SQL by example?
If everybody contributes one example I am pretty sure this book will be a success.
As an Admin I migrated one of our applications from a Java based mapping into pure SQL.
Took me almost 1/4 of a year.
In preparation Ive read
- SQL Cookbook
- SQL Antipatterns
- The Art of SQL
but some features like TIMESERIES .. OVER and complex datatypes are very special.
Real world examples explained is something we need to get an idea what's possible.
If ORACLE published books why VERTICA shouldn't?
