7.00.02 - Output - 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 output has 11 columns. One row is output for each input row. There is no output corresponding to input id=4, because .js pages are omitted by default. This can be controlled by the ExcludeFiles argument (see Apache_Log_Parser Arguments). Also, the first row in the output, which corresponds to input id=5, is empty in the search_engine and search_term columns. This is because the referrer for that input row, http://www.example.com/start.html, is not a search engine. The only supported search engines are Google, Bing, and Yahoo.

Apache_Log_Parser Example 1 Output Table (Columns 1-5)
remote_host remote_log_name remote_user request_time requested_page
127.0.0.1 - - 2000-10-10 13:55:36 /apache_pb.gif
69.236.77.51 - Frank 2011-03-26 09:17:31 /about/careers.php
168.187.7.114 - Lewis 2011-03-27 00:16:49 /
75.36.209.106 - Patrick 2008-05-20 15:43:57 /
Apache_Log_Parser Example 1 Output Table (Columns 6-8)
final_status bytes_sent_including_header referrer
200 2326 http://www.example.com/start.html
200 5976 http://www.bing.com/search?q=Aster+data&src=ie9tr
200 7203 http://search.yahoo.com/search;_ylt=AtMGk4Fg.FlhWyX_ro.u0VybvZx4?p=ASTER&toggle=1&cop=mss&ei=UTF-8&fr=yfp-t-383-1
200 15251 http://www.google.com/search?hl=en&q=%22Aster+Data+Systems%22
Apache_Log_Parser Example 1 Output Table (Columns 9-11)
search_engine search_terms request:User-Agent
    Mozilla/4.08 [en] (Win98; I ;Nav)
bing Aster data Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
yahoo ASTER Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2;.NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0;InfoPath.2)
google "Aster Data Systems" Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; YPC 3.2.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MS-RTC LM 8)