Loading…
Attending this event?
View analytic
Thursday, November 16 • 9:50am - 10:30am
Turning a Relational RDBMS Table into a Spark Datasource

Sign up or log in to save this to your schedule and see who's attending!

Log in to leave feedback.
This session presents a Spark DataSource implementation for integrating (joining) Big Data in HDFS or NoSQL DBMS with Master Data in RDBMS table. The session describes how to allow parallel and direct access to RDBMS tables from Spark, generate partitions of Spark JDBCRDDs based on the split pattern and rewrites Spark SQL queries into the RDBMS SQL dialect. The session also describes the performance optimizations including hooks in the JDBC driver for faster type conversions, pushing down predicates to the RDBMS, pruning partition based on the where clause, and projecting columns to the RDBMS table to reduce the amount of data returned and processed on Spark.

Speakers
avatar for Kuassi Mensah

Kuassi Mensah

Director, Product Management, Oracle Corporation
Kuassi Mensah is Director of Product Management at Oracle; his scope includes:(i) Java performance, scalability, HA, and Security with Oracle database.(ii) Hadoop and Spark integration with the Oracle database (iii) Java & JavaScript integration with the Oracle database (OJVM, Nashorn) Mr Mensah holds a MS in CS from the Programming Institute of University of Paris.He is is a frequent speaker at IT events (Oracle Open World, JavaOne, Sangam, OTNYathra, UKOUG, DOAG, OUGN, BGOUG, etc... Read More →


Thursday November 16, 2017 9:50am - 10:30am
Data

Attendees (37)