I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results),
aslo "automatically" query by City inside Geo index and get results like
coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow", "lat"
: "55.75", "lon" : "37.62"}, combined by field City from another (Geo)
index?
I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results), aslo "automatically" query by City inside Geo index and get results like coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow", "lat" : "55.75", "lon" : "37.62"}, combined by field City from another (Geo) index?
It's good and simple solution But when I need to update City data
(correct coordinates or add new cities) I also need to reindex User.
If I have some Indexes (databases), each of them reffer to Geo Index
(databese)? I need to update each Index after make changes to Geo.
And, before bulk indexing Users JSON, I must merge User and Geo data by
script.
Le 6 mars 2013 à 10:22, Alexander Peregudov <alexander...@gmail.com<javascript:>>
a écrit :
Hello.
Sorry for confused question.
I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results),
aslo "automatically" query by City inside Geo index and get results like
coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow",
"lat" : "55.75", "lon" : "37.62"}, combined by field City from another
(Geo) index?
Or, I always need to query with filter?
Thank You!
--
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 elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.
Cities are constant, even after an earthquake!
So I would not consider modifying city coordinates as a real user story.
So yes there is a price to pay when you want to correct city coordinates but is it a common and daily operation?
How many users do you have?
How many should be concerned when a city "moves"?
I don't say that you must do it as I suggest but you should just think about it.
My 2 cents.
--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
It's good and simple solution But when I need to update City data (correct coordinates or add new cities) I also need to reindex User.
If I have some Indexes (databases), each of them reffer to Geo Index (databese)? I need to update each Index after make changes to Geo.
And, before bulk indexing Users JSON, I must merge User and Geo data by script.
I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results), aslo "automatically" query by City inside Geo index and get results like coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow", "lat" : "55.75", "lon" : "37.62"}, combined by field City from another (Geo) index?
But, I think it's will be better to have something, that can get data from
various indexes, combine them by known fields and do it in realtime.
Define mapping, where one field linked with field(s) from other indexes or
link field with the query. Yes, this looks like mostrous SQL queries
Alexander
On Wednesday, March 6, 2013 3:22:53 PM UTC+4, David Pilato wrote:
Probably. This new feature could help.
That said, the simplier, the better.
Cities are constant, even after an earthquake!
So I would not consider modifying city coordinates as a real user story.
So yes there is a price to pay when you want to correct city coordinates
but is it a common and daily operation?
How many users do you have?
How many should be concerned when a city "moves"?
I don't say that you must do it as I suggest but you should just think
about it.
My 2 cents.
--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 6 mars 2013 à 11:55, Alexander Peregudov <alexander...@gmail.com<javascript:>>
a écrit :
It's good and simple solution But when I need to update City data
(correct coordinates or add new cities) I also need to reindex User.
If I have some Indexes (databases), each of them reffer to Geo Index
(databese)? I need to update each Index after make changes to Geo.
And, before bulk indexing Users JSON, I must merge User and Geo data by
script.
I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results),
aslo "automatically" query by City inside Geo index and get results like
coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow",
"lat" : "55.75", "lon" : "37.62"}, combined by field City from another
(Geo) index?
--
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 elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.
I am afraid we don't have joins yet I am recommending you to either
duplicate data or do a second request.
simon
On Wednesday, March 6, 2013 1:12:33 PM UTC+1, Alexander Peregudov wrote:
But, I think it's will be better to have something, that can get data from
various indexes, combine them by known fields and do it in realtime.
Define mapping, where one field linked with field(s) from other indexes or
link field with the query. Yes, this looks like mostrous SQL queries
Alexander
On Wednesday, March 6, 2013 3:22:53 PM UTC+4, David Pilato wrote:
Probably. This new feature could help.
That said, the simplier, the better.
Cities are constant, even after an earthquake!
So I would not consider modifying city coordinates as a real user story.
So yes there is a price to pay when you want to correct city coordinates
but is it a common and daily operation?
How many users do you have?
How many should be concerned when a city "moves"?
I don't say that you must do it as I suggest but you should just think
about it.
My 2 cents.
--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
It's good and simple solution But when I need to update City data
(correct coordinates or add new cities) I also need to reindex User.
If I have some Indexes (databases), each of them reffer to Geo Index
(databese)? I need to update each Index after make changes to Geo.
And, before bulk indexing Users JSON, I must merge User and Geo data by
script.
I have index "User" with users profiles. Each profile have filed "city":
{"Name" : "Ivan", "City" : "Moscow"},
{"Name" : "Peter", "City" : "London"},
{"Name" : "Mikhail", "City" : "New-York"}
Also I have index "Geo" with cities coordinates:
{"City" : "Moscow", "lat" : "55.75", "lon" : "37.62"},
{"City" : "London", "lat" : "51.51", "lon" : " -0.13"},
{"City" : "New-York", "lat" : "40.73", "lon" : "-73.99"}
Is it possible, when I'm query User (get by Name or in search results),
aslo "automatically" query by City inside Geo index and get results like
coordinates was stored in User index?
Thus, result for "Ivan" will be {"Name" : "Ivan", "City" : "Moscow",
"lat" : "55.75", "lon" : "37.62"}, combined by field City from another
(Geo) index?
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.
But when I need to update City data
