How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
Answer Posted / yuvaevergreen
Adding to the above,
hashrow gives the unique row hash (23 bit value) for any
value given as a parameter.
hashbucket gives the bucket value (16 bit) for any hashrow.
hashmap gives the ampno for the hashbucket.
Since, PI must be defined for any table, this hashing
function can be used to determine the ampno and the no of
rows in the amps.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain teradata utilities?
What's the difference between timestamp (0) and timestamp (6)?
What are the various reporting tools in the market?
What is basic teradata query language?
Explain and compare pros and cons of snow flake schemas?
What is the difference between global temporary tables and volatile temporary tables?
What are the advantages of teradata?
What are the different functions performed in development phase?
What is teradata? Also, list out some of the primary characteristics of teradata.
In general, how do you optimze any sql in teradata?
Differentiate primary key and partition key?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are different table types used in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is TPD?