tdr.SetHashByDef Function | R Table Operators | Teradata Vantage - tdr.SetHashByDef - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

Sets the HASH BY specification for a specified input stream.

Syntax

tdr.SetHashByDef(  streamno,  hashbydef  )

Syntax Elements

streamno
Parameter type: integer

The input stream number.

hashbydef
Parameter type: list

A vector of column names.

Usage Notes

This function is valid only if called from the contract function.

The function must run on a PE-only node.

An error is raised in the following situations:
  • The function is called from the table operator.
  • The HASH BY metadata was already set.

Example: Set the HASH BY Specification for an Input Stream

The following statement sets the HASH BY metadata for input stream 0 with the specification that the columns in the HASH BY clause are col1 and col3.

hashbydef <- c("col1", "col3");
tdr.SetHashByDef( 0, hashbydef );