Archives of the TeradataForum
Message Posted: Tue, 27 Sep 2011 @ 19:33:37 GMT
<-- Anonymously Posted: Tuesday, September 27, 2011 15:25 -->
I'm trying to determine whether two tables on two different machines are the same.
I was considering using the hash functions against every column to produce a hash value that could be compared on each machine.
SELECT SUM (HASHBUCKET (HASHROW( Col1 ,Col2 , Col3, etc )) / ((HASHBUCKET()+1)/65536 )(BIGINT)) FROM myTable;
Now this does give me a value but I can't truly test it as the number of VPROCS is the same on both machines.
Will this work if the number of VPROC's is different? Does anyone have any other suggestion as how to test if the tables are in sync?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|