from google.appengine.api import search listingLocation = search.GeoPoint(37.78, -122.39) listing = search.Document( fields=[ search.TextField(name='description', value='Great condo in the city'), search.NumberField(name='bedrooms', value=2), search.GeoField(name='location', value=listingLocation) # omitting the other fields for this example ])
put()
try: index = search.Index(name='listingsForSale') index.put(listing) except search.Error: logging.exception('Make sure you handle this error')
index = search.Index(name='listingsForSale') # search for listings within 8050 meters (~5 miles) of the 94109 zip code query_string = 'distance(location, geopoint(37.7929, -122.4212)) < 8050'
try: results = index.search(query_string) # Iterate over the documents in the results for scored_document in results: pass # handle results except search.Error: logging.exception('...and this one too')
JOIN
GROUP BY
body = {"rows":[ {"json": {"column_name":7.7,}} ]} response = bigquery.tabledata().insertAll( projectId=PROJECT_ID, datasetId=DATASET_ID, tableId=TABLE_ID, body=body).execute()
SUM()
COUNT()
AVG()
MIN()
MAX()
FIRST_VALUE
LAST_VALUE()
COVAR_POP()
COVAR_SAMP()
STDDEV_POP()
STDDEV_SAMP()
VAR_POP()
VAR_SAMP()
SELECT CORR(a.data, b.data) corr, a.room room, count(*) c FROM ( SELECT TIME(USEC_TO_TIMESTAMP(INTEGER(Timestamp / 60000000) * 60000000)) time, AVG(DATA) data, room FROM [io_sensor_data.moscone_io13] WHERE DATE(USEC_TO_TIMESTAMP(Timestamp- 8*60*60000000)) = '2013-05-16' AND sensortype='temperature' GROUP EACH BY time, room) a JOIN EACH ( SELECT TIME(USEC_TO_TIMESTAMP(INTEGER(Timestamp / 60000000) * 60000000)) time, AVG(data) data, room FROM [io_sensor_data.moscone_io13] WHERE DATE(USEC_TO_TIMESTAMP(Timestamp- 8*60*60000000)) = '2013-05-17' AND sensortype='temperature' GROUP EACH BY time, room) b ON a.time=b.time AND a.room = b.room GROUP EACH BY room HAVING corr IS NOT NULL AND c > 800 ORDER EACH BY corr DESC
SELECT CORR(a.data, b.data) corr, a.sensortype a_sensortype, b.sensortype b_sensortype, a.room room, count(*) c FROM ( SELECT TIME(USEC_TO_TIMESTAMP(INTEGER(Timestamp / 60000000) * 60000000)) time, AVG(DATA) data, room, sensortype FROM [io_sensor_data.moscone_io13] WHERE DATE(USEC_TO_TIMESTAMP(Timestamp- 8*60*60000000)) = '2013-05-16' AND sensortype != 'pressure' AND sensortype != 'altitude' AND room != 'None' GROUP EACH BY time, room, sensortype) a JOIN EACH ( SELECT TIME(USEC_TO_TIMESTAMP(INTEGER(Timestamp / 60000000) * 60000000)) time, AVG(data) data, room, sensortype FROM [io_sensor_data.moscone_io13] WHERE DATE(USEC_TO_TIMESTAMP(Timestamp- 8*60*60000000)) = '2013-05-16' AND sensortype != 'pressure' AND sensortype != 'altitude' AND room != 'None' GROUP EACH BY time, room, sensortype) b ON a.time=b.time AND a.room = b.room WHERE a.sensortype > b.sensortype GROUP EACH BY room, a_sensortype, b_sensortype HAVING corr IS NOT NULL AND c > 800 ORDER EACH BY corr DESC
Demonstrate your proficiency to design, build and manage solutions on Google Cloud Platform.
+(1).png)
.png)
.png)
.png)
.png)
Follow