7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Aster Analytics
Release Number
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
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 - - 2000-10-10 13:55:36 /apache_pb.gif - Frank 2011-03-26 09:17:31 /about/careers.php - Lewis 2011-03-27 00:16:49 / - 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)