How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14413 Views
- IBM, I also Faced
- E-Mail Answers
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 command in bteq to check for session settings ?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How many sessions of MAX is PE capable of handling at a particular time?
What do you mean by ttu in teradata?
What is node? How many nodes and amps used in your previous project?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
List out some of the primary characteristics of teradata.
What is partitioned primary index (ppi)?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is upsert statement in teradata?
Write a program to show the parser component used in teradata?
Explain fastload in teradata?
What is teradata and why it is used?
Different phases of multiload?
