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 [email protected].
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.
