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
12 views

Use Geotrellis to rasterize LiDAR data

How can I use Geotrellis (distributed format) to Rasterize LiDAR (or XYZ DATA ) in HDFS?
1
vote
0answers
120 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
458 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 > ...
1
vote
2answers
401 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
359 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
433 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
413 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
586 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
280 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
470 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
4k 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
718 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
835 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
311 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 ...