Answer the question
In order to leave comments, you need to log in
Unnest in several nesting levels - how to apply it correctly?
Can you tell me how to correctly apply unnest for two or more levels of nesting? I will explain with an example. There is the following scheme:
Название поля Тип Режим Описание
<b>WebsiteId </b>STRING NULLABLE
<b>Status </b>STRING NULLABLE
<b>StatusDate </b>DATETIME NULLABLE
<b>CreatedAt </b>DATETIME NULLABLE
<b>RegionID </b>INTEGER NULLABLE
<b>CouponNumber </b>STRING NULLABLE
<b>TotalPrice </b>FLOAT NULLABLE
<b>Items </b>RECORD REPEATED
<b>Items. SKU</b> STRING NULLABLE
<b>Items. Guid</b> STRING NULLABLE
<b>Items. Status </b>STRING NULLABLE
<b>Items. StatusDate</b> DATETIME NULLABLE
<b>Items. Price</b> FLOAT NULLABLE
<b>Items. DiscountInfo</b> RECORD NULLABLE
<b>Items.DiscountInfo. DiscountPercent</b> FLOAT NULLABLE
<b>Items.DiscountInfo. Code</b> STRING NULLABLE
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question