"Projection name - Projection base name" confusion

dimitri_pdimitri_p ✭
in General Discussion

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?

Tagged:

Best Answer

Answers

  • SruthiASruthiA Administrator

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

  • dimitri_pdimitri_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?

This discussion has been closed.