JDBCMutableRelation

Instance Constructors

new JDBCMutableRelation(connProperties: ConnectionProperties, table: String, provider: String, mode: SaveMode, userSpecifiedString: String, parts: Array[Partition], origOptions: Map[String, String], sqlContext: SQLContext)

Value Members

final def !=(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def ##(): Int

Definition Classes
AnyRef → Any
final def ==(arg0: Any): Boolean

Definition Classes
AnyRef → Any
final def asInstanceOf[T0]: T0

Definition Classes
Any
def buildUnsafeScan(requiredColumns: Array[String], filters: Array[Filter]): (RDD[Any], Seq[RDD[InternalRow]])

Definition Classes
JDBCMutableRelation → PrunedUnsafeFilteredScan
def clone(): AnyRef

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( ... )
final val connFactory: () ⇒ Connection

Attributes
protected
val connProperties: ConnectionProperties
def constructSQL(indexName: String, baseTable: String, indexColumns: Map[String, Option[SortDirection]], options: Map[String, String]): String

Attributes
protected
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
def createTable(mode: SaveMode): String
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
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
final def dialect: JdbcDialect

Attributes
protected
val driver: String
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
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
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
final lazy val executorConnector: () ⇒ Connection
def finalize(): Unit

Attributes
protected[java.lang]
Definition Classes
AnyRef
Annotations
@throws( classOf[java.lang.Throwable] )
final def getClass(): Class[_]

Definition Classes
AnyRef → Any
def initializeLogIfNecessary(isInterpreter: Boolean): Unit

Attributes
protected
Definition Classes
Logging
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
def insert(data: DataFrame): Unit
def insert(data: DataFrame, mode: SaveMode): Unit
def insert(data: DataFrame, overwrite: Boolean): Unit

Definition Classes
JDBCMutableRelation → InsertableRelation
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
def isTraceEnabled(): Boolean

Attributes
protected
Definition Classes
Logging
def log: Logger

Attributes
protected
Definition Classes
Logging
def logDebug(msg: ⇒ String, throwable: Throwable): Unit

Attributes
protected
Definition Classes
Logging
def logDebug(msg: ⇒ String): Unit

Attributes
protected
Definition Classes
Logging
def logError(msg: ⇒ String, throwable: Throwable): Unit

Attributes
protected
Definition Classes
Logging
def logError(msg: ⇒ String): Unit

Attributes
protected
Definition Classes
Logging
def logInfo(msg: ⇒ String, throwable: Throwable): Unit

Attributes
protected
Definition Classes
Logging
def logInfo(msg: ⇒ String): Unit

Attributes
protected
Definition Classes
Logging
def logName: String

Attributes
protected
Definition Classes
Logging
def logTrace(msg: ⇒ String, throwable: Throwable): Unit

Attributes
protected
Definition Classes
Logging
def logTrace(msg: ⇒ String): Unit

Attributes
protected
Definition Classes
Logging
def logWarning(msg: ⇒ String, throwable: Throwable): Unit

Attributes
protected
Definition Classes
Logging
def logWarning(msg: ⇒ String): Unit

Attributes
protected
Definition Classes
Logging
val mode: SaveMode
final def ne(arg0: AnyRef): Boolean

Definition Classes
AnyRef
val needConversion: Boolean

Definition Classes
JDBCMutableRelation → BaseRelation
final def notify(): Unit

Definition Classes
AnyRef
final def notifyAll(): Unit

Definition Classes
AnyRef
val origOptions: Map[String, String]
val parts: Array[Partition]
val provider: String
final lazy val rowInsertStr: String
final lazy val schema: StructType

Definition Classes
JDBCMutableRelation → BaseRelation
final lazy val schemaFields: Map[String, StructField]
def sizeInBytes: Long

Definition Classes
JDBCMutableRelation → BaseRelation
val sqlContext: SQLContext

Definition Classes
JDBCMutableRelation → BaseRelation
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
val table: String
var tableExists: Boolean

Return true if table already existed when the relation object was created.
Return true if table already existed when the relation object was created.

Definition Classes
JDBCMutableRelation → DestroyRelation
var tableSchema: String
def truncate(): Unit

Truncate the table represented by this relation.
Truncate the table represented by this relation.

Definition Classes
JDBCMutableRelation → DestroyRelation
def unhandledFilters(filters: Array[Filter]): Array[Filter]

Definition Classes
JDBCMutableRelation → BaseRelation
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
val userSpecifiedString: String
final def wait(): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long, arg1: Int): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )
final def wait(arg0: Long): Unit

Definition Classes
AnyRef
Annotations
@throws( ... )

Related Doc: package row

Instance Constructors

new JDBCMutableRelation(connProperties: ConnectionProperties, table: String, provider: String, mode: SaveMode, userSpecifiedString: String, parts: Array[Partition], origOptions: Map[String, String], sqlContext: SQLContext)

Value Members

final def !=(arg0: Any): Boolean

final def ##(): Int

final def ==(arg0: Any): Boolean

final def asInstanceOf[T0]: T0

def buildUnsafeScan(requiredColumns: Array[String], filters: Array[Filter]): (RDD[Any], Seq[RDD[InternalRow]])

def clone(): AnyRef

final val connFactory: () ⇒ Connection

val connProperties: ConnectionProperties

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

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

def createTable(mode: SaveMode): String

def delete(filterExpr: String): Int

def destroy(ifExists: Boolean): Unit

final def dialect: JdbcDialect

val driver: String

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

final def eq(arg0: AnyRef): Boolean

def executeUpdate(sql: String): Int

final lazy val executorConnector: () ⇒ Connection

def finalize(): Unit

final def getClass(): Class[_]

def initializeLogIfNecessary(isInterpreter: Boolean): Unit

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

def insert(data: DataFrame): Unit

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

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

final def isInstanceOf[T0]: Boolean

def isTraceEnabled(): Boolean

def log: Logger

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

def logDebug(msg: ⇒ String): Unit

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

def logError(msg: ⇒ String): Unit

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

def logInfo(msg: ⇒ String): Unit

def logName: String

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

def logTrace(msg: ⇒ String): Unit

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

def logWarning(msg: ⇒ String): Unit

val mode: SaveMode

final def ne(arg0: AnyRef): Boolean

val needConversion: Boolean

final def notify(): Unit

final def notifyAll(): Unit

val origOptions: Map[String, String]

val parts: Array[Partition]

val provider: String

final lazy val rowInsertStr: String

final lazy val schema: StructType

final lazy val schemaFields: Map[String, StructField]

def sizeInBytes: Long

val sqlContext: SQLContext

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

val table: String

var tableExists: Boolean

var tableSchema: String

def truncate(): Unit

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

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

val userSpecifiedString: String

final def wait(): Unit

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

final def wait(arg0: Long): Unit

Inherited from Serializable

Inherited from Serializable

Inherited from Product

Inherited from Equals

Inherited from internal.Logging

Inherited from IndexableRelation

Inherited from DestroyRelation

Inherited from DeletableRelation

Inherited from UpdatableRelation

Inherited from RowInsertableRelation

Inherited from SingleRowInsertableRelation