Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.