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
|