Projections in HP-Vertica

Projections in HP-Vertica:
When we create tables in the database management system the table would not be stored as it is in the physical disk. But the tables would be stored using the concept of projections in the HP-Vertica. Projections are way in which the tables are stored physically on the disk. Projections are created only when we initially load the data into the table and just when the table is created.

Projections can be created manually or by using the database designer (DBD) provided by HP-Vertica.

Example:
Consider the table consisting of the 3 columns as shown below:

When the projections are created on the initial load of the data the projections in particular node in the cluster would look as shown below:



Note:
In HP-Vertica columnar storage of the data occurs, hence the various columns are distributed as projections on the node of a cluster.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up

Talk is cheap Show me the code -)

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.


Article Tags :
Practice Tags :


2


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.