Projection Segmentation after a delete

Vivek_KVivek_K Registered User

I executed a delete statement using Primary key and the projection is segmented on the same PK. The delete could cause a data skew.
Is there a way to rehash() the projection on the segmentation clause to fix the skew. From the documentation I don't think mergeout or purge() will do it.

Answers

  • emorenoemoreno Employee, Registered User, VerticaExpert

    The hash is based on the value of field that you use, if you drop simnifically a specific value, you could have skewed data but the data will still skew if you keep the same value. The only way to resolve is to change the fields used for the segmentation or add an other field.
    HTH

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file