× {{alert.msg}} Never ask again
Get notified about new tutorials RECEIVE NEW TUTORIALS

Google BigQuery asking for JOIN EACH but I'm already using it

Nov 18, 2015
<p>This can be combined to one single query:</p> <pre><code>SELECT device_uuid, session_uuid, nth, SUM(IF (name = 'App Launch', INTEGER([project_id].[table_id].attributes.Value), 0)) AS Diamonds_Launch, SUM(IF (name = 'App Close', INTEGER([project_id].[table_id].attributes.Value), 0)) AS Diamonds_Close, FROM [project_id].[table_id] WHERE attributes.Name = 'Inventory - Diamonds' GROUP BY device_uuid, session_uuid, nth </code></pre> <p>You also have to use GROUP EACH for large tables.</p> <p>This tip was originally posted on <a href="http://stackoverflow.com/questions/28704044/Google%20BigQuery%20asking%20for%20JOIN%20EACH%20but%20I'm%20already%20using%20it/28705046">Stack Overflow</a>.</p>
comments powered by Disqus