SELECT HASHAMP (HASHBUCKET (HASHROW ())) AS AMP#, COUNT (*) FROM GROUP BY 1 ORDER BY 2 DESC; There are HASHROW, HASHBUCKET, HASHAMP and HASHBAKAMP. The SQL hash functions are: * HASHROW (column(s)) * HASHBUCKET (hashrow) * HASHAMP (hashbucket) * HASHBAKAMP (hashbucket) Example: SELECT HASHROW ('Teradata') AS "Hash Value" , HASHBUCKET (HASHROW ('Teradata')) AS "Bucket Num" , HASHAMP (HASHBUCKET (HASHROW ('Teradata'))) AS "AMP Num" , HASHBAKAMP (HASHBUCKET (HASHROW ('Teradata'))) AS "AMP Fallback Num" ; This is really good, by looking into the result set of above written query you can easily find out the Data Distribution across all AMPs in your system and further you can easily identify un-even data distribution
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!