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

1 vote189 views1 answer
Pandas add character to string
Python
2 votes216 views3 answers
Miles to km in python
Python
0 vote203 views1 answer
Time in regression expression python
Python
1 vote205 views2 answers
Number of columns with no missing values
Python
5 votes201 views5 answers
12 hr to 24 hour time conversion python
Python
14 votes211 views4 answers
Django delete
Python Django
2 votes202 views1 answer
Python default input
Python
2 votes211 views1 answer
Python check if string is date format
Python
0 vote203 views1 answer
Vim run python current file
Python
0 vote200 views1 answer
Newsapi in python
Python