Supported functions
S/N | Function Name | Description | Comment |
---|---|---|---|
1 | HASHAMP | Finds the primary AMP corresponding to the hash bucket number specified in the expression and returns the AMP ID. If no hash bucket number is specified, HASHAMP returns one less than the maximum number of AMPs in the system. |
|
2 | HASHBAKAMP | Finds the fallback AMP corresponding to the hash bucket number specified in the expression and returns the AMP ID. If no hash bucket is specified, HASHBAKAMP returns one less than the maximum number of fallback AMPs in the system. |
|
3 | HASHBUCKET | Returns the hash bucket number that corresponds to a specified row hash value. If no row hash value is specified, HASHBUCKET returns the highest hash bucket number. |
|
4 | HASHROW | Returns the hexadecimal row hash value for an expression or sequence of expressions. If no expression is specified, HASHROW returns the maximum hash code value. |
User can execute this either by passing expression or without any expression. |