Example

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand: Software; Teradata Vantage
prodname: Teradata Database; Teradata Vantage NewSQL Engine
vrm_release: 16.20
category: Programming Reference
featnum: B035-1145-162K

If you call HASHBUCKET without an argument, it returns the maximum hash bucket.

   SELECT HASHBUCKET();