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
def alterTable(tableIdent: QualifiedTableName, isAddColumn: Boolean, column: StructField): Unit

Alter's table schema by adding or dropping a provided column
Alter's table schema by adding or dropping a provided column

Definition Classes
JDBCMutableRelation → AlterableRelation
final def asInstanceOf[T0]: T0

Definition Classes
Any
def buildUnsafeScan(requiredColumns: Array[String], filters: Array[Expression]): (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
Definition Classes
JDBCMutableRelation → NativeTableRowLevelSecurityRelation
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
Definition Classes
JDBCMutableRelation → NativeTableRowLevelSecurityRelation
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
def enableOrDisableRowLevelSecurity(tableIdent: QualifiedTableName, enableRowLevelSecurity: Boolean): Unit

Definition Classes
NativeTableRowLevelSecurityRelation → RowLevelSecurityRelation
final def eq(arg0: AnyRef): Boolean

Definition Classes
AnyRef
def executeUpdate(sql: String, defaultSchema: 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
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 getDeletePlan(relation: LogicalRelation, child: SparkPlan, keyColumns: Seq[Attribute]): SparkPlan

Get a spark plan to delete rows the relation.
Get a spark plan to delete rows the relation. The result of SparkPlan execution should be a count of number of updated rows.

Definition Classes
JDBCMutableRelation → MutableRelation
def getInsertPlan(relation: LogicalRelation, child: SparkPlan): SparkPlan

Get a spark plan for insert.
Get a spark plan for insert. The result of SparkPlan execution should be a count of number of inserted rows.

Definition Classes
JDBCMutableRelation → PlanInsertableRelation
def getKeyColumns: Seq[String]

Get the "key" columns for the table that need to be projected out by UPDATE and DELETE operations for affecting the selected rows.
Get the "key" columns for the table that need to be projected out by UPDATE and DELETE operations for affecting the selected rows.

Definition Classes
JDBCMutableRelation → MutableRelation
def getPrimaryKeyColumns: Seq[String]

Get primary keys of the row table
Get primary keys of the row table

Definition Classes
JDBCMutableRelation → MutableRelation
def getUpdatePlan(relation: LogicalRelation, child: SparkPlan, updateColumns: Seq[Attribute], updateExpressions: Seq[Expression], keyColumns: Seq[Attribute]): SparkPlan

Get a spark plan to update rows in the relation.
Get a spark plan to update rows in the relation. The result of SparkPlan execution should be a count of number of updated rows.

Definition Classes
JDBCMutableRelation → MutableRelation
def initializeLogIfNecessary(): 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, overwrite: Boolean): Unit

Definition Classes
JDBCMutableRelation → InsertableRelation
final def isDebugEnabled: Boolean

Attributes
protected
Definition Classes
Logging
final def isInfoEnabled: Boolean

Attributes
protected
Definition Classes
Logging
final def isInstanceOf[T0]: Boolean

Definition Classes
Any
def isPartitioned: Boolean
def isRowLevelSecurityEnabled: Boolean

Definition Classes
NativeTableRowLevelSecurityRelation → RowLevelSecurityRelation
final def isTraceEnabled: Boolean

Attributes
protected
Definition Classes
Logging
final var levelFlags: Int

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
final var log_: Logger

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
def numBuckets: Int
val origOptions: Map[String, String]
def partitionColumns: Seq[String]

Get the partitioning columns for the table, if any.
Get the partitioning columns for the table, if any.

Definition Classes
JDBCMutableRelation → MutableRelation
def partitionExpressions(relation: LogicalRelation): Seq[Expression]
val parts: Array[Partition]
val provider: String
def resetLogger(): Unit

Attributes
protected
Definition Classes
Logging
def resolvedName: String

Definition Classes
JDBCMutableRelation → RowLevelSecurityRelation
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 → NativeTableRowLevelSecurityRelation → BaseRelation
final def synchronized[T0](arg0: ⇒ T0): T0

Definition Classes
AnyRef
val table: String

Name of this mutable table as stored in catalog.
Name of this mutable table as stored in catalog.

Definition Classes
JDBCMutableRelation → NativeTableRowLevelSecurityRelation → MutableRelation
var tableCreated: Boolean

Return true if table is created by the relation.
Return true if table is created by the relation. This will be used to check while destroying the table incase of a failure while creating the table

Definition Classes
JDBCMutableRelation → DestroyRelation
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
def truncate(): Unit

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

Definition Classes
JDBCMutableRelation → DestroyRelation
def unhandledFilters(filters: Seq[Expression]): Seq[Expression]

Returns the list of Expressions that this datasource may not be able to handle.
Returns the list of Expressions that this datasource may not be able to handle. By default, this function will return all filters, as it is always safe to double evaluate an Expression.

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

Definition Classes
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( ... )
def withKeyColumns(relation: LogicalRelation, keyColumns: Seq[String]): LogicalRelation

If required inject the key columns in the original relation.
If required inject the key columns in the original relation.

Definition Classes
MutableRelation

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

def alterTable(tableIdent: QualifiedTableName, isAddColumn: Boolean, column: StructField): Unit

final def asInstanceOf[T0]: T0

def buildUnsafeScan(requiredColumns: Array[String], filters: Array[Expression]): (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

def enableOrDisableRowLevelSecurity(tableIdent: QualifiedTableName, enableRowLevelSecurity: Boolean): Unit

final def eq(arg0: AnyRef): Boolean

def executeUpdate(sql: String, defaultSchema: String): Int

def finalize(): Unit

final def getClass(): Class[_]

def getDeletePlan(relation: LogicalRelation, child: SparkPlan, keyColumns: Seq[Attribute]): SparkPlan

def getInsertPlan(relation: LogicalRelation, child: SparkPlan): SparkPlan

def getKeyColumns: Seq[String]

def getPrimaryKeyColumns: Seq[String]

def getUpdatePlan(relation: LogicalRelation, child: SparkPlan, updateColumns: Seq[Attribute], updateExpressions: Seq[Expression], keyColumns: Seq[Attribute]): SparkPlan

def initializeLogIfNecessary(): Unit

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

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

final def isDebugEnabled: Boolean

final def isInfoEnabled: Boolean

final def isInstanceOf[T0]: Boolean

def isPartitioned: Boolean

def isRowLevelSecurityEnabled: Boolean

final def isTraceEnabled: Boolean

final var levelFlags: Int

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

final var log_: Logger

val mode: SaveMode

final def ne(arg0: AnyRef): Boolean

val needConversion: Boolean

final def notify(): Unit

final def notifyAll(): Unit

def numBuckets: Int

val origOptions: Map[String, String]

def partitionColumns: Seq[String]

def partitionExpressions(relation: LogicalRelation): Seq[Expression]

val parts: Array[Partition]

val provider: String

def resetLogger(): Unit

def resolvedName: 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 tableCreated: Boolean

var tableExists: Boolean

def truncate(): Unit

def unhandledFilters(filters: Seq[Expression]): Seq[Expression]

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