search

sijocherian / google-bigquery

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

Message: "You have encountered a bug in the BigQuery CLI. Please file a bug report in our public issue tracker:" #235

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. Run query shown below

What is the expected output? What do you see instead?
It should create the new table, but instead get the eror

What version of the product are you using? On what operating system?
Windows 8.1

Please provide any additional information below.

C:\Users\Nick>bq query -destination_table=NickTest_ga_sessions.visit "select 
visitid from [34757969.ga_sessions_20150408] limit 10"
You have encountered a bug in the BigQuery CLI. Please file a bug report in 
ourpublic issue tracker:
https://code.google.com/p/google-bigquery/issues/list
Please include a brief description of the steps that led to this issue, as 
wellas the following information:

========================================
== Platform ==
  CPython:2.7.6:Windows-8-6.2.9200
== bq version ==
  2.0.22
== Command line ==
  ['C:\\Program Files\\Google\\Cloud SDK\\google-cloud-sdk\\platform/bq\\bq.py', '--credential_file', 'C:\\Users\\Nick\\AppData\\Roaming\\gcloud\\legacy_credentials\\6ateman@gmail.com\\singlestore.json', '--project', 'sanguine-air-732', 'query', '\x96destination_table=NickTest_ga_sessions.visit', 'select visitid from [34757969.ga_sessions_20150408] limit 10']
== UTC timestamp ==
  2015-04-10 11:02:48
== Error trace ==
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform/bq\bq.py", line 719, in RunSafely
    return_value = self.RunWithArgs(*args, **kwds)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform/bq\bq.py", line 1072, in RunWithArgs
    job = client.Query(query, **kwds)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 2077, in Query
    return self.ExecuteJob(request, **kwds)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1729, in ExecuteJob
    job_id=job_id)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1714, in RunJobSynchronously
    upload_file=upload_file, job_id=job_id)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1625, in StartJob
    projectId=project_id).execute()
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\bin\bootstrapping\..\..\lib\apiclient\discovery.py", line 688, in method
    actual_path_params, actual_query_params, body_value)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_
client.py", line 304, in request
    headers, path_params, query_params, body_value)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\bin\bootstrapping\..\
..\lib\apiclient\model.py", line 148, in request
    body_value = self.serialize(body_value)
  File "C:\Program Files\Google\Cloud SDK\google-cloud-sdk\bin\bootstrapping\..\
..\lib\apiclient\model.py", line 257, in serialize
    return json.dumps(body_value)
  File "C:\python27_x64\lib\json\__init__.py", line 243, in dumps
    return _default_encoder.encode(obj)
  File "C:\python27_x64\lib\json\encoder.py", line 207, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "C:\python27_x64\lib\json\encoder.py", line 270, in iterencode
    return _iterencode(o, 0)
========================================

Unexpected exception in query operation: 'utf8' codec can't decode byte 0x96 
inposition 0: invalid start byte

C:\Users\Nick>

Original issue reported on code.google.com by 6ate...@gmail.com on 10 Apr 2015 at 12:30