The Vertica Database Forums

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

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

See this thread.

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."

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).