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
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is meant by Teradata Gateway?
Name the five phases that come under MultiLoad Utility.
Explain the term 'columns' related to relational database management system?
What is the difference between fastload and multiload? Which one is faster?
What are teradata utilities?
Describe primary index in teradata?
What are the main components of teradata system?
Comment whether bottleneck is an error or not.
What is teradata? What are some primary characteristics of teradata?
What is a level of granularity of a fact table?
What are the advantages of teradata?
What is the difference between global temporary tables and volatile temporary tables?
Why is the case expression used in teradata?
What is the function of parser component in teradata?