How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?
- 2 Answers
- 14858 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 are the steps to create a data model?
What are the different softwares used with their functions in teradata?
What do you mean by ttu in teradata?
What is meant by a node?
what are the uses of fact table and dimension table in banking project?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the various indexes in teradata? Why are they preferred?
How to eliminate product joins in a teradata sql query?
What are different table types used in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain the term 'columns' related to relational database management system?
What is the opening step in basic teradata query script?
Explain the term 'foreign key' related to relational database management system?
What is meant by a Clique?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
