Questions tagged [hive]

Data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis.

Filter by
Sorted by
Tagged with
0
votes
0answers
40 views

Use Geotrellis to rasterize LiDAR data

How can I use Geotrellis (distributed format) to Rasterize LiDAR (or XYZ DATA ) in HDFS? I converted las file to spark RDD with the IQMULUS library and I want to use this RDD ( [x1,y1,z1] [x2,y2,z2] ....
1
vote
0answers
138 views

How can I limit a Hive spatial binning query to a specific map extent?

I'm trying to do a HQL query based off a map extent. I cant get this to work, what am I doing wrong? I'm using the taxi_demo in the ESRI example. SELECT ST_Bin(0.001, ST_Point(dropoff_longitude,...
1
vote
1answer
518 views

Unable to retrieve date columns in hive

I am finding difficulty when it comes to retrieving date values in hive. I am using esri git hub tools for hadoop and my final objective is to display these columns in arcmap. My query is > ...
0
votes
1answer
431 views

JSON to features not working while performing ST_Buffer

My objective is to create a buffer of 1000 m for enode. I used the following query. CREATE external table enodebuffer (shape binary); INSERT OVERWRITE TABLE enodebuffer SELECT ST_Buffer(...
1
vote
1answer
415 views

Proximity query in Hive using ESRI geospatial library

I have one table of lines and one of points and need to find all pairs of line + point with a proximity < 10 meters. The documentation for the ESRI hive library completely elides any discussion of ...
2
votes
1answer
495 views

Hive GIS ST_GeodesicLengthWGS84 not returning expected distance

I am trying to find the distance between two points (in meters and not degrees) using GIS Tools for Hadoop by ESRI. The ST_Length provides distance in degrees and hence I used the ...
2
votes
0answers
453 views

Using a file .shp with ESRI Geo Tools for Hadoop

I've a file .shp that I would like to load into a TABLE using HIVE with ESRI Geo Tool for Hadoop. These tools read JSON files and I've tried to convert my file into a .json format using GDAL Library ...
1
vote
1answer
634 views

How to use hadoop tools in ArcMap 10.3?

I have downloaded hadoop tools for ArcMap and installed. In the ArcToolboxe window the hadoop tools are displayed. In the hadoop toolbox the "Copy from HDFS" tool is asking for an HDFS server hostname,...
0
votes
1answer
294 views

Reprojecting a Geometry in Hadoop GIS?

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 ...
1
vote
0answers
491 views

Error using ST_Geometry Aggregate Function for Hive

I am using the ESRI framework that extends the Hive syntax to support spatial types and operations. In particular, I am trying to use an aggregated geometry function, announced in this blog post in ...
4
votes
2answers
5k views

How to load geographic data into Hadoop (Hive) and then to be able to call spatial functions on them?

I need to load some geographic data into Hadoop (Hive), and then, to be able to call some spatial functions on them using Hive. My input data format is ESRI shapefiles (but could be another format, I ...
4
votes
1answer
778 views

Query to Dissolve Nearby Polygons on Hive

I am using the ESRI spatial framework for Hadoop, that extends Hive to use spatial types and operations. My objective is to translate a set of simple queries on PostGIS into Hadoop, in order to ...
1
vote
2answers
2k views

How to process GeoJSON data and create hive table for spatial analysis

I am using the ESRI-GIS tool for hadoop for analyzing json data generated through ESRI products like ArcGIS. But I wanted to analyze spatial data from a PostGIS table for which I made geojson ...
2
votes
1answer
1k views

Create table with Geometry Column in hadoop Hive

Is there a way to add a geometry column in hadoop? Please give me some getting-started tutorial for geoprocessing in hadoop. Like, I have a database which have point values and if I take a random ...
1
vote
2answers
2k views

Load .shp file in Hive(Hadoop)

I need to load .shp files in Hive more precisely in HortonWorks sandbox through Beeswax, can anyone provide example of Hive commands or steps for Beeswax ?
1
vote
0answers
318 views

Big data rastering using ArcGIS Platform?

I have the daunting task doing raster analysis on a record set that runs into quite a few millions, and worse still is that the data is in Hive. So far I have managed to use record set of 2 million ...