Закрыт

Solve mongo query error

Hello i have a mongo db

db name: Quicklook_db

Collection name: quicklook_analyticsDesign

Total Documents in collection: 2,00,000 +

Sample json attached.

From all the documents i want to find the most used 10 values in this attribute: $[login to view URL]

I tried this code:

$analytics = DB::connection('mongodb')->collection($this->designViewed)->raw(function($views) use ($dateto, $datefrom) {

return $views->aggregate(array(

array('$group' => array('_id' => ['store_id' => '$[login to view URL]'],

'total' => array('$push' => '$[login to view URL]'))),

), ['allowDiskUse' => true]);

});

//suspect

$analytics_arr = [];

foreach ($analytics as $a) {

$analytics_arr[$a->_id->store_id] = get_tiles_from_plane_union($a->total);

unset($a);

}

$new_analytics_arr = [];

foreach ($analytics_arr as $key => $pch) {

if (empty($new_analytics_arr[$entities_arr[$key]['name']])) {

$new_analytics_arr[$entities_arr[$key]['name']] = $pch;

} else {

$new_analytics_arr[$entities_arr[$key]['name']] = custom_array_merge($new_analytics_arr[$entities_arr[$key]['name']], $pch);

}

}

$analytics_arr = $new_analytics_arr;

dd($analytics_arr);

But gives document size error 14 MB exceeded.

Квалификация: NoSQL Couch & Mongo, Elasticsearch, MySQL, Amazon Web Services, MongoDB

Показать больше phplist users database error 1064 query error, database query error dolphin, database query error dolphion, oscommerce fatal error loginphp call undefined function tep_get_languages, phplist database error 1064 query error sql syntax, joomla query error checkt, fix mysql query error, joomla sql query error join, database error query error sql syntax check manual corresponds mysql server version syntax, database error query error sql syntax check manual corresponds mysql server version syntax allnow, database error query error sql syntax check manual corresponds mysql server version syntax phplist_user_user line phplist, database error query error storage engine

О работодателе:
( 25 отзыв(-а, -ов) ) Bathinda, India

ID проекта: #23457564

8 фрилансеров(-а) в среднем готовы выполнить эту работу за ₹6775

paulprabhakarand

Hi Gentleman, This is Paul Devanesan has done [login to view URL] and [login to view URL] from IIT Madras. I am a technology expert, more than a decade I am developing and delivering applications on Java based technologies. I am a certified Ja Больше

₹10000 INR за 5 дней(-я)
(19 отзывов(-а))
5.0
TomaITomov

Greetings! I am placing the current avarage price now and we can discuss it later. I am available to start work immediately and will be glad to discuss further details via chat if you still search for someone. Have ove Больше

₹7311 INR за 7 дней(-я)
(11 отзывов(-а))
4.8
Gadziev

Hello, **How are you today?** I 'm an expert of web development in Russia. I have enough experience for web development such as node js, code igniter, laravel, angular, react js and etc. I have just check your descript Больше

₹7000 INR за 7 дней(-я)
(3 отзывов(-а))
4.1
hsh564cf84accd96

I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in programming and development I Больше

₹7000 INR за 7 дней(-я)
(8 отзывов(-а))
3.4
lonxu2017

Hi, there. I have read your proposal. I have good experience with MongoDB. Please contact me. Regards.

₹7000 INR за 1 день
(1 отзыв)
2.1
kannan1392

Hello, Am a java developer with 15 years of experience having good knowledge in mongo. Kindly let me know if u r interested

₹5555 INR за 2 дней(-я)
(0 отзывов(-а))
0.0
bbalaganapathy

Hi, I have more than 14 years in Java JEE and 4 years of experience in Mongo db. I have implemented complex mongo queries , used GridFs to solve 16mb document limitation etc. Please contact me if you are interested to Больше

₹3333 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
jamsheedpk

Ready to do some Free Sample work for Earning some reviews I have been working on MEAN stack projects for quite long . Was senior developer and TEAM LEAD in our Company . Very New to the Platform , and eager to get Больше

₹7000 INR за 4 дней(-я)
(0 отзывов(-а))
0.0