How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14841 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 do you mean by teradata intellicloud?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
what is identity columns in TD?
Can we collect statistics on multiple columns?
What is a level of granularity of a fact table?
Differentiate database data and data warehouse data?
how to load or extract the error table data ?
Highlight a few of the important components of Teradata?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
What do you mean by teradata sql assistant?
Why MLOAD needs Work Tables?
Why do Hash joins usually perform better than Merge Joins?
Teradata 
