Example using Teradata Wallet in a Teradata Aster SQL-MapReduce® query - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

In this query, Teradata Wallet replaces $tdwallet(abc) with the corresponding password stored on the client Teradata Wallet.

select * from cfilter(
on (select 1)
partition by 1
database('beehive')
userid('beehive')
PASSWORD('$tdwallet(abc)')
inputtable('cfilter_test')
outputTable('cfilter_test1')
inputColumns('item')
joinColumns('tranid')
droptable('true'));