Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2014
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. pipeline = [{
  2. $match: {
  3. event: 'sample_event',
  4. }
  5. }, {
  6. $project: {
  7. _id: false,
  8. uuid: '$properties.distinct_id',
  9. time: '$properties.time'
  10. }
  11. }, {
  12. $group: {
  13. _id: {
  14. year: {
  15. $year: '$time'
  16. },
  17. month: {
  18. $month: '$time'
  19. },
  20. day: {
  21. $dayOfMonth: '$time'
  22. },
  23. uuid: '$uuid'
  24. }
  25. }
  26. }, {
  27. $group: {
  28. _id: {
  29. year: '$_id.year',
  30. month: '$_id.month',
  31. day: '$_id.day'
  32. },
  33. value: { $sum: 1 }
  34. }
  35. }, {
  36. $sort: {
  37. '_id.year': 1,
  38. '_id.month': 1,
  39. '_id.day': 1
  40. }
  41. }, {
  42. $project: {
  43. _id: {
  44. $concat: [
  45. { $substr: ['$_id.year', 0, 4] },
  46. '-',
  47. {
  48. $cond: [
  49. { $lte: [ '$_id.month', 9 ] },
  50. { $concat: [
  51. '0',
  52. { $substr: [ '$_id.month', 0, 2 ] }
  53. ]},
  54. { $substr: [ '$_id.month', 0, 2 ] }
  55. ]
  56. },
  57. '-',
  58. {
  59. $cond: [
  60. { $lte: [ '$_id.day', 9 ] },
  61. { $concat: [
  62. '0',
  63. { $substr: [ '$_id.day', 0, 2 ] }
  64. ]},
  65. { $substr: [ '$_id.day', 0, 2 ] }
  66. ]
  67. },
  68. ]
  69. },
  70. date: new Date('$_id.year', '$_id.month', '$_id.day'), // errorrrr
  71. value: 1
  72. }
  73. }, {
  74. $out: 'output_collection'
  75. }];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement