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
- 15478 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / n
Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS)))
AS AMP_NO,
COUNT(*)
From DATABASENAME.TABLE_NAME
GROUP BY 1;
| Is This Answer Correct ? | 30 Yes | 2 No |
Answer / 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 |
Comment whether bottleneck is an error or not.
what are the file sizes in your project?
what is the difference between bpo and call centre?
Highlight the differences between Primary Key and Primary Index.
In the Primary Index, what is the score of AMPs that are actively involved?
How is the teradata different from oracle?
What do you mean by fastexport in teradata?
In BTEQ, how are the session-mode parameters being set?
What are the joins in teradata?
What is the difference between fastload and multiload?
Can we collect statistics on table level?
what is the difference between primary index and secondary index?.
Teradata 
