It definitely seems like a bug given your example. Can you file a jira?
On Fri, Jun 26, 2015 at 7:27 AM, Chi-Lang Ngo <[email protected]> wrote: > Hi, > > I'm having problem querying tab-delimited (tsv) files which has quotes. > > Drill doesn't seem to recognise quotes in tsv while working fine for csv > files. > For example, given the following files > > test.tsv > ------- > foobar bar > "aa" "bc" > ------- > > test.csv > ---------- > foobar,bar > "aa","bc" > ---------- > > I get these results > > 0: jdbc:drill:zk=local> select columns[0], columns[1] from dfs.`/test.csv`; > > +---------+---------+ > > | EXPR$0 | EXPR$1 | > > +---------+---------+ > > | foobar | bar | > > | aa | bc | > > +---------+---------+ > > 2 rows selected (0.259 seconds) > > 0: jdbc:drill:zk=local> select columns[0], columns[1] from dfs.`/test.tsv`; > > +----------+---------+ > > | EXPR$0 | EXPR$1 | > > +----------+---------+ > > | foobar | bar | > > | aa" "bc | null | > > +----------+---------+ > > 2 rows selected (0.122 seconds) > > Any ideas? > CL >
