curl -vL 'https://d.aww.com.au/i?foo=bar' 2>&1 >/dev/null |less
> GET /i?foo=bar HTTP/1.1< Location: /i?redir=1&foo=bar< P3P: policyref="/w3c/p3p.xml", CP="NOI DSP COR NID PSA OUR IND COM NAV STA"< Set-Cookie: sc=9a6253b1-1e84-4ff7-b78f-a1c83e7e8e35; expires=Fri, 18 Sep 2015 05:45:56 GMT;> GET /i?redir=1&foo=bar HTTP/1.1< Location: https://d1a13ixaual31f.cloudfront.net/i?foo=bar< P3P: policyref="/w3c/p3p.xml", CP="NOI DSP COR NID PSA OUR IND COM NAV STA"< Set-Cookie: sc=be804cca-c56e-4eef-95f4-06e0f007c95a; expires=Fri, 18 Sep 2015 05:47:32 GMT;
--
You received this message because you are subscribed to the Google Groups "Snowplow" group.
To unsubscribe from this group and stop receiving emails from it, send an email to snowplow-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
We're working with this query (probably could be done much better):
SELECT *
FROM events
WHERE collector_tstamp::DATE|| page_urlhost || network_userid IN (SELECT collector_tstamp::DATE|| page_urlhost || network_userid
FROM events
WHERE network_userid IS NOT NULL
AND collector_tstamp::DATE> '2014-08-01'
GROUP BY collector_tstamp::DATE,
page_urlhost,
network_userid
HAVING COUNT(DISTINCT domain_userid) > 1 LIMIT 200)
ORDER BY network_userid,
page_urlhost,
collector_tstamp::DATE
Very strange, also interested to hear if anyone else has insight on this.
--
You received this message because you are subscribed to the Google Groups "Snowplow" group.
To unsubscribe from this group and stop receiving emails from it, send an email to snowplow-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.