Questions related to Aggregation functions in NoSQL databases.
Questions related to Aggregation functions such as Count() or Sum() in NoSQL databases.
Questions tagged [nosql-aggregation]
313 questions
0
votes
2 answers
Soccer and CouchDb (noob pining for sql and joins)
This has kept me awake until these wee hours.
I want a db to keep track of a soccer tournament.
Each match has two teams, home and away.
Each team can be the home or the away of many matches.
I've got one db, and two document types, "match"…
Barbara Jacob
- 286
- 4
- 11
0
votes
1 answer
Create hierarchy of values from SQL to MongoDB using Aggregation framework
I have a data transformation problem that I'm struggling with:
Assume I have a set of question and answer records from polls loaded into mongo of the form
ID PollTitle Creator Question Answer Respondent
I want to transform these into what I…
Roger Sanchez
- 311
- 1
- 4
- 13
0
votes
2 answers
Which NoSQL products support parallel query processing?
I'm going to use a NoSQL product(specially Cassandra or Hbase) for a warehouse application. I didn't found anything useful about which product support parallel query processing(on a single box and also cluster) for range queries. Can someone help?
Majid Azimi
- 5,575
- 13
- 64
- 113
-1
votes
1 answer
How to use MongoDB aggregation query to group documents by status and create ranges of id with each group?
How to use MongoDB aggregation query to obtain range of documents based on filtered status?
Consider the following example data:
[
{
"visible_id": 1,
"status": "INITIAL",
"name": "ab"
},
{
"visible_id": 2,
"status":…
T4puSD
- 102
- 10
-1
votes
3 answers
MongoDB Join Fields Aggregation
In MongoDB, I have a collection of different movies with their years.
Consider these documents:
{
"_id" : ObjectId("63a994974ac549c5ea982d2b"),
"title" : "Destroyer",
"year" : 1907
},
{
"_id" : ObjectId("63a994974ac549c5ea982d2a"),
…
DatBigD
- 129
- 7
-1
votes
1 answer
Mongoose find the difference between 2 dates
im trying to calculate the difference between endDate and startDate for every document in vacations collection to find How many vacation days does the employee have? :
const employee = await Employee.findOne({ nameAR: req.body.name });
const…
aasem shoshari
- 190
- 2
- 14
-1
votes
1 answer
List all documents from mongodb where the each document's one field has max value in spring boot
I have list of documents on mongodb like
Id, name, surname, salary.
I want all documents would return which contains max salary.
I know that i should aggregate the query in two step.
First of all, I should find max value of salar field for all…
Bago
- 17
- 7
-1
votes
1 answer
How to get only element in array - mongodb
Hello sorry i am new in with nosql and mongodb please kindly help me
here is my sample data
[
{
"_id": ObjectId("611532b19c6e77ad0fd50c1c"),
"status": true,
"role_name": "DEVELOPER",
"descr": "DEVELOPER",
"menu": [
{
…
Slack_ny
- 39
- 1
- 4
-1
votes
1 answer
How do I translate MongoDb query from SQL to NoSQL
How do I write this SQL command in NoSQL
SELECT regionname from Worldbank;
Rana Omer
- 13
- 2
-1
votes
2 answers
sum of daily activities over a month of July MongoDB aggregate
I need to get the sum of steps done per day in the month of July. I am expecting 31 results.
Here is a sample from the database:
/* 1 */
{
"_id" : ObjectId("5ff0a5878da39cdbf696ffea"),
"dateTime" : ISODate("2020-07-03T17:20:00.000Z"),
…
readymade
- 5
- 3
-1
votes
2 answers
Firebase mimicing WHERE IN
Given the date model provided below, after a user logs in and retrieves their data, they can also get a list of their friends.
However, in order to now attain details of those two friends by ids fdb17f3a-7b7d-4aa5-9a0b-b9fb33c349de and …
Sauron
- 6,399
- 14
- 71
- 136
-2
votes
1 answer
What is database aggregates in NoSQL?
What is meant by Derive database aggregates in NoSql databases.Please provide answers with some examples.
I need to know how to write database aggregates for some particular database
ABC
- 1
- 1
- 3
-2
votes
1 answer
convert SQL select query with 'IN' operator to elasticsearch search query
I want to convert the following SQL query to Elasticsearch search query. Can anyone help me with this, thanks.
Select sum(total_apples_count)
from basket where ( apple_color in (
select apple_color from apple_details where type = "O") ||
…
Murdoc230
- 1
- 2