Merge Points data with GEOJSON in Hive

melody_angwyn — Fri, 16 Sep 2022 13:17:13 GMT

I have Points and shapefile converted to GEOJSON data uploaded in Hive. I'm doing visualization in Tableau with these files, but to do that I need to join both of the data.

The problem is the Points data don't have any common key if I want to do merging with the shapefile data.

I've done this with sample data in my desktop. The only think I know in order to merge the data, I need to assign the attribute of the shapefile to each of the points, and then do the merging based on the attributes.

I did it in QGIS, using Point Sampling Tools to get the attributes from the shapefile and then join the shapefile and the Points + attribute data in Tableau with common key (i.e. Region).

But since we are talking about big data here, around 19mio rows of data, I'm wondering if we can do the join in Hive?

Anyone that can help giving me ideas will be highly appreciated. Many thanks!

Re: Merge Points data with GEOJSON in Hive

vmurakami — Fri, 08 Jun 2018 01:20:17 GMT

Hey @Melody S!
I'm not a specialist in GEO data, but, this link may serve to you:
https://community.hortonworks.com/articles/5129/geospatial-data-analysis-in-hadoop.html

Hope this helps! 🙂

Re: Merge Points data with GEOJSON in Hive

melody_angwyn — Fri, 08 Jun 2018 09:54:00 GMT

Tthank you! I'll take a look at it.

question Re: Merge Points data with GEOJSON in Hive in Archives of Support Questions (Read Only)

Merge Points data with GEOJSON in Hive

Re: Merge Points data with GEOJSON in Hive

Re: Merge Points data with GEOJSON in Hive