Administration, Tips & Tricks

Skip lazy projection creation

0

I received a strange error when attempting to replace a super projection. I haven’t been able to reproduce this behavior (by explicitly defining the projections or by auto super projection creation). However, I’ll walk through scenario with the former projection, the replacement projection, and the resolution.

As a background, the table had the following structure and projection:

I wanted to replace dates_projection_01 with the following:

The difference between these projections is that _02 has an additional sort on the date column and is segmented. After attempting to create this projection, I received the error:

ROLLBACK 4753: Skip lazy projection creation since super projection for table dates already exists

The only documentation indicates that it’s associated with a duplicate table error.

I can understand that the same columns are covered in both projections, but only one column is sorted in projection _01. I couldn’t drop the projection because there would be no super projection left on the table. I proceeded to back up the table and recreate it with the explicitly defined projection:

Lastly, permissions needed to be readded. These can be backed up using a solution provided by datadug.com.

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: