zipped csv files as input
Re: zipped csv files as input
Jun 24, 2008 11:36 AM|juergmaier|LINK
I can't howevr yet not figure out how it could help me. My files are zipped csv log files and it would be very handy to e.g. count the number of special events logged in the files.
The files have talking names so to analyze a certain month I could use:
SELECT count(*) from *200805*.zip WHERE Field1="011" group by SUBSTR(Filename,1,5)
I agree that I could first use a -i:FS run to get the list of files, run an unzipper with these files, then run log parser and thereafter clean up but - in this scenario - how much more efficient would it be to be able to specify -i:CSVZIP or some other
The ultimate solution would of course be that logparser recognizes zipped files automatically and unpacks them before processing?
As of my knowledge zip/unzip libraries are available but would need to be used from within logparser.