runt18 / google-bigquery

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

Loading csv file to bigquery failed #492

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. convert Logfile To csv file
2. upload csv file by load command

What is the expected output? What do you see instead?
What version of the product are you using? On what operating system?
Please provide any additional information below.

plead see below

Error 502, retry #1
You have encountered a bug in the BigQuery CLI. Please file a bug report in our
public 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 well
as the following information:

========================================
== Platform ==
  CPython:2.7.10:Windows-8-6.2.9200
== bq version ==
  2.0.22
== Command line ==
  ['C:\\Program Files (x86)\\Google\\Cloud SDK\\google-cloud-sdk\\platform/bq\\bq.py', '--credential_file', 'C:\\Users\\s2861\\AppData\\Roaming\\gcloud\\legacy_credentials\\t.taniguchi@intage.co.jp\\singlestore.json', '--project', 'itsp-tani-test', 'load', 'UseOfiCanvas.IISlogTaniTest', 'D:\\tool\\IISLogImport\\temp\\IISlog_20160406033518683815.csv']
== UTC timestamp ==
  2016-04-05 18:44:56
== Error trace ==
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform/bq\bq.py", line 769, in RunSafely
    return_value = self.RunWithArgs(*args, **kwds)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform/bq\bq.py", line 1011, in RunWithArgs
    job = client.Load(table_reference, source, schema=schema, **opts)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 2362, in Load
    upload_file=upload_file, **kwds)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1881, in ExecuteJob
    job_id=job_id)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1866, in RunJobSynchronously
    upload_file=upload_file, job_id=job_id)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1765, in StartJob
    result = BigqueryClient._ExecuteInChunksWithProgress(request)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform\bq\bigquery_client.py", line 1691, in _ExecuteInChunksWithProgress
    status, result = request.next_chunk()
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform/bq\third_party\oauth2client\util.py", line 137, in positional_wrapper
    return wrapped(*args, **kwargs)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform/bq\third_party\apiclient\http.py", line 820, in next_chunk
    status, body = self._process_response(resp, content)
  File "C:\Program Files (x86)\Google\Cloud SDK\google-cloud-sdk\platform/bq\third_party\apiclient\http.py", line 897, in _process_response
    self.resumable_progress = int(resp['range'].split('-')[1]) + 1
========================================

Unexpected exception in load operation: 'range'

Original issue reported on code.google.com by takatoyo...@gmail.com on 6 Apr 2016 at 12:03

GoogleCodeExporter commented 8 years ago
I've filed an internal bug for investigation. How often do you see such errors 
with your media uploads?

Original comment by wes...@google.com on 13 Apr 2016 at 4:13