Friday, 15 April 2011

special character in bigquery command line command -



special character in bigquery command line command -

i have bigquery table has column values of '\n' (without quotes). want write query clause on field. command "select barcode [mydataset1.mytab1] barcode = '\n' , length(barcode) < 5"

the above command works on windows. above command returns records barcode \n. same command returns error on linux platform. think special character needs written differently. tried "select barcode [mydataset1.mytab1] barcode = '/\n' , length(barcode) < 5" , not work either. allow me know modify above query work on linux environment?

i have attached screenshots of working , not working screens. http://goo.gl/9p6cwd (windows works) http://goo.gl/deahij (linux gives error)

try using \\\. instance, query works:

$ bq query "select '\\\n';"

google-bigquery

No comments:

Post a Comment