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