The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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.