CODEWITHSUNDEEP
google-bigquery
Adamo Tonete
Adamo Tonete

Reputation: 106

Export table to other table don't map REPEATED fields rightly

I'm trying to export my table to other table before change their schema. But, if i create a new empty table with the same schema when i try to export using web interface shows the message who my repeated fields weren't found. If i try export to a new table with no schema it has mapped to a new table (tool reports success) and the repeated fields were not mapped.

Upvotes: 1

Views: 257

Answers (3)

Felipe Hoffa
Felipe Hoffa

Reputation: 59165

BigQuery used to enforce flattening of results, but not anymore. See https://stackoverflow.com/a/25193966/132438

Upvotes: 0

shollyman
shollyman

Reputation: 4384

Update since this question was originally asked: BigQuery now exposes a flattenResults boolean option when specifying a query configuration:

configuration.query.flattenResults (boolean)

[Experimental] Flattens all nested and repeated fields in the query results. The default value is true. allowLargeResults must be true if this is set to false.

This is also exposed in the web UI under the "show options" button for your query.

Upvotes: 2

Jordan Tigani
Jordan Tigani

Reputation: 26617

I'm not sure what you're trying to do, but it sounds like you could run a copy job, which would preserve the schema.

Upvotes: 1

Related Questions