ApacheLogParser Example 2: Common logformat - Teradata Vantage

Input

• apache_logs, as in ApacheLogParser Example 1: Default Extended/Combined Log Format

SQL Call

The common log format excludes some columns from the default extended format.

SELECT * FROM ApacheLogParser (
  ON apache_logs
  USING
  TargetColumn ('logdata')
  LogFormat ('%h %l %u %t \"%r\" %>s %O')
  SearchInfoFlag ('true')
) AS dt ORDER BY remote_user;

Output

The Referer, User-Agent name, search engine and search terms are absent in the common log format output.