The Spark JDBC data source supports to specify a query as the "dbtable" option. I assume all queries in the above query in pushed down to the database instead of done in Spark.
The phoenix spark plug in seems not supporting that. Why is that? Any plan in the future to support it? I know phoenix spark does support an optional select clause and predicate push down in some cases, but it is limited. Thanks Xindian ------------------------------------------- Xindian "Shindian" Long Mobile: 919-9168651 Email: xindian.l...@gmail.com<mailto:xindian.l...@gmail.com>