1.1 - 8.10 - ApacheLogParser Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
TargetColumn
Specify the name of the input column that contains the information to parse.
LogFormat
[Optional] String that specifies the format used to create 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:
"%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\""
ExcludeFiles
[Optional] Specify the types of files to exclude, by suffix. If an input row contains a file of an excluded type, the function does not create an output file row for that input row.
Default: '.png', '.xml', '.js'
SearchInfoFlag
[Optional] Specify whether to return search information. 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.
Default: 'false'