basename(lookup) Hint???

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

basename(lookup) Hint???

Post by sarah » Fri Sep 04, 2015 8:45 pm

Good afternoon. Anyone have a clue what the "basename(lookup)" text in a create projection statement indicates?

For example:

CREATE PROJECTION public.retail_sales_super /*+basename(code_value),createtype(L)*/
Have a GREAT day!

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: basename(lookup) Hint???

Post by NorbertKrupa » Fri Sep 04, 2015 10:09 pm

It's the basename of the projection. For example, a projection basename can be customer_dimension_vmart and when segmented will have _b0, _b1 appended.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica Database Administration”