OrenBochman

BigQuery for Google Analytics

No metrics in

Self Joins

• Cross Join example
• Inner Join example

joins can be inefficent - they can require moving lots of data around and increase the data process from n to n * n

LasseRafn

...

location ~* \.(gif|jpg|jpeg|ico|png|svg)$ {
	# Do jack shit.
}


location / {
	try_files $uri $uri/ /index.php$is_args$args;
}

marcanuy

1.	my+	1001.	se+	2001.	thedaily+	3001.	empire+	4001.	herb+
2.	+online	1002.	test+	2002.	giant+	3002.	+cook	4002.	+teen
3.	the+	1003.	fish+	2003.	survey+	3003.	+deluxe	4003.	affordable+
4.	+web	1004.	hk+	2004.	+conference	3004.	+crunch	4004.	proto+
5.	+media	1005.	florida+	2005.	twit+	3005.	michigan+	4005.	+ity
6.	web+	1006.	fine+	2006.	pick+	3006.	cars+	4006.	myhome+
7.	+world	1007.	loan+	2007.	+dvd	3007.	+forest	4007.	plastic+
8.	+net	1008.	page+	2008.	cinema+	3008.	yacht+	4008.	+kc
9.	go+	1009.	fox+	2009.	desi+	3009.	+wallet	4009.	+foot
10.	+group	1010.	+gift	2010.	act+	3010.	+contest	4010.	+sup

bhurlow

–ctrl a c           -> cre­ate new win­dow
–ctrl a A           -> set win­dow name
–ctrl a w           -> show all win­dow
–ctrl a 1|2|3|…   -> switch to win­dow n
–ctrl a ”           -> choose win­dow
–ctrl a ctrl a      -> switch between win­dow
–ctrl a d           -> detach win­dow
–ctrl a ?           -> help
–ctrl a [           -> start copy, move cur­sor to the copy loca­tion, press ENTER, select the chars, press ENTER to copy the selected char­ac­ters to the buffer
–ctrl a ]           -> paste from buffer