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 vote230 views2 answers
Django models get all
Python Django
0 vote169 views1 answer
Fibonacci in list python
Python
1 vote174 views1 answer
Can we use else without if in python
Python
1 vote160 views5 answers
Transpose matrix python
Python
0 vote162 views2 answers
2)Write a function that checks whether a number is in a given range (inclusive of high and low) python
Python
1 vote161 views1 answer
Python set timezone of datetime
Python
27 votes188 views5 answers
Pretty json python
Python
16 votes183 views3 answers
Self keyword in python
Python
-1 vote162 views1 answer
Difference between % and // in python
Python
0 vote154 views1 answer
Python move all txt files
Python