bq load -F doesn't recognize '\t' and other escape sequences as single characters

[GoogleCodeExporter]

Create a tab (\t) separated value file. I used the attached test.csv.

Try to load into a new table with the bq load -F switch:

$ bq load -F '\t' tests.test test.csv a,b,c
BigQuery error in load operation: Field delimiter must be a single character.

I don't receive the error however if I use comma delimiters and -F ','

I expect that '\t' will be treated as a single character. But it is not.

bigquery-2.0.2 on Ubuntu 11.10

Original issue reported on code.google.com by net.equ...@gmail.com on 12 Mar 2012 at 11:16

Attachments:

• test.csv

[GoogleCodeExporter]

Good point! It turns out that this gets turned into two characters before we 
get our hands on it; I've added a fix that should be pushed out with the next 
release (which will happen by some time Monday at the latest).

Original comment by craigcitro@google.com on 24 Mar 2012 at 12:06

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

One more note: literally inserting a tab between quotes already works fine. 
(Bash will let you do this if you hit ctrl-v first to say "insert something 
literally".)

Original comment by craigcitro@google.com on 24 Mar 2012 at 12:08

• Added labels: ****
• Removed labels: ****

[GoogleCodeExporter]

Fixed!

Original comment by craigcitro@google.com on 24 Mar 2012 at 10:58

• Changed state: Fixed
• Added labels: ****
• Removed labels: ****