Advertisement
Guest User

Untitled

a guest
Jul 24th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. +-------------------------------+-------------------+
  2. | data_type | encoding |
  3. +-------------------------------+-------------------+
  4. | bigint | delta |
  5. | bigint | delta32k |
  6. | character varying(256) | lzo |
  7. | bigint | runlength |
  8. | bigint | bytedict |
  9. | timestamp without time zone | bytedict |
  10. | integer | runlength |
  11. +-------------------------------+-------------------+
  12.  
  13. x.write.format("com.databricks.spark.redshift")
  14. .option("url","jdbc:redshift://<url>:<port>/<schema>?user=<user>&password=<pass>")
  15. .option("dbtable","<tbl_nm>")
  16. .option("diststyle","KEY").option("distkey","<key>")
  17. .option("sortkeyspec","SORTKEY(<sort1>)")
  18. .option("tempdir","<path>")
  19. .mode("error").save()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement