search

hayekw / google-bigquery-tools

Automatically exported from code.google.com/p/google-bigquery-tools
0 stars 0 forks source link

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

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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:

GoogleCodeExporter commented 9 years ago 
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

GoogleCodeExporter commented 9 years ago 
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

GoogleCodeExporter commented 9 years ago 
Fixed!

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