"Projection name - Projection base name" confusion

dimitri_p

Hi!

So when I create a new projection "projection1" on a Vertica cluster, the actual projection names will be:

projection1_b0
projection1_b1

and the base name will be: projection1.

If I then try to query projection1, I am forced to use one of the two names: _b0 or _b1, because select * from projection1 errors out with "object not found".

A question: how do I then refer to projection1 in the hint: /*+ PROJS(projection_name) */? Can I use the base name?

SruthiA

you cannot use base name.. you need to specify the full projection name.

dimitri_p

@SruthiA said:
you cannot use base name.. you need to specify the full projection name.

SELECT * FROM projections WHERE anchor_table_name='table1'

projection_name projection_basename
projection1_b1 projection1
projection1_b0 projection1

Which one is the full projection name please?

SruthiA

you can use any one.