Find out Teradata AMP Count

access_time 21 days ago visibility8 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 or Twitter.

Want to publish your article on Kontext?

Learn more

More from Kontext

visibility 8
thumb_up 0
access_time 21 days ago

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 ...

visibility 6069
thumb_up 0
access_time 2 years ago

In my article Connect to Teradata database through Python , I demonstrated about how to use Teradata python package or Teradata ODBC driver to connect to Teradata. In this article, I’m going to show you how to connect to Teradata through JDBC drivers so that you can load data directly into PySpark ...

visibility 97
thumb_up 0
access_time 5 months ago

Teradata RPAD function is used to add repeated characters at the end of a string to increase the string to a specified length. It can be used to add trailing space or zeros to a string. RPAD(source_string, length, fill_string) Returns the source_string padded to the right with the characters in ...