google cloud platform - BigQuery GUI only showing 1 space when the data actually contains multiple spaces -


during processing of google analytics premium data, applying regex data in dataflow, ran following issue:

applying regex: .*xxx yyy.* field containing string: xxx yyy in bigquery gui, didn't return true, while should have.

i double checked dataflow code , bigquery data, wasn't able find issue right away.

the issue related how data represented in bigquery gui. when running exact same query using bigquery command line tool (bq query), results showed actual data stored not xxx yyy xxx yyy (containing 2 instead of 1 space), might useful double check data there when running similar issue.

after doing digging found this issue on google issue tracker. can stay date on status of starring it.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -