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)*/
basename(lookup) Hint???
Moderator: NorbertKrupa
basename(lookup) Hint???
Have a GREAT day!
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: basename(lookup) Hint???
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.