search

TIBCOSoftware / snappydata

Project SnappyData - memory optimized analytics database, based on Apache Spark™ and Apache Geode™. Stream, Transact, Analyze, Predict in one cluster
http://www.snappydata.io
Other
1.04k stars 200 forks source link

Native support for geospatial capabilities #653

Open obaidcuet opened 7 years ago

obaidcuet commented 7 years ago

As far as I know, there is no native support for geospatial capabilities in snappydata. I feel that it is a major capability for modern RDBMS. I have some questions on geospatial capabilities in snappydata which are listed below:

  1. Is there any plan to add native geospatial capabilities(geo-datatypes, geo-index, geo-functions, geo-joins etc) ?
  2. If planning to add native geospatial then when ?
  3. If adding geospatial , the I would suggest to make it as close as possible to postgis (in terms function names, data types names etc), it is most commonly used.
  4. If there is no plan for geospatial capabilities, then what are the recommended workarounds ?

You can consider this feature request.

sumwale commented 7 years ago

@jramnara do you have any thoughts on this?

jramnara commented 7 years ago

@obaidcuet We are aware of the need to support geospatial. We are currently focused on delivering what we have promised in GA form. But, have you looked at projects like Magellan on top of Spark. In theory, this library should work in Snappy too. There could be some work to integrate with the SnappyContext and underlying tables. We love contributors. If you are familiar with this domain, perhaps, you could try and let us know. There are probably several other options.

obaidcuet commented 7 years ago

@jramnara I am considering GeoSpark, as this is official 3rd party spark project. If I can find something reasonable, I will share with you guys.

jbdeandrade commented 7 years ago

Try to take a look at:

https://github.com/zouzias/spark-lucenerdd