Mango database
-
Hello please i would ask you if you can help me there, thank you in advance
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
"city": "ACMAR",
"loc": [
-86.51557,
33.584132
],
"pop": 6055,
"state": "AL",
"_id": "35004"
}Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
"_id": {
"$oid": "5191f53b1b76a5666a8cbd64"
},
"status": 200,
"requrest_time": 504, // in milliseconds
"type": "stationboard",
"datetime": {
"$date": "2014-02-19T07:03:32.000Z"
}
}1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)
2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).
-
Hello please i would ask you if you can help me there, thank you in advance
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
"city": "ACMAR",
"loc": [
-86.51557,
33.584132
],
"pop": 6055,
"state": "AL",
"_id": "35004"
}Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
"_id": {
"$oid": "5191f53b1b76a5666a8cbd64"
},
"status": 200,
"requrest_time": 504, // in milliseconds
"type": "stationboard",
"datetime": {
"$date": "2014-02-19T07:03:32.000Z"
}
}1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)
2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).
-
Thank you for your advice but i need a bit help with code , can u please?
-
Hello please i would ask you if you can help me there, thank you in advance
if we have two dataset 1-First dataset contains population data of cities in the United States of America. Each record in the dataset has the following format:
{
"city": "ACMAR",
"loc": [
-86.51557,
33.584132
],
"pop": 6055,
"state": "AL",
"_id": "35004"
}Second dataset contains log data from a geo-locational service. Each record in the dataset has the following format:
{
"_id": {
"$oid": "5191f53b1b76a5666a8cbd64"
},
"status": 200,
"requrest_time": 504, // in milliseconds
"type": "stationboard",
"datetime": {
"$date": "2014-02-19T07:03:32.000Z"
}
}1-how we can Get all the states that have at least 2 cities with population > 1000000 (1M).and we need to Remember that city can be splitted into multiple records, and we should aggregate its population first. (zips dataset)
2- we need Find a day (date) with the largest number of HTTP 500 errors (status=500).
You can start by asking the question only once
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
