In Apache Spark 2.0.0, is it possible to fetch a query from an external database (rather than grab the whole table)?

by

Same as in 1.x you can pass valid subquery as dbtable argument for example:

...
.option("dbtable", "(SELECT foo, bar FROM schema.tablename) AS tmp")
...

More Related Contents:

  1. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  2. How to fix: “No suitable driver found for jdbc:mysql://localhost/dbname” error when using pools? [duplicate]
  3. JDBC batch insert performance
  4. What is the MySQL JDBC driver connection string?
  5. Does spark predicate pushdown work with JDBC?
  6. Am I Using JDBC Connection Pooling?
  7. SQLException: No suitable driver found [duplicate]
  8. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  9. Converting mysql table to spark dataset is very slow compared to same from csv file
  10. Where can I download mysql jdbc jar from? [closed]
  11. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  12. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?
  13. How can I tell when a MySQL table was last updated?
  14. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  15. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. When to use SELECT … FOR UPDATE?
  18. BULK INSERT in MYSQL
  19. Setting column values as column names in the SQL query result
  20. MYSQL sum() for distinct rows
  21. Laravel join with 3 Tables
  22. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  23. How to regex in a MySQL query
  24. How to remove duplicate entries from a mysql db?
  25. Syntax error on MERGE statement
  26. MySql Query Replace NULL with Empty String in Select
  27. how to trim leading zeros from alphanumeric text in mysql function
  28. What are the max number of allowable parameters per database provider type?
  29. How to handle a query with special characters / (forward slash) and \ (backslash)
  30. mySQL query to search all tables within a database for a string?

Leave a Comment