Querying Massive Datasets using Google BigQuery

Ryan Boyd and Michael Manoochehri show you how to query some massive datasets using Google BigQuery.

[abhineetsrivastava]

Hi, all the examples read data from a single big query, is there any reference to working with multiple big tables where joins are required

[markdamjan]

Mike, Your "Chubby Baby" query outlined MD having the highest amount of "Chubby Baby" births for 1990. Since having a "Chubby Baby" is considered a high risk pregnancy, MD has several institutions for providing services to mitigate this risk. Both John Hopkins and U of MD Medical Center provide premiere prenatal & maternal services for dealing with high risk pregnancies, such as having a "Chubby Baby". Many people in the mid-Atlantic area with high risk pregnancies visit these institutions for their unique prenatal & maternal services. This may explain MD's contribution to the query result....

Mark

[simonmasters]

New Technology: Collaborative BigQueryProgramming
19:56 "This type of bounding query is adequate" 
Can I suggest a 3-D "skin" (5km thick) might be a better geometric approximation? 
I am also tempted to suggest a user-defined function is needed:
         Biosphere(CenterOn(GeoPos(Lat, Long, Altitude)), nDistance, cUnitType)
        e.g. Biosphere(GetGeoPos("Denver, CO"), 50, "km")
But you SHOULD surely use EXACTLY the same geopos code used by Google Earth...that way as GE terrain mapping improves we get self-improving geopositioning
and smooth integration...precision suitable for engineers

[simonmasters]

"So we invented a new technology...using some best practice methods such as hadoop..."  So casual, but hey it works for me! Like +hdzsound, I am aggregating your badass mama wiki data.  Astouding guys (applause)! Link to QueryCookbook?