org.apache.spark.sql.row

JDBCMutableRelation

class JDBCMutableRelation extends BaseRelation with PrunedFilteredScan with InsertableRelation with RowInsertableRelation with UpdatableRelation with DeletableRelation with DestroyRelation with IndexableRelation with Logging

A LogicalPlan implementation for an external row table whose contents are retrieved using a JDBC URL or DataSource.

Linear Supertypes
Logging, IndexableRelation, DestroyRelation, DeletableRelation, UpdatableRelation, RowInsertableRelation, SingleRowInsertableRelation, InsertableRelation, PrunedFilteredScan, BaseRelation, AnyRef, Any
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. JDBCMutableRelation
  2. Logging
  3. IndexableRelation
  4. DestroyRelation
  5. DeletableRelation
  6. UpdatableRelation
  7. RowInsertableRelation
  8. SingleRowInsertableRelation
  9. InsertableRelation
  10. PrunedFilteredScan
  11. BaseRelation
  12. AnyRef
  13. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new JDBCMutableRelation(url: String, table: String, provider: String, mode: SaveMode, userSpecifiedString: String, parts: Array[Partition], poolProperties: Map[String, String], connProperties: Properties, hikariCP: Boolean, origOptions: Map[String, String], sqlContext: SQLContext)

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any

  3. final def ##(): Int

    Definition Classes
    AnyRef → Any

  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any

  6. final def asInstanceOf[T0]: T0

    Definition Classes
    Any

  7. def buildScan(requiredColumns: Array[String], filters: Array[Filter]): RDD[Row]

    Definition Classes
    JDBCMutableRelation → PrunedFilteredScan

  8. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  9. val connProperties: Properties

  10. final lazy val connector: () ⇒ Connection

  11. def createIndex(tableName: String, sql: String): Unit

    Execute index on the table.

    Execute index on the table.

    Definition Classes
    JDBCMutableRelation → IndexableRelation

  12. def createTable(mode: SaveMode): String

  13. def delete(filterExpr: String): Int

    Delete a set of row matching given criteria.

    Delete a set of row matching given criteria.

    filterExpr

    SQL WHERE criteria to select rows that will be deleted

    returns

    number of rows deleted

    Definition Classes
    JDBCMutableRelation → DeletableRelation

  14. def destroy(ifExists: Boolean): Unit

    Destroy and cleanup this relation.

    Destroy and cleanup this relation. It may include, but not limited to, dropping the external table that this relation represents.

    Definition Classes
    JDBCMutableRelation → DestroyRelation

  15. final val dialect: JdbcDialect

  16. val driver: String

  17. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  18. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  19. def executeUpdate(sql: String): Int

    Execute a DML SQL and return the number of rows affected.

    Execute a DML SQL and return the number of rows affected.

    Definition Classes
    JDBCMutableRelation → SingleRowInsertableRelation

  20. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )

  21. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any

  22. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  23. val hikariCP: Boolean

  24. def insert(rows: Seq[Row]): Int

    Insert a sequence of rows into the table represented by this relation.

    Insert a sequence of rows into the table represented by this relation.

    rows

    the rows to be inserted

    returns

    number of rows inserted

    Definition Classes
    JDBCMutableRelation → RowInsertableRelation

  25. def insert(data: DataFrame): Unit

  26. def insert(data: DataFrame, mode: SaveMode): Unit

  27. def insert(data: DataFrame, overwrite: Boolean): Unit

    Definition Classes
    JDBCMutableRelation → InsertableRelation

  28. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  29. def isTraceEnabled(): Boolean

    Attributes
    protected
    Definition Classes
    Logging

  30. def log: Logger

    Attributes
    protected
    Definition Classes
    Logging

  31. def logDebug(msg: ⇒ String, throwable: Throwable): Unit

    Attributes
    protected
    Definition Classes
    Logging

  32. def logDebug(msg: ⇒ String): Unit

    Attributes
    protected
    Definition Classes
    Logging

  33. def logError(msg: ⇒ String, throwable: Throwable): Unit

    Attributes
    protected
    Definition Classes
    Logging

  34. def logError(msg: ⇒ String): Unit

    Attributes
    protected
    Definition Classes
    Logging

  35. def logInfo(msg: ⇒ String, throwable: Throwable): Unit

    Attributes
    protected
    Definition Classes
    Logging

  36. def logInfo(msg: ⇒ String): Unit

    Attributes
    protected
    Definition Classes
    Logging

  37. def logName: String

    Attributes
    protected
    Definition Classes
    Logging

  38. def logTrace(msg: ⇒ String, throwable: Throwable): Unit

    Attributes
    protected
    Definition Classes
    Logging

  39. def logTrace(msg: ⇒ String): Unit

    Attributes
    protected
    Definition Classes
    Logging

  40. def logWarning(msg: ⇒ String, throwable: Throwable): Unit

    Attributes
    protected
    Definition Classes
    Logging

  41. def logWarning(msg: ⇒ String): Unit

    Attributes
    protected
    Definition Classes
    Logging

  42. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef

  43. val needConversion: Boolean

    Definition Classes
    JDBCMutableRelation → BaseRelation

  44. final def notify(): Unit

    Definition Classes
    AnyRef

  45. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  46. val origOptions: Map[String, String]

  47. val parts: Array[Partition]

  48. val poolProperties: Map[String, String]

  49. val provider: String

  50. final lazy val rowInsertStr: String

  51. final lazy val schema: StructType

    Definition Classes
    JDBCMutableRelation → BaseRelation

  52. final lazy val schemaFields: Map[String, StructField]

  53. def sizeInBytes: Long

    Definition Classes
    BaseRelation

  54. val sqlContext: SQLContext

    Definition Classes
    JDBCMutableRelation → BaseRelation

  55. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef

  56. val table: String

  57. var tableSchema: String

  58. def toString(): String

    Definition Classes
    AnyRef → Any

  59. def truncate(): Unit

    Truncate the table represented by this relation.

    Truncate the table represented by this relation.

    Definition Classes
    JDBCMutableRelation → DestroyRelation

  60. def update(filterExpr: String, newColumnValues: Row, updateColumns: Seq[String]): Int

    Update a set of rows matching given criteria.

    Update a set of rows matching given criteria.

    filterExpr

    SQL WHERE criteria to select rows that will be updated

    newColumnValues

    updated values for the columns being changed; must match updateColumns

    updateColumns

    the columns to be updated; must match updatedColumns

    returns

    number of rows affected

    Definition Classes
    JDBCMutableRelation → UpdatableRelation

  61. val url: String

  62. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  63. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  64. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from Logging

Inherited from IndexableRelation

Inherited from DestroyRelation

Inherited from DeletableRelation

Inherited from UpdatableRelation

Inherited from RowInsertableRelation

Inherited from SingleRowInsertableRelation

Inherited from InsertableRelation

Inherited from PrunedFilteredScan

Inherited from BaseRelation

Inherited from AnyRef

Inherited from Any

Ungrouped