Pyspark read from redshift

from pyspark.sql import SQLContext

sc = # existing SparkContext
sql_context = SQLContext(sc)

# Read data from a table
df = sql_context.read \
    .format("com.databricks.spark.redshift") \
    .option("url", "jdbc:redshift://redshifthost:5439/database?user=username&password=pass") \
    .option("dbtable", "my_table") \
    .option("tempdir", "s3n://path/for/temp/data") \
    .load()

Similar codes

0 vote201 views1 answer
Read emails from gmail python
Python
1 vote178 views1 answer
Fasttext python
Python
-1 vote206 views1 answer
Add widget in pyqt
Python
7 votes162 views1 answer
Program to find even numbers in python
Python
6 votes187 views1 answer
Get mouse postition python
Python
0 vote189 views2 answers
Bar plot group by pandas
Python
0 vote188 views1 answer
Generator comprehension python
Python
6 votes177 views1 answer
Python exit for loop
Python
0 vote214 views1 answer
Back button django template
Python Django
1 vote195 views1 answer
Import bokeh
Python