Hi,
I have installed MongoDB 2.6.7 on my System (locally). I have created a data source in Knowage successfully and then I could use Aggregate function for creating data set without any problem. But at this time I want to run aggregate function on a MongoDB that is located on a remote server. The version of this MongoDB is 3.4. I have created a new data source for that successfully but I cannot run aggregate function on it in data set creation, while I can run this aggregate function on local MongoDB version 2.6 using Knowage.
When I use aggregate function (exactly the same code) locally on MongoDB 2.6.7 I can save the results in “var query” but in version 3.4 this leads to a syntax error (fig 1).
What is the problem with "var query"?
As an alternative solution I have used sbiDatasetfixedResult (in format like " sbiDatasetfixedResult= db.getCollection('connection_log').aggregate([...])" ), it returns such a result (fig 2). But this format in not useful for me. please let me know, If I use wrong format in applying sbiDatasetfixedResult.
I must say when I am working with mongodb 3.4 I can use "var query=db.<collection>.group()" for creating that data set but it wastes too many time for running (10 hour).
Please help me ASAP,
Thank you in Advance
