在Apache Spark 2.0.0中，是否可以从外部数据库获取查询(而不是获取整个表)？

import org.apache.spark.sql.SparkSession

val spark = SparkSession.builder()
  .appName("Spark Database Query")
  .config("spark.some.config.option", "some-value")
  .getOrCreate()

// 配置数据库连接信息
val jdbcUrl = "jdbc:mysql://localhost:3306/mydatabase"
val jdbcUsername = "username"
val jdbcPassword = "password"

// 从外部数据库获取查询
val query = "(SELECT * FROM mytable WHERE column = 'value') AS tmp"
val df = spark.read.format("jdbc")
  .option("url", jdbcUrl)
  .option("dbtable", query)
  .option("user", jdbcUsername)
  .option("password", jdbcPassword)
  .load()

// 处理查询结果
df.show()