access_time 8 months ago languageEnglish
more_vert

Find out Teradata AMP Count

visibility 32 comment 0

Teradata AMPs are the parallel distributed storage and computing unit in a Teradata server. We can use HASHAMP function to calculate the total AMP count in a Teradata system.

HASHAMP function

HASHAMP function returns the identification number of the primary AMP corresponding to the specified hash bucket number. If no hash bucket number is specified, HASHAMP returns one less than the maximum number of AMPs in the system.

Code snippet

SELECT HASHAMP()+1 AS "AMP Count"
copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 548
thumb_up 1
access_time 2 years ago
visibility 1038
thumb_up 0
access_time 2 years ago
visibility 195
thumb_up 0
access_time 11 months ago