Different query results when executing same query on different nodes

I'm running a query (a count) of records in a table on 2 different nodes within the cluster. Each query is being run in a vsql session against its own node. I'm seeing different values being returned by the 2 queries. The cluster has been loaded using parallel runs of the vsql utility as recommended by Vertica in http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/ConnectingToHPVertica/vsql/CopyingDataUsingVsql.htm?Highlight=vsql.


I don't believe there are any outstanding commits that need to be done - why are the values different?

Leave a Comment

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