Description | ReQL Statement |
Query the outdated “Occupied“ tuple that temporarily resided in RethinkDB |
r.db(’spdb’). table(’raw_historical_table’). without(’id’, ’edge_arrivingTime’, ’fog_arrivingTime’). filter({“spot_id“: str(item[’spot_id’]), “event“: “Occupied“}). order_by(r.desc(’startTime’)).limit(1).run(conn) |