Hy,
I'm having an issue with Drill file format.
I have a CSV file that has space delimiter (apache2 web server logs) and
double quotes for text area.
So I have configured my csv file format like this:
"csv": {
"type": "text",
"extensions": [
"csv"
],
"escape": "\\",
"comment": "\u0000",
"delimiter": " "
}
and it doesn't work well.
A line look like this:
XXX.XXX.XXX.XXX 200 "GET / ... etc" "USER AGENT"
Instead of giving me (4 columns):
["XXX.XXX.XXX.XXX", "200", "GET / ... etc", "USER AGENT"]
I'm having this response (3columns):
["XXX.XXX.XXX.XXX", "200", "GET / ... etc\" \"USER AGENT\""]
But if I edit the file with comma delimiter a the configuration, it's
working fine.
Is there a problem within the code for space delimiter?
Thanks
Mathieu Agneray
