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
