7.00.02 - Apache Log Parser Item-Name Mapping - 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)

The following table shows the mapping between request characteristics in the format string (log items) and table column names, and gives output examples.

Apache Log Parser Item-Name Mapping
Log Item Column Name Output Example
%h remote_host 153.65.52.112
%a remote_IP 153.65.52.112
%A local_IP 153.65.52.112
%t request_time [22/Jun/2012:17:27:02 -0700]
%b bytes_sent_CLF 512
%B bytes_sent 455
%O bytes_sent_including_header 512
%I bytes_received_including_header 512
%p canonical_server_port 80
%{canonical}p canonical_server_port 80
%{local}p actual_server_port 80
%{remote}p actual_client_port 7777
%P process_ID 8311
%k live_connections 2
%D request_duration_microseconds 312
%T request_duration_seconds 0
%U requested_URL /index.html
%l remote_log_name  
%u remote_user  
%f requested_file  
%{VARNAME}i request:VARNAME  
%{Referer}i Referer  
%{VARNAME}o reply:VARNAME  
%{VARNAME}n note:VARNAME  
%{VARNAME}e env:VARNAME  
%{VARNAME}C cookie:VARNAME  
%V server_name  
%v canonical_server_name  
%L log_ID  
%H protocol HTTP/1.1
%m method GET
%q query  
%X connection_status X = Connection aborted before the response completed.

+ = Connection may be kept alive after the response is sent.

- = Connection closes after the response is sent.

%r request_line  
%>s final_status 404
%<s original_request_status  
%s original_request_status  
%R handler