Skip to main content

Basic column mapping

  • Jan 18, 2016 2:57 PM UTC
  • 1 reply
  • 5 views
SRA1
Forum|alt.badge.img+1
  • SRA1
  • Participating Frequently

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?

    1 reply

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • Jan 19, 2016 5:30 PM UTC

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement