CODEWITHSUNDEEP
apache-sparkjdbcpysparkapache-spark-sql
Beso
Beso

Reputation: 1218

Connect to MSSQL from PySpark

I am trying to connect to MS SQL DB from PySpark using spark.read.jdbc.

import os
from pyspark.sql import *
from pyspark.sql.functions import *
from pyspark import SparkContext;
from pyspark.sql.session import SparkSession
sc = SparkContext('xx')
spark = SparkSession(sc)

    spark.read.jdbc('DESKTOP-XXXX\SQLEXPRESS',
"""(select COL1, COL2 from tbl1 WHERE COL1 = 2) """,
properties={'user': sa, 'password': 12345, 'driver': xxxx})

I do not know sc = SparkContext('xx') and 'driver': xxxx which parameters should I pass?

Upvotes: 1

Views: 2699

Answers (1)

mck
mck

Reputation: 42352

Replace serveraddress with your address of database:

sc = SparkContext()
spark = SparkSession(sc)
spark.read \
     .format('jdbc') \
     .option('url', 'jdbc:sqlserver://serveraddress:1433') \
     .option('user', 'sa') \
     .option('password', '12345') \
     .option('dbtable', '(select COL1, COL2 from tbl1 WHERE COL1 = 2)')

Upvotes: 2

Related Questions