Closed

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.

Skills: NoSQL Couch & Mongo, Elasticsearch, MySQL, Amazon Web Services, MongoDB

See more: 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

About the Employer:
( 26 reviews ) Bathinda, India

Project ID: #23457564

7 freelancers are bidding on average ₹6743 for this job

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 More

₹7000 INR in 7 days
(9 Reviews)
4.9
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 More

₹10000 INR in 5 days
(19 Reviews)
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 More

₹7311 INR in 7 days
(13 Reviews)
5.0
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 More

₹7000 INR in 7 days
(8 Reviews)
3.4
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 in 2 days
(0 Reviews)
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 More

₹3333 INR in 7 days
(0 Reviews)
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 More

₹7000 INR in 4 days
(0 Reviews)
0.0