Writing Spark DataFrame to MySQL Table
In this video lecture we will learn how to read a csv file and store it in an DataBase table which can be MySQL, Oracle, Teradata or any DataBase which supports JDBC connection. In this video I have used MySQL DB which is part of Cloudera Quick Start edition. Procedure for storing data to other databases like Oracle, Teradata is same. Only connection URL and Driver should be changed appropriately.
Books I Follow:
Apache Spark Books:
Learning Spark: https://amzn.to/2pCcn8W
High Performance Spark: https://amzn.to/2Goy9ac
Advanced Analytics with Spark: https://amzn.to/2pD57Ke
Apache Spark 2.0 Cookbook: https://amzn.to/2pEbAUp
Mastering Apache Spark 2.0: https://amzn.to/2udDEUg
Scala Programming:
Programming in Scala: https://amzn.to/2uiTGfl
Hadoop Books:
Hadoop: The Definitive Guide: https://amzn.to/2pDheH4
Hive:
Programming Hive: https://amzn.to/2Gqwz7o
HBase:
HBase The Definitive Guide: https://amzn.to/2Gj9rI2
Python Books:
Learning Python: https://amzn.to/2pDqo6m