Re: Importing Tomcat Access Log

[Andrew Taylor]

Ok so I added a couple more columns, and used sed to remove all the "" from the files. Now my issue is it only loads 1 row. there are several thousand rows of data to be loaded. What would prevent this from working.

Below is the query I am using now.
load data infile '/tmp/sql/iweb2.txt'
into table StandardGolfIweb
fields terminated by ' '
lines terminated by '\r\n';

here is the data after using sed against it.
128.1.1.20 - - [03/Feb/2015:00:00:05 -0600] GET /isweb/servlet/PrintFilePollingServlet?id=248504470001111CC536F.ipf&version=2.01.01&pc=001111CC536F HTTP/1.1 200 45 - Java/1.7.0_40

128.1.1.243 - - [03/Feb/2015:00:00:05 -0600] GET /isweb/servlet/PrintFilePollingServlet?id=6967057597C0507ACC6EA.ipf&version=2.01.01&pc=7C0507ACC6EA HTTP/1.1 200 45 - Java/1.7.0_40