Just copy/paste the csv bellow to tmp, 1,"foo\"","bar" 1,"foo","bar"
then tryied to query it: SELECT columns[0],columns[1],columns[2] FROM dfs.tmp.`test.csv`; Here is the result: EXPR$0 |EXPR$1 |EXPR$2 | -------|-----------------|-------| 1 |\"foo\","bar | | 1 |foo |bar | It does't parse the csv in the right way. Notice that : 1,"foo\" ","bar" 1,"foo","bar" Works ok (thanks to space). Then problem becomes : Drill don't anderstand CSV when a quote is the last character in a field Thanks ! 2016-02-04 23:07 GMT+01:00 Hanifi Gunes <[email protected]>: > Can you share error details as well? > > -Hanifi > > On Thu, Feb 4, 2016 at 2:05 PM, Nicolas Paris <[email protected]> wrote: > > > Hello, > > > > I have problem to load csv containg double double quote eg: > > col1;col2;col3 > > 1;"\"\"foo\"\"";"bar" > > 1;"\"\"foo\"\"";"bar" > > > > Thanks ! > > >
