Skip to content

Instantly share code, notes, and snippets.

@cstrap
Created October 6, 2014 09:43
Show Gist options
  • Save cstrap/c4f4186abf78c044b1c4 to your computer and use it in GitHub Desktop.
Save cstrap/c4f4186abf78c044b1c4 to your computer and use it in GitHub Desktop.
Adding a HP Vertica node outside main cluster
-- First setup Vertica node.
-- When it's up'n'running launch from vsql:
CREATE SUBNET my_subnet with '192.168.0.0'; -- IP of your subnet may differs
-- The above statement creates a subnet between Vertica main clusters and the Vertica node.
-- NOTE: they must be in the same network
ALTER DATABASE VERTICA_DB EXPORT ON my_subnet;
-- At this point the Vertica node exposes VERTICA_DB database to subnet.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment