Hi all,
Simple question. If I have a table l_testtable. How do I create a super projection on this table ?
Thanks
Brendon
Creating a super projection
Moderator: NorbertKrupa
Re: Creating a super projection
Hi!
Here's an example from version 6.1:
Pretty simple
But, according to the docs:
Here's an example from version 6.1:
Code: Select all
dbadmin=> create table t1 (c1 int, c2 varchar);
CREATE TABLE
dbadmin=> create projection t1_p as select * from t1;
CREATE PROJECTION
dbadmin=> select is_super_projection from projections where projection_name = 't1_p';
is_super_projection
---------------------
t
(1 row)
But, according to the docs:
Vertica creates a default superprojection for the table. This superprojection ensures that all of the data is available for queries. However, these default superprojections might not optimize database performance, resulting in slow query performance and low data compression.
Code: Select all
dbadmin=> create table t1 (c1 int, c2 varchar);
CREATE TABLE
dbadmin=> insert into t1 values (1, 'Hi');
OUTPUT
--------
1
(1 row)
dbadmin=> select projection_name, is_super_projection from projections where anchor_table_name = 't1';
projection_name | is_super_projection
-----------------+---------------------
t1_b0 | t
t1_b1 | t
(2 rows)
Thanks,
Juliette
Juliette