How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14418 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 |
What are tpump utility limitations?
what is sysdba and sysdbc ? which has high priority ?
What are the various indexes in teradata?
what are the day to day activities of teradata DBA ?
If RDBMS is halted what will you do ?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
Why managing the data is important?
What is meant by a dispatcher?
What are the frequently used data types in teradata?
What are the different softwares used with their functions in teradata?
what is DYNAMIC SQL in TD?
How to eliminate product joins in a teradata sql query?
Teradata 
