Different query results when executing same query on different nodes

Gareth_GaleGareth_Gale
in General Discussion

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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...