BigQuery - saving query with complete non flat schema -


I am trying to run a filter on the existing table (say table A), and want to save the result to the destination The table (table) with the same schema.

The tableA has a complex schema, which has many nested hierarchies, I am using the "not adjusting the results" and "not allowing the big results" option on the following questions:

< Pre> select from the table where the property & gt; 100
  1. Is it possible to save a complex schema? Or will I be forced to flatten the result using the Flaton keyword (suppose that table has nested elements that are not nested in any other)?
  2. I get a clear error for this specific test: unexpected Please try again. Job ID: 507322187707: Job_r8hHPaz7Qiv7eMP89nbAsq46MzY

  1. Yes, you should be able to save this set of options With a table with an arbitrary complex schema.
  2. In order to calculate the size of your results, we are hitting the limitations in some of its supporting functions, due to the size of the resulting schema, I have internally filed a bug and further investigation Will do

Comments

Popular posts from this blog

java - Can't add JTree to JPanel of a JInternalFrame -

javascript - data.match(var) not working it seems -

javascript - How can I pause a jQuery .each() loop, while waiting for user input? -