Example 4: Path and Exclude Arguments with Regular Expressions - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

This SQL-MapReduce call parses all PST files in /test/ subdirectories test1 through test9, excluding those in subdirectory Sent Items/2012/:

SELECT * FROM PSTParserAFS (
  ON empty_table
  Path ('/test[1-9]/[a-z]*')
  Exclude ('Sent I[a-z]*/2012/[a-z]')
);