Sel HASHAMP(HASHBUCKET(HASHROW(PRIMARY_INDEX_COLUMNS))) AS AMP

How to find No. of Records present in Each AMP or a Node
for a given Table through SQL?

Question Posted / n

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

Please Help Members By Posting Answers For Below Questions

What are the available primary index types?

1223

Explain teradata utilities. What is multiload, fast load, tpump?

1012

What is a three-tier data warehouse?

1120

What are the enhanced features in teradata v2r5 and v2r6?

1138

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

During the Display time, how is the sequence generated by Teradata?

1064

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1957

List out some of the primary characteristics of teradata.

1016

In Teradata, how do we Generate Sequence?

1051

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1156

What do you mean by caching in teradata?

1066

What are the things to be considered while creating secondary index?

1101

How do you do backup and recovery in teradata?

1026

Highlight the limitations of TPUMP Utility.

1116

Describe primary index in teradata?

1003