search

Esri / gis-tools-for-hadoop

The GIS Tools for Hadoop are a collection of GIS tools for spatial analysis of big data.
http://esri.github.io/gis-tools-for-hadoop/
Apache License 2.0
521 stars 254 forks source link

Taxi_demo table gives garbage output. #61

Closed shivam-dwivedi closed 4 years ago

shivam-dwivedi commented 7 years ago

I am following the spatial binning steps (refer to below link below) https://github.com/Esri/gis-tools-for-hadoop/wiki/Aggregating-CSV-Data-%28Spatial-Binning%29

when i run the following query it gives me some Garbage output and never finishes, I have to manually interrupt .FROM (SELECT ST_Bin(0.001, ST_Point(dropoff_longitude,dropoff_latitude)) bin_id, FROM taxi_demo) bins SELECT ST_BinEnvelope(0.001, bin_id) shape, COUNT() count GROUP BY bin_id;

any idea what could be the reason ?

randallwhitman commented 7 years ago

How long did you let it run?

shivam-dwivedi commented 7 years ago

Heey Randall, I ran the query again with a limit. Please find attached screenshot. image

randallwhitman commented 7 years ago

Image does not suffice for textual data, but I can mention that a Geometry is binary, and will not be human-readable unless wrapped by ST_AsText (or AsJSON, etc.).

shivam-dwivedi commented 7 years ago

how would i do that ? would you be able to give an example.

randallwhitman commented 7 years ago

examples - https://github.com/Esri/spatial-framework-for-hadoop/blob/master/hive/test/st-geom-text.sql

shivam-dwivedi commented 7 years ago

Thanks so much, I will take a look at it and get back to you, if required :-)