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
Known Subclasses
RowFormatRelation
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(connProperties: ConnectionProperties, table: String, provider: String, mode: SaveMode, userSpecifiedString: String, parts: Array[Partition], 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. final val connFactory: () ⇒ Connection

    Attributes
    protected

  10. val connProperties: ConnectionProperties

  11. def constructSQL(indexName: String, baseTable: String, indexColumns: Map[String, Option[SortDirection]], options: Map[String, String]): String

    Attributes
    protected

  12. def createIndex(indexIdent: QualifiedTableName, tableIdent: QualifiedTableName, indexColumns: Map[String, Option[SortDirection]], options: Map[String, String]): Unit

    Create an index on a table.

    Create an index on a table.

    indexIdent

    Index Identifier which goes in the catalog

    tableIdent

    Table identifier on which the index is created.

    indexColumns

    Columns on which the index has to be created with the direction of sorting. Direction can be specified as None.

    options

    Options for indexes. For e.g. column table index - ("COLOCATE_WITH"->"CUSTOMER"). row table index - ("INDEX_TYPE"->"GLOBAL HASH") or ("INDEX_TYPE"->"UNIQUE")

    Definition Classes
    JDBCMutableRelation → IndexableRelation

  13. def createTable(mode: SaveMode): String

  14. 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

  15. 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

  16. final def dialect: JdbcDialect

    Attributes
    protected

  17. val driver: String

  18. def dropIndex(indexIdent: QualifiedTableName, tableIdent: QualifiedTableName, ifExists: Boolean): Unit

    Drops an index on this table

    Drops an index on this table

    indexIdent

    Index identifier

    tableIdent

    Table identifier

    ifExists

    Drop if exists

    Definition Classes
    JDBCMutableRelation → IndexableRelation

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

    Definition Classes
    AnyRef

  20. def equals(arg0: Any): Boolean

    Definition Classes
    AnyRef → Any

  21. 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

  22. final lazy val executorConnector: () ⇒ Connection

  23. def finalize(): Unit

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

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

    Definition Classes
    AnyRef → Any

  25. def hashCode(): Int

    Definition Classes
    AnyRef → Any

  26. 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

  27. def insert(data: DataFrame): Unit

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

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

    Definition Classes
    JDBCMutableRelation → InsertableRelation

  30. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any

  31. def isTraceEnabled(): Boolean

    Attributes
    protected
    Definition Classes
    Logging

  32. def log: Logger

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

  39. def logName: String

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Attributes
    protected
    Definition Classes
    Logging

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

    Definition Classes
    AnyRef

  45. val needConversion: Boolean

    Definition Classes
    JDBCMutableRelation → BaseRelation

  46. final def notify(): Unit

    Definition Classes
    AnyRef

  47. final def notifyAll(): Unit

    Definition Classes
    AnyRef

  48. val origOptions: Map[String, String]

  49. val parts: Array[Partition]

  50. val provider: String

  51. final lazy val rowInsertStr: String

  52. final lazy val schema: StructType

    Definition Classes
    JDBCMutableRelation → BaseRelation

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

  54. def sizeInBytes: Long

    Definition Classes
    JDBCMutableRelation → BaseRelation

  55. val sqlContext: SQLContext

    Definition Classes
    JDBCMutableRelation → BaseRelation

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

    Definition Classes
    AnyRef

  57. val table: String

  58. var tableSchema: String

  59. def toString(): String

    Definition Classes
    AnyRef → Any

  60. def truncate(): Unit

    Truncate the table represented by this relation.

    Truncate the table represented by this relation.

    Definition Classes
    JDBCMutableRelation → DestroyRelation

  61. def unhandledFilters(filters: Array[Filter]): Array[Filter]

    Definition Classes
    BaseRelation

  62. 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

  63. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

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

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

  65. 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