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

How do you do backup and recovery in teradata?

960

Explain the meaning of Amp?

1034

what are the uses of fact table and dimension table in banking project?

4491

Difference between stored procedure and macro?

1109

In general, how do you optimze any sql in teradata?

973

What is meant by a node?

991

How many codd's rules are satisfied by teradata database?

1044

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1130

What are the functions involved in shared information architecture?

1016

What are the functions of a Parser?

1027

What are types of partition primary index (ppi) in teradata?

998

What is meant by a Least Cost Plan?

1002

Highlight the advantages of PPI(Partition Primary Index).

1004

Is multi insert ansi standard?

2144

What is a node in teradata?

935