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, the JDBC connection works fine with PostgresSql. Though, it through *unsupported *exception when I am try to query a database which supports GIS Extension. I do not know how to hack it, or if there is a workaround before reporting the Bug, Regards. On Wed, Nov 4, 2015 at 1:50 PM, Stefano Baghino < stefano.bagh...@radicalbit.io> wrote: > 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 < > elbeherymust...@gmail.com> wrote: > >> 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 the PostGIS >> extension. >> >> I have tried to build the JDBC driver of the PostGIS, and use it, but it >> throws *No suitable driver found for jdbc:postgis.* >> >> Would like to know if anyone had the same problem before reporting the >> bug on JIRA. >> >> Regards. >> >> -- >> Mustafa Elbehery >> EIT ICT Labs Master School <http://www.masterschool.eitictlabs.eu/home/> >> +49(0)15750363097 >> skype: mustafaelbehery87 >> >> > > > -- > BR, > Stefano Baghino > > Software Engineer @ Radicalbit > -- Mustafa Elbehery EIT ICT Labs Master School <http://www.masterschool.eitictlabs.eu/home/> +49(0)15750363097 skype: mustafaelbehery87
