Basic column mapping

SRA1

Hi This is a basic question .

When the columns in Vertica are stored separated with Encoding and compression.

How the engine works for a select query requesting multiple columns from a table.

How the mapping happens?

eli_revach

Hi ,
Columnar databases have several technics for accessing data , one of them is Late Materialization , i recomend you to read my blog to get some general understanding see attach :
http://community.hpe.com/t5/Business-Service-Management/The-backend-database-and-HP-Operations-Analytics/ba-p/6307851#.Vp5xVPkrJD8

 

i hope you will find it useful

Thanks