Are there other spatial frameworks that can work with ESRI Spatial Framework and Hive and provide the missing functions in ESRI framework for Hadoop? ... View more

Width_Bucket function is not support in ESRI Spatial Framework for Hadoop. What are the alternatives fro this function? ... View more

We perform frequently Cartesian products involving geospatial functions in the where clause (e.g. ST_Intersects) of our Hive queries. What are the best approaches for tuning those queries for response time and concurrency? ... View more

Some mathematical (e.g. atan2) and analytical functions (e.g. WIDTH_BUCKET) are not available in hive , which is availabe in other databases . Could you recommend some open source libraries that I can leverage? ... View more

ST_Transform is not supported in ESRI Spatial Framework for Hadoop. What are the alternatives?. St_transform is used to transform the one spatial coordinate system to other coordinate system. ... View more

ESRI Spatial Framework does not provide a native geometry type in Hive, the alternative is to store the geometry in text or json format. What is better for functionality and performance. ... View more

While executing a select query when other queries are running in Hive we are facing below error . Can you some one suggest me what could be the reason for below error. Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1470078643944_0469_5_00, diagnostics=[Vertex vertex_1470078643944_0469_5_00 [Map 1] killed/failed due to:ROOT_INPUT_INIT_FAILURE, Vertex Input: se initializer failed, vertex=vertex_1470078643944_0469_5_00 [Map 1], org.apache.tez.dag.api.TezUncheckedException: Invalid max/min group lengths. Required min>0, max>=min. max: 4194304 min: 16777216 at org.apache.hadoop.mapred.split.TezMapredSplitsGrouper.getGroupedSplits(TezMapredSplitsGrouper.java:147) at org.apache.hadoop.hive.ql.exec.tez.SplitGrouper.group(SplitGrouper.java:89) at org.apache.hadoop.hive.ql.exec.tez.SplitGrouper.generateGroupedSplits(SplitGrouper.java:168) at org.apache.hadoop.hive.ql.exec.tez.SplitGrouper.generateGroupedSplits(SplitGrouper.java:138) at org.apache.hadoop.hive.ql.exec.tez.HiveSplitGenerator.initialize(HiveSplitGenerator.java:159) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:273) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable$1.run(RootInputInitializerManager.java:266) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1709) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:266) at org.apache.tez.dag.app.dag.RootInputInitializerManager$InputInitializerCallable.call(RootInputInitializerManager.java:253) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ]Vertex killed, vertexName=Map 2, vertexId=vertex_1470078643944_0469_5_01, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1470078643944_0469_5_01 [Map 2] killed/failed due to:OTHER_VERTEX_FAILURE]Vertex killed, vertexName=Reducer 3, vertexId=vertex_1470078643944_0469_5_02, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1470078643944_0469_5_02 [Reducer 3] killed/failed due to:OTHER_VERTEX_FAILURE]Vertex killed, vertexName=Reducer 4, vertexId=vertex_1470078643944_0469_5_03, diagnostics=[Vertex received Kill in INITED state., Vertex vertex_1470078643944_0469_5_03 [Reducer 4] killed/failed due to:OTHER_VERTEX_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:3 Appreciated for your help in advance. ... View more