orfeon

`SELECT * EXCEPT(field), field` 構文を使えば簡単にフィールドを一部だけ切り出すことができる。 STRUCT生成は`SELECT AS STRUCT *`という構文で作ることができる。 そこで(やや強引に)フィールドからサブクエリを作って以下のようにSTRUCT生成関数で置き換えを行うことができる。 ``` SELECT * except(record), ( SELECT AS STRUCT * EXCEPT(f100), f100 + 1 AS f100 FROM UNNEST([record])) AS record FROM...

20 cases per second is certainly slow. In my case, I insert 1 million records in about 10 minutes (total Dataflow job). Do you know where the bottleneck is in...

Thank you for using our service and for the report! I tried verifying under the same conditions, but I couldn't quite reproduce the issue in my environment... If possible, could...