Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-6124

Support jdbc connection properties in OPTIONS part of the query

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 1.3.1, 1.4.0
    • SQL
    • None

    Description

      We would like to make it possible to specify connection properties in OPTIONS part of the sql query that uses jdbc driver. For example:

      CREATE TEMPORARY TABLE abc
      USING org.apache.spark.sql.jdbc
      OPTIONS (url '$url', dbtable '(SELECT ROWID FROM test.people)', user 'testUser', password 'testPass')

      To do this, we will do minor changes in JDBCRelation and JDBCRDD.

      Attachments

        Activity

          People

            vlyubin Volodymyr Lyubinets
            vlyubin Volodymyr Lyubinets
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: