Filled https://issues.apache.org/jira/browse/DRILL-3393
On 26 June 2015 at 16:11, Jacques Nadeau <jacq...@apache.org> wrote: > 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 <chil...@gmail.com> 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 > > >