https://community.cloudera.com/t5/Support-Questions/ESRI-Spatial-Framework-for-Hadoop/m-p/167127#M129459 <P>@<A href="https://community.hortonworks.com/users/12317/sivakumarsudhakarannairgirijakumari.html">sivakumar sudhakarannair girijakumari</A></P><P>ESRI spatial framework for Hadoop could use to store geometry data as text or as json.</P><P>For example, you can store the following MULTIPOLYGON data as text (string in Hive, for example)</P><P>'MULTIPOLYGON (((-158.91661716771827 10.33741051185143, -67.59825779273768 10.33741051185143,-67.59825779273768 53.55389082595917, -158.91661716771827 53.55389082595917, -158.91661716771827 10.33741051185143)))'</P><P>If you wish to apply one of operations supported by ESRI framework for Hive, e.g. ST_Intersects, you need first to convert text to geometry using ST_GeomFromText function. Most of the ESRI spatial functions would require you to convert text to geometry first.</P><P>ESRI spatial framework for Hive supports also json. The approach is similar. You need to convert json to geometry before applying a function like ST_Intersects.</P><P>More details about JSON format here: <A href="https://github.com/Esri/spatial-framework-for-hadoop/wiki/JSON-Formats" target="_blank">https://github.com/Esri/spatial-framework-for-hadoop/wiki/JSON-Formats</A></P> Sun, 07 Aug 2016 01:06:29 GMT cstanca 2016-08-07T01:06:29Z https://community.cloudera.com/t5/Support-Questions/ESRI-Spatial-Framework-for-Hadoop/m-p/167126#M129458 <P></P><P>ESRI Spatial Framework for Hadoop does not support a binary geometry data type for Hive. What are the alternatives?</P> Sat, 06 Aug 2016 02:02:05 GMT https://community.cloudera.com/t5/Support-Questions/ESRI-Spatial-Framework-for-Hadoop/m-p/167126#M129458 sivakumar_sudha 2016-08-06T02:02:05Z https://community.cloudera.com/t5/Support-Questions/ESRI-Spatial-Framework-for-Hadoop/m-p/167127#M129459 <P>@<A href="https://community.hortonworks.com/users/12317/sivakumarsudhakarannairgirijakumari.html">sivakumar sudhakarannair girijakumari</A></P><P>ESRI spatial framework for Hadoop could use to store geometry data as text or as json.</P><P>For example, you can store the following MULTIPOLYGON data as text (string in Hive, for example)</P><P>'MULTIPOLYGON (((-158.91661716771827 10.33741051185143, -67.59825779273768 10.33741051185143,-67.59825779273768 53.55389082595917, -158.91661716771827 53.55389082595917, -158.91661716771827 10.33741051185143)))'</P><P>If you wish to apply one of operations supported by ESRI framework for Hive, e.g. ST_Intersects, you need first to convert text to geometry using ST_GeomFromText function. Most of the ESRI spatial functions would require you to convert text to geometry first.</P><P>ESRI spatial framework for Hive supports also json. The approach is similar. You need to convert json to geometry before applying a function like ST_Intersects.</P><P>More details about JSON format here: <A href="https://github.com/Esri/spatial-framework-for-hadoop/wiki/JSON-Formats" target="_blank">https://github.com/Esri/spatial-framework-for-hadoop/wiki/JSON-Formats</A></P> Sun, 07 Aug 2016 01:06:29 GMT https://community.cloudera.com/t5/Support-Questions/ESRI-Spatial-Framework-for-Hadoop/m-p/167127#M129459 cstanca 2016-08-07T01:06:29Z