Hi John, bad news is a bug, good news is going to be fixed in Jira https://issues.apache.org/jira/browse/DRILL-3149, PR is already submitted.
Kind regards Arina On Fri, Jun 10, 2016 at 9:13 PM John Omernik <[email protected]> wrote: > I am trying to use select with options on tsv data, I can't figure out how > to pass a tab in for the fieldDelimiter... > > basically > I have > > select * from table(home.user.`myfile.tsv`(type => 'text', fieldDelimeter > => '\t', extractHeader => true)) > > > \t doesn't work and either does \\t > > Both give a Expected single character but was String: \t (or \\t) > > I can make it work in SQL Squirrel because I can put a real tab in there, > however in the command line (sqlline) it tries to auto complete. > > What are my options for using tab here? > > Thanks! > > John >
