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
- 15448 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 |
how can i answer for question like teradat architecture in interveiw
What are the various indexes in teradata? How to use them?
What is the basic syntax for teradata select statement?
why use references rather than pointers in the public api, particularly for arguments which are modified?
How do you Generate Sequence in Teradata?
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Which Teradata concept allows more than one model generation?
Explain the term 'foreign key' related to relational database management system?
What is dimensional modeling?
What can be achieved by using the teradata rdbms?
What is the process to restart the multiload if it fails?
Teradata 
