박사님께서 id 옆에 year 를 삭제하라고 하셔서 year 만 삭제해주고 년도만 나오게끔 해주었다
최종 쿼리 완성~~
Project Start date Group
db.Rawdata.aggregate( [ { $match: { "keyId" : 519 } } , { $project: { Startdate : {$dateFromString: { dateString: "$prdStart" }} , Enddate : {$dateFromString: { dateString: "$prdEnd" }} } } , { $group: {_id: {$year: "$Startdate" }, count: {$sum: 1} } }, {$sort: {_id:-1}}, ] )
Project End date Group
db.Rawdata.aggregate( [ { $match: { "keyId" : 519 } } , { $project: { Startdate : {$dateFromString: { dateString: "$prdStart" }} , Enddate : {$dateFromString: { dateString: "$prdEnd" }} } } , { $group: {_id: {$year: "$Enddate" }, count: {$sum: 1}, } }, {$sort: {_id:-1}}, ] )
https://docs.mongodb.com/v4.2/reference/operator/aggregation/group/
$group (aggregation) — MongoDB Manual
$group and Memory Restrictions The $group stage has a limit of 100 megabytes of RAM. By default, if the stage exceeds this limit, $group returns an error. To allow more space for stage processing, use the allowDiskUse option to enable aggregation pipeline
docs.mongodb.com
MongoDB Aggregate 매뉴얼 다 나와있는데 유용합니다
'2021-1 > Expert' 카테고리의 다른 글
| konlpy 설치 (0) | 2021.11.04 |
|---|---|
| LDA | Delete KoreanStopwords(Noun) & 영문타이틀 (0) | 2021.11.02 |
| MongoDB | Aggregate Group by (0) | 2021.11.01 |
| Jupyter notebook | 안열림 문제 해결 (0) | 2021.10.31 |
| LDA | 5개 키워드 추출 (0) | 2021.10.29 |
