Adding mutliple types to an index


(jsp) #1

Hi,
I have recently started playing with ES for a site search project. My
search query runs against multiple tables across two databases, masterDb &
clientDb. So my plan is to create two indexes one for each database and
then add multiple types to each index.
And then finally query across those indexes for result.

Can anyone comment is this approach correct? And secondly how can i query
across indexes & types that I have created to get my results back? Any link
to a tutorial would be great
thanks
j

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/be076eb2-7886-4d92-832e-a026260effc8%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(Karol Gwaj) #2

here is tutorial about multi index/type search:
http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/search-search.html#search-multi-index-type

as to how to organize your data, it is really hard to say
it all depends of the size of your databases and the type of documents you
want to index, from the top of my head:

  • if your documents are hierarchically related (parent-child) then they
    have to go to this same index
  • if you run your queries only against subset of tables (different query
    different subset), then consider grouping them into different indexes (or
    use routing)
  • if you run your query always against all tables, then you can even put
    everything in one index with many shards (as there is really no much
    difference between running query on one index with multiple shards and
    running query on multiple indexes)

check this articles as starting point to learn more:



http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/index-modules-allocation.html
http://exploringelasticsearch.com/book/under-the-hood/clustering-and-index-internals.html

Cheers,

On Friday, December 27, 2013 10:22:04 PM UTC, jsp wrote:

Hi,
I have recently started playing with ES for a site search project. My
search query runs against multiple tables across two databases, masterDb &
clientDb. So my plan is to create two indexes one for each database and
then add multiple types to each index.
And then finally query across those indexes for result.

Can anyone comment is this approach correct? And secondly how can i query
across indexes & types that I have created to get my results back? Any link
to a tutorial would be great
thanks
j

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/bb2ac8e0-bcdc-4754-9eed-1fb422932ba7%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3