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 vote162 views2 answers
Numpy random in python
Python
0 vote172 views1 answer
Ringtone download for python playsound
Python
268 votes217 views0 answer
Last element of list python
Python
1 vote143 views1 answer
Visualizing of convolutional kernels using pytorch
Python
1 vote178 views1 answer
Django templateview
Python Django
0 vote156 views1 answer
Update print python
Python
2 votes193 views2 answers
Open terminal in python
Python
0 vote149 views1 answer
While loop odd numbers python
Python
0 vote152 views1 answer
Get imaginary part of complex number python
Python
31 votes179 views3 answers
How to add one to the index of a list
Python