回复：Re: How to connect JDBC DB based on Spark Sql

Great! It works. Thanks. Best,Yi - 原始邮件 - 发件人：Augustin Borsu 收件人：doovs...@sina.com 抄送人：dev 主题：Re: How to connect JDBC DB based on Spark Sql 日期：2015年04月14日 14点14分 Hello Yi, You can actually pass the username and password in the url. E.g. val url = " jdbc:postgresql://ip.ip.ip.

Re: How to connect JDBC DB based on Spark Sql

Hello Yi, You can actually pass the username and password in the url. E.g. val url = " jdbc:postgresql://ip.ip.ip.ip/ow-feeder?user=MY_LOGIN&password=MY_PASSWORD" val query = "(SELECT * FROM \"YadaYada\" WHERE type='item' LIMIT 100) as MY_DB" val jdbcDF = sqlContext.load("jdbc", Map( "url" -> ur

How to connect JDBC DB based on Spark Sql

Hi all, According to the official document, SparkContext can load datatable to dataframe using the DataSources API. However, it just supports the following properties:Property NameMeaningurlThe JDBC URL to connect to.dbtableThe JDBC table that should be read. Note that anything that is valid in