7.00.02 - Apache_Log_Parser Arguments - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
TargetColumn
Specifies the name of the input column that contains the information to be parsed.
LogFormat
[Optional] String that specifies the format used to generate the server access logs, which you can find in the Apache server configuration file. For each log item in the format string, the function builds an output table column built from the input table columns. Default: NCSA extended/combined format, which is:
"%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\""
ExcludeFiles
[Optional] Specifies the types of files to exclude, by suffix. Default: '.png', '.xml', '.js'. If an input row contains a file of an excluded type, the function does not generate an output file row for that input row.
SearchInfoFlag
[Optional] Specifies whether to return search information. Default: 'false'. If you specify 'true', the function extracts the search engine and search terms (if they exist) into two output columns. The supported search engines are Google, Bing, and Yahoo. The function provides more complete parsing capabilities for Google.