[
https://issues.apache.org/jira/browse/SPARK-12266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Severin Thaler updated SPARK-12266:
-----------------------------------
Description:
on server postgis server running with a table that has a column of type raster
on client running spark standalone application that pulls data from remote
postgis server using spark-sql and jdbc driver:
{code:none}
val conf = new SparkConf().setAppName("Simple Application").setMaster("local")
val sc = new SparkContext(conf)
val sqlContext = new SQLContext(sc)
val jdbcDF = sqlContext.read.format("jdbc").options(Map("url" ->
"jdbc:postgresql://postgishost/test?user=postgres&password=userpassword",
"dbtable" -> "atlas")).load()
val rows = jdbcDF.take(3)
println(rows(0).toString())
println(rows(1).toString())
println(rows(2).toString())
{code}
was:
on server postgis server running with a table that has a column of type raster
on client running spark standalone application that pulls data from remote
postgis server using spark-sql and jdbc driver:
{code:scala}
val conf = new SparkConf().setAppName("Simple Application").setMaster("local")
val sc = new SparkContext(conf)
val sqlContext = new SQLContext(sc)
val jdbcDF = sqlContext.read.format("jdbc").options(Map("url" ->
"jdbc:postgresql://postgishost/test?user=postgres&password=userpassword",
"dbtable" -> "atlas")).load()
val rows = jdbcDF.take(3)
println(rows(0).toString())
println(rows(1).toString())
println(rows(2).toString())
{code}
> cannot handle postgis raster type
> ---------------------------------
>
> Key: SPARK-12266
> URL: https://issues.apache.org/jira/browse/SPARK-12266
> Project: Spark
> Issue Type: Bug
> Components: Input/Output
> Affects Versions: 1.5.2
> Environment: PostGIS Server:
> Ubuntu-14.04
> Postgres 9.4.5
> PostGIS 2.2.1
> Spark standalone client:
> Java 7
> Spark 1.5.2
> PostGIS JDBC driver built within java directory of PostGIS 2.1.8, see:
> http://postgis.net/docs/manual-2.1/postgis_installation.html#idp58575520
> Reporter: Severin Thaler
> Labels: dataframe, postgres, sql
>
> on server postgis server running with a table that has a column of type raster
> on client running spark standalone application that pulls data from remote
> postgis server using spark-sql and jdbc driver:
> {code:none}
> val conf = new SparkConf().setAppName("Simple Application").setMaster("local")
> val sc = new SparkContext(conf)
> val sqlContext = new SQLContext(sc)
> val jdbcDF = sqlContext.read.format("jdbc").options(Map("url" ->
> "jdbc:postgresql://postgishost/test?user=postgres&password=userpassword",
> "dbtable" -> "atlas")).load()
> val rows = jdbcDF.take(3)
> println(rows(0).toString())
> println(rows(1).toString())
> println(rows(2).toString())
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
