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


DB-LINK equivalent for cross-cluster queries? — Vertica Forum

DB-LINK equivalent for cross-cluster queries?

DreaBrandfordDreaBrandford Vertica Employee Employee

Is Vertica going to develop something like DB-LINK, i.e. a possibility to run cross-cluster queries?

Asked during BDC session The Shortest Path to Vertica - Best Practices for Data Warehouse Migration & ETL
@marcothesane @Maurizio

Answers

  • ChuckBChuckB Vertica Employee Employee

    Import/export has a lot more flexibility than you'd guess, and so does object backup/restore.
    I used DB links in a former life, the perfomance wasn't good.
    Long way of saying, we don't support an identical feature, but we have interesting options to get similar results faster.

Leave a Comment

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