1.1 - 8.10 - ApacheLogParser (ML Engine) - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Teradata Vantage
Release Number
Release Date
October 2019
Content Type
Programming Reference
Publication ID
English (United States)

The ApacheLogParser function parses Apache log file content from a given server access log and outputs specified columns of information, which can include search engines and search terms.

The function parses Apache log files with these constraints:
  • Log files are loaded into a table
  • One line of the Apache log file is loaded to one row in the table
  • If you specify a custom log format, the input must conform to that format.
  • If you do not specify a custom format string with the Log_Format syntax element, the function parses the logs with the NCSA extended/combined format, which is defined as:
      "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-agent}i\""