ApacheLogParser Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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'