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
