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

6 votes308 views3 answers
Virtual environment mac
Python
73 votes317 views1 answer
Pip install error
Python
9 votes339 views2 answers
Display maximum columns pandas
Python
-1 vote295 views1 answer
Muslimah coder
Python
1 vote322 views1 answer
Python mean and standard deviation of list
Python
1 vote325 views1 answer
Comentario em python
Python
0 vote329 views1 answer
Show post id on django admin interface
Python
0 vote356 views1 answer
Fakultät python
Python
0 vote351 views1 answer
Django require_POST body
Python Django
1 vote308 views2 answers
Python try except raise error
Python