drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Omernik <j...@omernik.com>
Subject Select with OPTIONS on tsv data
Date Fri, 10 Jun 2016 18:12:50 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message