DWHPro Insights

hash collision

A Teradata HASHROW Table Difference Screening Test Popular

Illustration of a glossy orange database cylinder with data fragments across its surface

Have you ever experienced extended waiting times for a table comparison to yield results? Have you ever been compelled to halt and defer quality checks on sizable tables owing to excessive resource utilization during a previous attempt? Hash comparison can be a compact preliminary screen, but it can miss real differences. It must not be …

Read more

Understanding Teradata Hash Collisions – A Case Study Widely read

Illustration of a stopwatch dial on an orange paint-splash background

To comprehend the issue of Teradata hash collisions, I will briefly explain how rows are allocated. If you are unfamiliar with Teradata Architecture or require a refresher, I suggest reading the following article beforehand: As you know, a hashing algorithm distributes a table’s rows to the AMPs. The Foundations The hashing algorithm accepts one or …

Read more

Protected by Security by CleanTalk and CleanTalk Anti-Spam