How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
Answer Posted / 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 |
Post New Answer View All Answers
What is the primary index in teradata?
What are differences between teradata and ansi session modes in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the use of virtual processor connectivity in teradata?
What is the difference between fastload and multiload? Which one is faster?
What are default access rights in teradata? What explicit right can be given to a user?
Describe primary index in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
How can you track login parameters of users in teradata?
Difference between inner join and outer join?
What are the steps to create a data model?
What do high confidence, low confidence and no confidence mean in explain plan?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is meant by a dispatcher?
Explain fallback in teradata?