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