Interested to Buy Any Domain ? << Click Here >> for more details...
How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 15439 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
why use references rather than pointers in the public api, particularly for arguments which are modified?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the use of virtual processor connectivity in teradata?
How do you verify a complicated sql?
In the Primary Index, what is the score of AMPs that are actively involved?
What is multi insert?
How is MLOAD Client System restarted after execution?
Describe primary index in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What happens when a node suffers a downfall?
What can be achieved by using the teradata rdbms?
any one answer me how they can analyzing the project using data ware housing?
Where is teradata rdbms used?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the multi-insert?
