There are some attributes that were introduced in Drill 1.0 that are partly documented (sorry no example):
- http://drill.apache.org/docs/plugin-configuration-basics/#list-of-attributes-and-definitions (see "formats" . . . "quote") - http://drill.apache.org/docs/plugin-configuration-basics/#using-the-formats Kristine Hahn Sr. Technical Writer 415-497-8107 @krishahn 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 >