Turns a single Filter into a String representing a SQL expression.
Turns a single Filter into a String representing a SQL expression. Returns None for an unhandled filter.
Takes a (schema, table) specification and returns the table's Catalyst schema.
Takes a (schema, table) specification and returns the table's Catalyst schema.
- The JDBC url to fetch information from.
- The table name of the desired table. This may also be a SQL query wrapped in parentheses.
A StructType giving the table's Catalyst schema.
SQLException
if the table contains an unsupported type.
Build and return JDBCRDD from the given information.
Build and return JDBCRDD from the given information.
- Your SparkContext.
- The Catalyst schema of the underlying database table.
- The JDBC url to connect to.
- The fully-qualified table name (or paren'd SQL query) to use.
- The names of the columns to SELECT.
- The filters to include in all WHERE clauses.
- An array of JDBCPartitions specifying partition ids and per-partition WHERE clauses.
An RDD representing "SELECT requiredColumns FROM fqTable".