Skip to content

Instantly share code, notes, and snippets.

@WillianFuks

WillianFuks/example_dataproc_simulated_query.sql

Last active October 31, 2017 15:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save WillianFuks/602207996f1b5aedff18ddc310dcb35d to your computer and use it in GitHub Desktop.
Save WillianFuks/602207996f1b5aedff18ddc310dcb35d to your computer and use it in GitHub Desktop.
Download ZIP
Simulated data used in unit testing
Raw
example_dataproc_simulated_query.sql
(
SELECT '1' AS fullvisitorid, ARRAY< STRUCT<ecommerceAction STRUCT<action_type STRING>, product ARRAY<STRUCT<productSKU STRING> > > > [STRUCT(STRUCT("2" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU), STRUCT("sku1" AS productSKU)] AS product), STRUCT(STRUCT("1" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU), STRUCT("sku1" AS productSKU)] AS product), STRUCT(STRUCT("3" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU)] AS product), STRUCT(STRUCT("6" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU)] AS product)] AS hits UNION ALL
SELECT '1' AS fullvisitorid, ARRAY< STRUCT<ecommerceAction STRUCT<action_type STRING>, product ARRAY<STRUCT<productSKU STRING> > > > [STRUCT(STRUCT("2" AS action_type) AS ecommerceAction, [STRUCT("sku3" AS productSKU)] AS product)] AS hits UNION ALL
SELECT '2' AS fullvisitorid, ARRAY< STRUCT<ecommerceAction STRUCT<action_type STRING>, product ARRAY<STRUCT<productSKU STRING> > > > [STRUCT(STRUCT("1" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU), STRUCT("sku1" AS productSKU)] AS product), STRUCT(STRUCT("0" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU), STRUCT("sku1" AS productSKU)] AS product), STRUCT(STRUCT("5" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU)] AS product), STRUCT(STRUCT("2" AS action_type) AS ecommerceAction, [STRUCT("sku0" AS productSKU)] AS product)] AS hits UNION ALL
SELECT '3' AS fullvisitorid, ARRAY< STRUCT<ecommerceAction STRUCT<action_type STRING>, product ARRAY<STRUCT<productSKU STRING> > > > [STRUCT(STRUCT("6" AS action_type) AS ecommerceAction, [STRUCT("sku0-55" AS productSKU), STRUCT("sku1-5T" AS productSKU)] AS product)] AS hits
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment