Re: JDBCConnectionProvider in Spark

2022-01-07 Thread Gabor Somogyi
We've expected that it would be hard to understand all the aspects at first so created an explanation for it. Please see the following readme which hopefully answers most of your questions: https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/jdbc/README.md On

Re: JDBCConnectionProvider in Spark

2022-01-06 Thread Sean Owen
They're in core/ under org.apache.spark.sql.execution.datasources.jdbc.connection I don't quite understand, it's an abstraction over lots of concrete implementations, just simple software design here. You can implement your own provider too I suppose. On Thu, Jan 6, 2022 at 8:22 AM Artemis User w

Re: JDBCConnectionProvider in Spark

2022-01-06 Thread Artemis User
The only example I saw in the Spark distribution was ExampleJdbcConnectionProvider file in the examples directory.  It basically just wraps the abstract class with overriding methods.  I guess my question was since Spark embeds the JDBC APIs in the DataFrame reader and writer, why such provider

Re: JDBCConnectionProvider in Spark

2022-01-06 Thread Sean Owen
There are 8 concrete implementations of it? OracleConnectionProvider, etc On Wed, Jan 5, 2022 at 9:26 PM Artemis User wrote: > Could someone provide some insight/examples on the usage of this API? > > https://spark.apache.org/docs/latest/api/scala/org/apache/spark/sql/jdbc/JdbcConnectionProvider