We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Eon mode: projections created on ALL NODES or all shards? — Vertica Forum

Eon mode: projections created on ALL NODES or all shards?

DreaBrandfordDreaBrandford Vertica Employee Employee

Does Vertica in EON mode required the projections to be created on ALL NODES ? In scenario where node=shard count e.g "10 nodes & 10 shards"
Asked during BDC session Vertica Database Designer – Today and Tomorrow
@ybei

Answers

  • PanPan Employee

    It is created/segmented on all shards (except for replica shards, which is for unsegmented projections) instead of nodes.

Leave a Comment

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