NCSA Input Format

Sukhjeet — Tue, 16 Jun 2009 18:03:36 GMT

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman";}

I need to write one query to parse NCSA log format. My Logs are like this

172.21.201.112 - - [08/Apr/2001:21:01:19 -0800] "GET /style.css HTTP/1.0" 200 3401

In examples I got the way to check the Values but it is meaningless to store them without the IP and time stamp details. I need to view all details like

ip date time uri-stem sc-status sc-bytes

I think we can use these fields only for such log format.

Please write down query for same.

Input Formats

NCSA Input Format