<    June 2018     >
Su Mo Tu We Th Fr Sa  
                1  2  
 3  4  5  6  7  8  9  
10 11 12 13 14 15 16  
17 _1_8 19 20 21 22 23  
24 25 26 27 28 29 30
00:14 alexband joined
00:35 alexband joined
00:36 harry joined
00:54 jri joined
00:58 jri joined
01:09 macwinne_ joined
01:36 alexband joined
01:38 harry joined
01:52 chat joined
02:03 hotpot33 joined
02:09 maryo joined
02:38 chat_ joined
02:43 chat joined
02:44 tm joined
02:46 artok joined
02:53 chat_ joined
03:14 jri joined
03:56 harry joined
04:31 lqez joined
04:42 artok joined
05:10 ivokh joined
05:24 artok joined
06:40 lqez joined
06:43 <sujeet> is there any way to monitor the progress of an aggregation?
06:43 <sujeet> currentOp just says that its' running for this long
06:43 <sujeet> if there's an $out, i can look at how many docs are there
06:44 <sujeet> anything mroe useful than that?
06:50 ngui joined
06:56 jri joined
06:57 Mia joined
06:57 Mia joined
07:12 macwinne_ joined
07:28 Lujeni joined
07:33 sandstrom joined
07:35 jackdt joined
07:40 gfidente joined
07:56 rendar joined
08:01 jackdt joined
08:12 <Derick> I don't think so
08:14 sandstrom joined
08:21 lqez joined
08:35 jackdt joined
08:42 ShekharReddy joined
09:07 MACscr joined
09:11 jackdt joined
09:12 jackdt joined
09:24 jri joined
09:40 pentiumone133 joined
09:53 klics joined
10:04 artok joined
10:04 goldfish joined
10:05 rsrx joined
11:08 sQVe joined
11:08 gfidente joined
11:26 christophler joined
11:27 <christophler> hello #mongodb . What I really want is to have the mongo API interface over a filesystem type storage. Is there any such thing in the ecosystem?
11:27 <Derick> gridfs
11:27 <Derick> most drivers implement that API
11:28 <christophler> any chance I can store data in raw JSON rather than BSON format?
11:29 <Derick> you can store files in gridfs
11:29 <Derick> it doesn't care which datatype
11:29 <Derick> for normal data, why would you care how it is stored?
11:29 <christophler> must be abnormal! but what I actually want is to be able to track document changes with git. perhaps there is another way?
11:30 <Derick> use git as the database?
11:31 <christophler> I cant tell exactly what that means. Are you implying that I can do that, or asking if I want to?
11:31 <christophler> (thanks :) )
11:31 StephenLynx joined
11:31 <Derick> if you want to use git to keep track of changes, use git
11:31 <Derick> I don't see how MongoDB comes into play then
11:32 <christophler> because I want the mongodb API to manipulate the JSON documents on the disk
11:32 <christophler> and to load the data from the JSON documents into memory
11:32 <Derick> MongoDB does not store JSON documents...
11:32 <christophler> this i know
11:32 <Derick> it stores data
11:34 <christophler> thank you for your insight and information. I will go and do some more research :) :) xx
11:40 IonutVan_ joined
11:54 jri joined
11:56 workbean joined
12:06 jri joined
12:15 alexband joined
12:27 RickDeckard joined
12:33 HasanAtizaz joined
12:36 hasan_ joined
12:45 sterns joined
12:46 jri_ joined
13:06 harry joined
13:13 boughtly joined
13:18 rsrx__ joined
13:21 arthurmde_ joined
13:26 <boughtly> Hello. I am relatively new to MongoDB and I am wondering if I could get advice on a query strategy for a particular situation. Is this an appropriate place for that?
13:34 <Derick> yup
13:35 <boughtly> okay cool.
13:37 <boughtly> I have two collections. One is a primary collection where each document has two fields, an id and a group. thousands of documents have the same group so I am storing group properties in another collection so my documents don't become huge. The second collection has those properties, one of which is an array. I would like to query the first collection with a regular query ($match or find), then for each result look up the propertie
13:37 <boughtly> perform a $setIntersection to decide whether it should be included in the result
13:38 <boughtly> I've tried doing this with $project or $addFields and a second $match
13:38 <boughtly> but it gets very ugly very quickly. Is there a way to do this that I'm missing?
13:41 <Derick> Can you show: an example set of documents, and what you want as output? I can tell much easier with an example
13:41 <Derick> but, unless you use $lookup, you can't really use two collections in one A/F pipeline
13:42 <Derick> it also usually hints at a "Relational" database design
13:44 jackdt joined
13:48 <boughtly> Derick: here you go https://bpaste.net/show/03585a277936
13:48 <boughtly> I was using $lookup as well
13:50 <boughtly> I essentially want to run a simple regular query (lookup by an indexed field et cetera) but then do a sort of last filter by the intersection of those tags in the other collection before returning.
13:50 <Derick> so, a $match to match id:0, then a $lookup to tie the groups together, and then you can do a $match to do the intersection test (with $any, I suppose)
13:51 jackdt joined
13:52 jackdt joined
13:53 <boughtly> Derick: can I then remove the lookup field?
13:53 <Derick> sure, stick a $project at the end
13:54 <boughtly> Derick: maybe I'm not reading the docs right, but it seems $project would require me to list all the fields that I want. Is the only way to replicate every field name (there are lots of them) or can I keep all but remove 1?
13:55 <Derick> andyou can use { fieldName: 0 } to exclude that one
13:55 <boughtly> Derick: but then I have to do {fieldName: 1} for all the ones i have to keep? Can I keep by default and then only specify the 0?
13:56 <Derick> no
13:56 <Derick> just the fieldname: 0 will work, as long as you don't add a :1 one too
13:56 <boughtly> okay, cool. I will try it. Thank you
13:56 hasan_ left
13:57 HasanAtizaz joined
13:57 <HasanAtizaz> hi guys i have a problem wrt to bi connector. i am enbaled the mongo and bi authorization while authenticaating via tableau am having the below error in the log.
13:57 <HasanAtizaz> ] handshake error: ERROR 1759 (HY000): ssl is required when using cleartext authentication
13:57 <HasanAtizaz> have enabled*
14:01 philzz joined
14:01 tgburrin joined
14:08 jri joined
14:41 hasan_ joined
14:45 jri joined
15:04 philzz joined
15:12 RickDeckard joined
15:20 sgfgdf left
16:09 goldfish joined
16:12 macwinne_ joined
16:33 goldfish joined
16:45 yeitijem joined
16:56 Haxxa joined
16:59 artok joined
16:59 workbean joined
17:09 chat__ joined
17:31 jri joined
17:38 hal-j joined
17:44 Folkol joined
17:48 jri joined
18:04 tgburrin joined
18:09 Sasazuka joined
18:18 nelsnels_ joined
18:40 maryo joined
18:50 artok joined
19:51 jri joined
20:01 sandstrom joined
20:07 RickDeckard joined
20:23 tgburrin joined
20:25 RickDeck_ joined
20:43 Quick_Wango joined
20:55 jri joined
21:00 JonathanMcClare joined
21:02 annexseven joined
21:23 StephenLynx joined
21:28 Mia joined
21:28 Mia joined
21:54 harry joined
22:47 sftp joined
23:17 reie joined