Hello forgive me if I am under-informed but i am looking for a way to
search complex data in elasticsearch using hive. The structure I am
looking at has nested location object that contains longitude and latitude
and I am looking for a way to create a hive table that flattens out that
data or to create a separate table with the longitude and latitude in it i
can use to join to the rest of my dataset in Hive. Please let me know if
you need more information or if this use case is documented somewhere i
reference. Thanks for your help.
band:{
name:"nolan",
location:
{
lat:101,
long: 101
}
}
Hive table band
columns - name lat long
Nolan Grace
--
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/462fa85d-1ea4-4dd1-9e45-0da4d6693fdc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Haha I was able to figure it out. As long as the hive external table is
created you can reference the nested fields as if the struct column was its
own table in the select statement. For example after the band table was
created directly referencing lat in Hive is a easy as SELECT location.lat
FROM Band;
On Friday, March 6, 2015 at 10:22:19 AM UTC-6, nolan grace wrote:
Hello forgive me if I am under-informed but i am looking for a way to
search complex data in elasticsearch using hive. The structure I am
looking at has nested location object that contains longitude and latitude
and I am looking for a way to create a hive table that flattens out that
data or to create a separate table with the longitude and latitude in it i
can use to join to the rest of my dataset in Hive. Please let me know if
you need more information or if this use case is documented somewhere i
reference. Thanks for your help.
band:{
name:"nolan",
location:
{
lat:101,
long: 101
}
}
Hive table band
columns - name lat long
Nolan Grace
--
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/93300322-daa1-4447-8941-07755c2dc3cc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.