{"action":"created","issue":{"url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/482","labels_url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/482/labels{/name}","comments_url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/482/comments","events_url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/482/events","html_url":"https://github.com/richardwilly98/elasticsearch-river-mongodb/issues/482","id":60643679,"number":482,"title":"Help on \"relationships\" management","user":{"login":"pierpaolocira","id":11422667,"avatar_url":"https://avatars.githubusercontent.com/u/11422667?v=3","gravatar_id":"","url":"https://api.github.com/users/pierpaolocira","html_url":"https://github.com/pierpaolocira","followers_url":"https://api.github.com/users/pierpaolocira/followers","following_url":"https://api.github.com/users/pierpaolocira/following{/other_user}","gists_url":"https://api.github.com/users/pierpaolocira/gists{/gist_id}","starred_url":"https://api.github.com/users/pierpaolocira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pierpaolocira/subscriptions","organizations_url":"https://api.github.com/users/pierpaolocira/orgs","repos_url":"https://api.github.com/users/pierpaolocira/repos","events_url":"https://api.github.com/users/pierpaolocira/events{/privacy}","received_events_url":"https://api.github.com/users/pierpaolocira/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-03-11T11:19:24Z","updated_at":"2015-03-11T12:49:52Z","closed_at":null,"body":"Hi,\r\nI can't figure how to manage \"relationships\" from MongoDB in River... I'm sorry: I've been searching for any kind of documentation without success.\r\n\r\nMy situation is very common: I need to index in ES two MongoDB collections (documents in the first collection have native MongoDB DBRef to documents of the other... in a \"1-N\" modeling like fashion).\r\nUsing \"default\" mapping my DBRefs are treated as standard inner objects (like in MongoDB) so I have to \"join\" data by application business logic.\r\n\r\nInstead, I would like to evaluate River/ES performances both by denormalization or by nested objects in ES.\r\n\r\nI read that I have to use scripts for denormalization (to get data from the second collection), but I wasn't able to find any information about. I have to get related data directly by MongoDB? Or they should be in ES already? And, in which way? Or, better, River provide a way to automatically perform this task?\r\n\r\nThe same, I wasn't able to undestrand how to manage the problem by nested object way...\r\n\r\nAnd... what's the River behaviour in a MongoDB document changes and it is in ES as inner/denormalized?\r\n\r\nSo my question is: can you make available to users some examples about this operations?\r\n\r\nSorry, I wasn't able to find any kind of documentation about.\r\n\r\nThanks"},"comment":{"url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/comments/78256483","html_url":"https://github.com/richardwilly98/elasticsearch-river-mongodb/issues/482#issuecomment-78256483","issue_url":"https://api.github.com/repos/richardwilly98/elasticsearch-river-mongodb/issues/482","id":78256483,"user":{"login":"richardwilly98","id":118560,"avatar_url":"https://avatars.githubusercontent.com/u/118560?v=3","gravatar_id":"","url":"https://api.github.com/users/richardwilly98","html_url":"https://github.com/richardwilly98","followers_url":"https://api.github.com/users/richardwilly98/followers","following_url":"https://api.github.com/users/richardwilly98/following{/other_user}","gists_url":"https://api.github.com/users/richardwilly98/gists{/gist_id}","starred_url":"https://api.github.com/users/richardwilly98/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/richardwilly98/subscriptions","organizations_url":"https://api.github.com/users/richardwilly98/orgs","repos_url":"https://api.github.com/users/richardwilly98/repos","events_url":"https://api.github.com/users/richardwilly98/events{/privacy}","received_events_url":"https://api.github.com/users/richardwilly98/received_events","type":"User","site_admin":false},"created_at":"2015-03-11T12:49:52Z","updated_at":"2015-03-11T12:49:52Z","body":"Do you look at the unit test?\r\n\r\nI did a quick search in the repo:\r\n\r\nhttps://github.com/richardwilly98/elasticsearch-river-mongodb/search?q=DBRef&type=Code&utf8=%E2%9C%93\r\n"}}