Hi,
I've trying to load a postgres table using the following expression:
val cachedIndex = cache.get("latest_legacy_group_index")
val mappingsDF = sqlContext.load("jdbc", Map(
"url" -> Config.dataSourceUrl(mode, Some("mappings")),
"dbtable" -> s"(select userid, yid, username from legacyusers offset
$cachedIndex ) as legacyusers")
)
I'll like to know if this expression is correct:
"dbtable" -> s"(select userid, yid, username from legacyusers offset
$cachedIndex ) as legacyusers")
As you can see. I'm trying to load the table records by offset
I appreciate your help.
