I'm interested in learning if it's possible to grab the results set from a
query run on an external database as opposed to grabbing the full table and
manipulating it later. The base code I'm working with is below (using Spark
2.0.0):
```
from pyspark.sql import SparkSession
df = spark.read\
.format("jdbc")\
.option("url", "jdbc:mysql://localhost:port")\
.option("dbtable", "schema.tablename")\
.option("user", "username")\
.option("password", "password")\
.load()
```
Many thanks,
Pat
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/In-2-0-0-is-it-possible-to-fetch-a-query-from-an-external-database-rather-than-grab-the-whole-table-tp27453.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe e-mail: user-unsubscr...@spark.apache.org
