Projections in Vertica

nkarkare

It's my first day using Vertica. I created a database and some tables. Do I need to create the specific Projections right after creating the tables like we create the indexes? OR first should I populate the tables and then create projections? Any help would be appreciated.

Thank you

TomM

May I humbly suggest a training course on Vertica Essentials? I think it will help you and possibly save you time. https://my.vertica.com/resources/training/

In the meantime projections are created for your automatically on data load. Check out: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Projections/AutoProjections.htm?Highlight=auto

After you have your database populated with a reasonable amount of data check out:
https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/ConceptsGuide/Components/TheDatabaseDesigner.htm?Highlight=database designer

ckotsidimos

from my experience, If you know the queries you will run feed them to the db designer and then populate the db
If you first populate the db and then create projections you will face significant when refreshing the new projections

DW_infra

https://my.vertica.com/resources/training/ - no longer exists.

Do we need to create table with Shard key and shard key can be a composite one?

DaveT

Vertica has merged my.vertica.com into vertica.com. You can find training links here:
https://vertica.com/training/
https://vertica.com/web-based-training/

You have the ability to use the segmentation clause when you create a table which will cause a default projection to be created with that spec at the same time. If you don't use it a default projection will be created.

Here are some additional links for you regarding CREATE TABLE and auto projections:
https://vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATETABLE.htm
https://vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Projections/AutoProjections.htm