Is it possible to query a remote zip file? In looking at the API, it seems I have to specify that I am accessing a zipped file format and can only refer to a local zip file:
Implement your own Java class to fetch/download/stream the ZIP file, decompress it, (maybe even cache it locally?) and provide one line at a time to CsvJdbc.
See the MyHTTPReader example in csvjdbc.sourceforge.net/doc.html
There are so many ways of accessing remote files that I do not want to try to provide all possible variations directly in CsvJdbc.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi -
Is it possible to query a remote zip file? In looking at the API, it seems I have to specify that I am accessing a zipped file format and can only refer to a local zip file:
DriverManager.getConnection("jdbc:relique:csv:zip:" + zipFilename)
How can I access and query a remote zip file?
Thanks,
Brad
Implement your own Java class to fetch/download/stream the ZIP file, decompress it, (maybe even cache it locally?) and provide one line at a time to CsvJdbc.
See the MyHTTPReader example in csvjdbc.sourceforge.net/doc.html
There are so many ways of accessing remote files that I do not want to try to provide all possible variations directly in CsvJdbc.
Appreciate the feedback....after looking at the HTTPReader example I was figuring that was the way to go but I wanted to make sure.
Thanks for the prompt response.