How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14855 Views
- IBM, I also Faced
- E-Mail Answers
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 vs. Redshift?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Explain and compare pros and cons of snow flake schemas?
Mention a few of the ETL tools that come under Teradata.
Difference between stored procedure and macro?
Explain the most common data types used in teradata?
In Teradata, how do we Generate Sequence?
What is meant by a Virtual Disk?
Did you write stored procedures in teradata?
What do you mean by fastexport in teradata?
What do you mean by caching in teradata?
Which is faster fastload or multiload?
List the logical and conditional operators that are used with teradata along with their meanings?
What is database exceptions in teradata?
