+2Hi!
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?
+1you cannot use base name.. you need to specify the full projection name.
+2@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?
+1you can use any one.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
