JOIN or something similar

Elastic Stack Elasticsearch
1

Hi,

is it possible to do JOIN between two indexes in ES? (similar to new solr
4.0 feature)

my documents are composed from relatively static fields (Title,
Description, ..) and heavily dynamic fields (coordinates from GPS, custom
score)
i dont want to reindex full document every time user GPS location will
change, so ideally i will have another index with dynamic data and then
join them before serving results to the user

i know that there is partial update functionality in ES, but it is still
reindexing full document (so the impact on server resources is this same)

i dont exactly need JOIN functionality, any other solution will suffice, as
long as it solves my problem (without affecting performance)

thx,

--

2

Hello!

I don't think there is a non performance affecting solution, although I can
be mistaken - Solr join are also a bit slower than the non - join query.
But getting back to Elasticsearch - did you look at parent-child
functionality ? You could index you parent document and treat your dynamic
data as children documents and thus index them separately (although alway
in the same shard as the parent documents). However parent child queries
are a bit slower than the 'standard' ones.

--
Regards,
Rafał Kuć
Sematext :: http://sematext.com/ :: Solr - Lucene - Nutch - Elasticsearch

W dniu czwartek, 8 listopada 2012 13:19:27 UTC+1 użytkownik Karol Gwaj
napisał:

Hi,

is it possible to do JOIN between two indexes in ES? (similar to new solr
4.0 feature)

my documents are composed from relatively static fields (Title,
Description, ..) and heavily dynamic fields (coordinates from GPS, custom
score)
i dont want to reindex full document every time user GPS location will
change, so ideally i will have another index with dynamic data and then
join them before serving results to the user

i know that there is partial update functionality in ES, but it is still
reindexing full document (so the impact on server resources is this same)

i dont exactly need JOIN functionality, any other solution will suffice,
as long as it solves my problem (without affecting performance)

thx,

--

3

Perfect, thats exactly what i was looking for :slight_smile:

Thx,

On Thursday, November 8, 2012 12:19:27 PM UTC, Karol Gwaj wrote:

Hi,

is it possible to do JOIN between two indexes in ES? (similar to new solr
4.0 feature)

my documents are composed from relatively static fields (Title,
Description, ..) and heavily dynamic fields (coordinates from GPS, custom
score)
i dont want to reindex full document every time user GPS location will
change, so ideally i will have another index with dynamic data and then
join them before serving results to the user

i know that there is partial update functionality in ES, but it is still
reindexing full document (so the impact on server resources is this same)

i dont exactly need JOIN functionality, any other solution will suffice,
as long as it solves my problem (without affecting performance)

thx,

--

4

Still feel annoying when being disturbed cell phone calls? Don’t want this bad thing to happen again and again in your life and work? Ok, do not be anxious, the phone jamming device can be your first and best selection. And if you want to know more about this kind of device, you can gain the useful information you want.

5

The activity of the animal beings has become acutely active everywhere on this earth. Bodies do not get time to booty a blow for a while. With the accretion use of altered gadgets of Gps Jammer, the possibilities of accepting the aboriginal of blow accept absolutely finished. The adaptable phones or the corpuscle phones are some of these accessories that accumulate the bodies consistently in blow with the alfresco world. The adaptable building are additionally accessible about everywhere these canicule and due to this the accessibility of the Cell Phone Jammer has become alike added quick and authentic. Today, you cannot break out of ability of these adaptable building as their signals can bolt your about anywhere. The bearings of bodies who accord to altered business professions has become actual analytical of 868 mhz jammer as their authorities bolt them anywhere any moment.