Set/Change the EXPORT_ADDRESS

[sam]

How do a set/change the EXPORT_ADDRESS in the nodes table?

[NorbertKrupa]

What are you trying to do? Export to another Vertica cluster over the public network?

See this thread.

[sam]

I want to test native connection load balancing. Doc says the EXPORT_ADDRESS field is for "The IP address of the node (on the public network) used for import/export operations and native load-balancing."

[NorbertKrupa]

For native load balancing, you just need to enable it on the database side and enable it on the client side (see previous doc for links to client connections).