{"categories":["Dataproc","GCP","Google Cloud Platform","JDBC","MySQL","PySpark","Python","Spark","data analysis"],"url":"https://www.ekwbtblog.com/entry/2019/07/27/003225","author_name":"kwbtblog","published":"2019-07-27 00:32:25","provider_url":"https://hatena.blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/k/kwbtblog/20190727/20190727000136.png","type":"rich","blog_title":"Welcome to new things","width":"100%","height":"190","version":"1.0","title":"How to access MySQL from Spark (Google Dataproc)","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.ekwbtblog.com%2Fentry%2F2019%2F07%2F27%2F003225\" title=\"How to access MySQL from Spark (Google Dataproc) - Welcome to new things\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","description":"How to access MySQL from Spark (Google Dataproc). Since it is accessed using JDBC, it can be applied to other RDBs such as PostgreSQL. procedure Spark Configuration The following Spark settings will allow you to read and write MySQL data from Spark. Download the MySQL JDBC jar file https://mvnreposi\u2026","blog_url":"https://www.ekwbtblog.com/","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/kwbtblog/"}