Spatial analytics support
DataStax Enterprise integrates some components of GIS Tools for Hadoop.
DataStax Enterprise 4.5.2 and later integrates some components of GIS Tools for Hadoop. The GIS Tools for Hadoop open source project provides several libraries for performing spatial analytics. DataStax Enterprise incorporates the Hive Spatial library of the Spatial Framework for Hadoop and includes a custom tool for importing data in Enclosed JSON format from ArcGIS to a Cassandra table.
DataStax Enterprise supports Environmental Systems Research Institute (ESRI) data types, which map to the following Cassandra CQL types:
ESRI Type | Description | CQL Type |
---|---|---|
esriFieldTypeSmallInteger | Integer | Int |
esriFieldTypeInteger | Long integer | Bigint |
esriFieldTypeSingle | Single-precision floating-point number | Float/decimal |
esriFieldTypeDouble | Double-precision floating-point number | Double/decimal |
esriFieldTypeString | Character string | Text |
esriFieldTypeDate | Date | Date |
esriFieldTypeOID | Long integer representing an object identifier | Bigint |
esriFieldTypeGeometry | Geometry | Blob |
esriFieldTypeBlob | Binary large object | Blob |
esriFieldTypeRaster | Raster | N/A |
esriFieldTypeGUID | Globally unique identifier | Text |
esriFieldTypeGlobalID | ESRI global ID | Text |
esriFieldTypeXML | XML document | N/A |
The DataStax Enterprise custom ESRI import tool supports the Enclosed JSON format. The syntax for using the tool is:
esri-import -keyspace <keyspace name> -table <table name> -dir <path to files> [options]
Options are:
- -dir <path>
- Directory of ESRI data files
- -exclude <files>
- Files to exclude
- -file <files>
- Included files
- -help
- esri-import command usage help
- -host <host>
- Host name of node
- -port <port>
- Port number on the host node
The example of analyzing data shows how to use the GIS tools for Hadoop.