How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14366 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 default access rights in teradata? What explicit right can be given to a user?
How can you track login parameters of users in teradata?
What is primary index and secondary index?
in teradata level primary in table level allows duplicates why?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What is the command in bteq to check for session settings ?
Explain the new features of teradata?
What is meant by a node?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Is multi insert ansi standard?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
What do you mean by teradata sql assistant?
Teradata 
