Re: SparkSQL JDBC to PostGIS

2015-11-05 Thread Mustafa Elbehery
Hi Stefano, Thanks for prompt reply. Actually I am using *Magellan, *a geospatial library on top of spark. I know that I can load the data in RDDs, or DFs, and use them directly. However, for requirement purposes, I am trying to query the data from PostGIS directly. So, as I have mentioned above,

Re: SparkSQL JDBC to PostGIS

2015-11-04 Thread Stefano Baghino
Hi Mustafa, are you trying to run geospatial queries on the PostGIS DB with SparkSQL? Correct me if I'm wrong, but I think SparkSQL itself would need to support the geospatial extensions in order for this to work. On Wed, Nov 4, 2015 at 1:46 PM, Mustafa Elbehery wrote: > Hi Folks, > > I am tryi

SparkSQL JDBC to PostGIS

2015-11-04 Thread Mustafa Elbehery
Hi Folks, I am trying to connect from SparkShell to PostGIS Database. Simply PostGIS is a *spatial *extension for Postgresql, in order to support *geometry * types. Although the JDBC connection from spark works well with Postgresql, it does not with a database on the same server, which supports t