DB Mango
-
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).
Ah MongoDB is one of these new fangled document databases and does not use SQL, I can only suggest you get into the documentation. Most of us use traditional relational database and can help with SQL queries.
Never underestimate the power of human stupidity RAH
-
Ah MongoDB is one of these new fangled document databases and does not use SQL, I can only suggest you get into the documentation. Most of us use traditional relational database and can help with SQL queries.
Never underestimate the power of human stupidity RAH
Mycroft Holmes wrote:
I can only suggest you get into the documentation
Or the school books. :rolleyes:
Wrong is evil and must be defeated. - Jeff Ello[^]
-
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).
A Quick Google shows me this one as the top reference SQL Comparison for Mango DB[^]
Every day, thousands of innocent plants are killed by vegetarians. Help end the violence EAT BACON