Alternative Way to Run PSTParserAFS - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
lifecycle
previous
Product Category
Software

Another way to run PSTParserAFS is to use the table_from_afs function:

SELECT * FROM table_from_afs (
  ON empty_table 
  Path ('input_path' [,...])
  [ Host ('afs_server_ip_address') ]
  [ Port ('afs_server_port_number') ]
  Input_Format (
    'com.asterdata.sqlmr.analytics.parser.PSTParserAFS.inputformat.PSTInputFormat',
    'columns colname [,...] STRINGS' [, 'exclude MessageFolder1 [,...] STRINGS'] )
  SerDe ('com.asterdata.sqlmr.analytics.parser.PSTParserAFS.serde.PSTSerDe',
    'field.delim=1', 'escape.delim=27')
  OutputColumns ('colname coltype' [, ...]]
);

In the Input_Format argument, you can specify the output column names and folders to exclude.

For more information about the table_from_afs function, see the Teradata Aster® Database User Guide for Aster Appliances 6.20.