I am using ESRI's spatial framework for Hadoop, in order to add spatial support to Hive.

One scenario that I find very often, is to have layers in different CRS, which I want to relate in the same query. Also, although most things are in WGS84 these days, sometimes it is useful to use a projected CRS, in order to measure things such as areas or distances.

Thus I find that reprojection is a very common need, when working with spatial data. Within PostGIS, I just apply ST_transform to one geometry, to transform it into another CRS. For instance, this code would reproject the centroid of Barcelona, from whatever crs to an UTM grid:

SELECT ST_Transform(ST_Point(2.16991941.387917), 5554);

In the ESRI's function list, I dont see any mention of ST_Transform. Am I missing something or this no way to achieve this using this framework? Is there any workaround around this?

I believe is a shame if one is not able to perform this operation on a scalable way, since doing it using another tool (for instance PostGIS), could be a bottleneck in a scalable workflow...


It is not possible at this time. The geometry library that the Hive ST functions depend on does not support projection.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.