The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Data decompress during query time

Hi can you elaborate how vertica decompress the data during query ? Did it need to decompress the entire column file in the case of selecting small part of it or he has the ability a to decompress only partial ?

Comments

  • Vertica has capability to scan compressed data files. In case of selecting the small part entire column is not scanned but the limited part (specific ros containers) are scanned.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.