Disable Projection Temporarily?

Moderator: NorbertKrupa

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Disable Projection Temporarily?

Post by scutter » Thu Apr 17, 2014 3:25 pm

Yes, those directives work. I will just caution you about using unsupported/undocumented features in a production environment.

Referring to projections by name - that’s ok for testing a single projection, though doesn’t test which of a set of projection the optimizer will select. If you have three pairs of projections, it would be nice to be able to confirm which one will be used for each query.

—Sharon
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Disable Projection Temporarily?

Post by scutter » Thu Apr 17, 2014 3:26 pm

Oh and Norbert - the enhancement request I had filed on this topic was while I worked at Vertica - directly into the jira database. But you can certainly submit an enhancement request through a Support ticket.
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

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

Re: Disable Projection Temporarily?

Post by NorbertKrupa » Thu Apr 17, 2014 3:51 pm

I really wish that Vertica had a community facing issue system to request enhancements and submit bugs.

I'll mention the limitation with the function on my post.
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “New to Vertica Database Administration”