sijocherian / google-bigquery

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

Nested array loading issue #240

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Please run load command:
bq load --source_format=NEWLINE_DELIMITED_JSON mytest.testload 
impsFailure.json.gz bq_table_schema.json

2. Got error:
Waiting on bqjob_r2ecf292a19ffb54c_0000014cdc9e5bd5_1 ... (49s) Current status: 
DONE
BigQuery error in load operation: Error processing job 
'my-project-id:bqjob_r2ecf292a19ffb54c_0000014cdc9e5bd5_1': Unexpected. Please 
try again.

What is the expected output? What do you see instead?
Data should be loaded but got error instead:
Console job history showing:
Error Reason:internalError. Get more information about this error at 
Troubleshooting Errors: internalError.
Errors:
Unexpected. Please try again.

What version of the product are you using? On what operating system?
Using:
Google Cloud SDK 0.9.56

bq 2.0.18
bq-nix 2.0.18
compute 2015.04.14
core 2015.04.15
core-nix 2014.10.20
dns 2015.04.14
gcloud 2015.04.14
gcloud-extensions-linux-x86_64 0.14.1
gcutil 1.16.5
gcutil-nix 1.16.5
gsutil 4.11
gsutil-nix 4.6
sql 2015.04.09

Please provide any additional information below.
Error is related to nested array: 
user_info.products_tags[].value[].offer_identifiers[]
after removing it bq load works fine.

Original issue reported on code.google.com by arkadius...@rtbhouse.com on 21 Apr 2015 at 3:45

Attachments: