Delta Lake 0.4.0 ScalaDoc - io.delta.tables.DeltaTable

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 alias(alias: String): DeltaTable

:: Evolving ::

Apply an alias to the DeltaTable. This is similar to Dataset.as(alias) or SQL tableName AS alias.

Annotations: @Evolving()
Since: 0.3.0

def as(alias: String): DeltaTable

:: Evolving ::

Apply an alias to the DeltaTable. This is similar to Dataset.as(alias) or SQL tableName AS alias.

Annotations: @Evolving()
Since: 0.3.0

final def asInstanceOf[T0]: T0

Definition Classes: Any

def clone(): AnyRef

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

def delete(): Unit

:: Evolving ::

Delete data from the table.

Annotations: @Evolving()
Since: 0.3.0

def delete(condition: Column): Unit

:: Evolving ::

Delete data from the table that match the given condition.

condition: Boolean SQL expression

Annotations: @Evolving()
Since: 0.3.0

def delete(condition: String): Unit

:: Evolving ::

Delete data from the table that match the given condition.

condition: Boolean SQL expression

Annotations: @Evolving()
Since: 0.3.0

final def eq(arg0: AnyRef): Boolean

Definition Classes: AnyRef

def equals(arg0: Any): Boolean

Definition Classes: AnyRef → Any

def executeDelete(condition: Option[Expression]): Unit

Attributes: protected
Definition Classes: DeltaTableOperations

def executeHistory(deltaLog: DeltaLog, limit: Option[Int]): DataFrame

Attributes: protected
Definition Classes: DeltaTableOperations

def executeUpdate(set: Map[String, Column], condition: Option[Column]): Unit

Attributes: protected
Definition Classes: DeltaTableOperations

def executeVacuum(deltaLog: DeltaLog, retentionHours: Option[Double]): DataFrame

Attributes: protected
Definition Classes: DeltaTableOperations

def finalize(): Unit

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

final def getClass(): Class[_]

Definition Classes: AnyRef → Any
Annotations: @native()

def hashCode(): Int

Definition Classes: AnyRef → Any
Annotations: @native()

def history(): DataFrame

:: Evolving ::

Get the information available commits on this table as a Spark DataFrame. The information is in reverse chronological order.

Annotations: @Evolving()
Since: 0.3.0

def history(limit: Int): DataFrame

:: Evolving ::

Get the information of the latest limit commits on this table as a Spark DataFrame. The information is in reverse chronological order.

limit: The number of previous commands to get history for

Annotations: @Evolving()
Since: 0.3.0

final def isInstanceOf[T0]: Boolean

Definition Classes: Any

def makeUpdateTable(target: DeltaTable, onCondition: Option[Column], setColumns: Seq[(String, Column)]): UpdateTable

Attributes: protected
Definition Classes: DeltaTableOperations

def merge(source: DataFrame, condition: Column): DeltaMergeBuilder

:: Evolving ::

Merge data from the source DataFrame based on the given merge condition. This returns a DeltaMergeBuilder object that can be used to specify the update, delete, or insert actions to be performed on rows based on whether the rows matched the condition or not.

See the DeltaMergeBuilder for a full description of this operation and what combinations of update, delete and insert operations are allowed.

Scala example to update a key-value Delta table with new key-values from a source DataFrame:

deltaTable
 .as("target")
 .merge(
   source.as("source"),
   "target.key = source.key")
 .whenMatched
 .updateExpr(Map(
   "value" -> "source.value"))
 .whenNotMatched
 .insertExpr(Map(
   "key" -> "source.key",
   "value" -> "source.value"))
 .execute()

Java example to update a key-value Delta table with new key-values from a source DataFrame:

deltaTable
 .as("target")
 .merge(
   source.as("source"),
   "target.key = source.key")
 .whenMatched
 .updateExpr(
    new HashMap<String, String>() {{
      put("value" -> "source.value")
    }})
 .whenNotMatched
 .insertExpr(
    new HashMap<String, String>() {{
     put("key", "source.key");
     put("value", "source.value");
   }})
 .execute()

source: source Dataframe to be merged.
condition: boolean expression as a Column object

Annotations: @Evolving()
Since: 0.3.0

def merge(source: DataFrame, condition: String): DeltaMergeBuilder

:: Evolving ::

Merge data from the source DataFrame based on the given merge condition. This returns a DeltaMergeBuilder object that can be used to specify the update, delete, or insert actions to be performed on rows based on whether the rows matched the condition or not.

See the DeltaMergeBuilder for a full description of this operation and what combinations of update, delete and insert operations are allowed.

Scala example to update a key-value Delta table with new key-values from a source DataFrame:

deltaTable
 .as("target")
 .merge(
   source.as("source"),
   "target.key = source.key")
 .whenMatched
 .updateExpr(Map(
   "value" -> "source.value"))
 .whenNotMatched
 .insertExpr(Map(
   "key" -> "source.key",
   "value" -> "source.value"))
 .execute()

Java example to update a key-value Delta table with new key-values from a source DataFrame:

deltaTable
 .as("target")
 .merge(
   source.as("source"),
   "target.key = source.key")
 .whenMatched
 .updateExpr(
    new HashMap<String, String>() {{
      put("value" -> "source.value");
    }})
 .whenNotMatched
 .insertExpr(
    new HashMap<String, String>() {{
     put("key", "source.key");
     put("value", "source.value");
   }})
 .execute();

source: source Dataframe to be merged.
condition: boolean expression as SQL formatted string

Annotations: @Evolving()
Since: 0.3.0

final def ne(arg0: AnyRef): Boolean

Definition Classes: AnyRef

final def notify(): Unit

Definition Classes: AnyRef
Annotations: @native()

final def notifyAll(): Unit

Definition Classes: AnyRef
Annotations: @native()

def sparkSession: SparkSession

Attributes: protected
Definition Classes: DeltaTableOperations

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

Definition Classes: AnyRef

def toDF: Dataset[Row]

:: Evolving ::

Get a DataFrame (that is, Dataset[Row]) representation of this Delta table.

Annotations: @Evolving()
Since: 0.3.0

def toStrColumnMap(map: Map[String, String]): Map[String, Column]

Attributes: protected
Definition Classes: DeltaTableOperations

def toString(): String

Definition Classes: AnyRef → Any

def tryResolveReferences(sparkSession: SparkSession)(expr: Expression, planContainingExpr: LogicalPlan): Expression

Attributes: protected
Definition Classes: AnalysisHelper

def update(condition: Column, set: Map[String, Column]): Unit

:: Evolving ::

Update data from the table on the rows that match the given condition based on the rules defined by set.

Java example to increment the column data.

import org.apache.spark.sql.Column;
import org.apache.spark.sql.functions;

deltaTable.update(
  functions.col("date").gt("2018-01-01"),
  new HashMap<String, Column>() {{
    put("data", functions.col("data").plus(1));
  }}
);

condition: boolean expression as Column object specifying which rows to update.
set: rules to update a row as a Java map between target column names and corresponding update expressions as Column objects.

Annotations: @Evolving()
Since: 0.3.0

def update(condition: Column, set: Map[String, Column]): Unit

:: Evolving ::

Update data from the table on the rows that match the given condition based on the rules defined by set.

Scala example to increment the column data.

import org.apache.spark.sql.functions._

deltaTable.update(
  col("date") > "2018-01-01",
  Map("data" -> col("data") + 1))

condition: boolean expression as Column object specifying which rows to update.
set: rules to update a row as a Scala map between target column names and corresponding update expressions as Column objects.

Annotations: @Evolving()
Since: 0.3.0

def update(set: Map[String, Column]): Unit

:: Evolving ::

Update rows in the table based on the rules defined by set.

Java example to increment the column data.

import org.apache.spark.sql.Column;
import org.apache.spark.sql.functions;

deltaTable.update(
  new HashMap<String, Column>() {{
    put("data", functions.col("data").plus(1));
  }}
);

set: rules to update a row as a Java map between target column names and corresponding update expressions as Column objects.

Annotations: @Evolving()
Since: 0.3.0

def update(set: Map[String, Column]): Unit

:: Evolving ::

Update rows in the table based on the rules defined by set.

Scala example to increment the column data.

import org.apache.spark.sql.functions._

deltaTable.update(Map("data" -> col("data") + 1))

set: rules to update a row as a Scala map between target column names and corresponding update expressions as Column objects.

Annotations: @Evolving()
Since: 0.3.0

def updateExpr(condition: String, set: Map[String, String]): Unit

:: Evolving ::

Update data from the table on the rows that match the given condition, which performs the rules defined by set.

Java example to increment the column data.

deltaTable.update(
  "date > '2018-01-01'",
  new HashMap<String, String>() {{
    put("data", "data + 1");
  }}
);

condition: boolean expression as SQL formatted string object specifying which rows to update.
set: rules to update a row as a Java map between target column names and corresponding update expressions as SQL formatted strings.

Annotations: @Evolving()
Since: 0.3.0

def updateExpr(condition: String, set: Map[String, String]): Unit

:: Evolving ::

Update data from the table on the rows that match the given condition, which performs the rules defined by set.

Scala example to increment the column data.

deltaTable.update(
  "date > '2018-01-01'",
  Map("data" -> "data + 1"))

condition: boolean expression as SQL formatted string object specifying which rows to update.
set: rules to update a row as a Scala map between target column names and corresponding update expressions as SQL formatted strings.

Annotations: @Evolving()
Since: 0.3.0

def updateExpr(set: Map[String, String]): Unit

:: Evolving ::

Update rows in the table based on the rules defined by set.

Java example to increment the column data.

deltaTable.updateExpr(
  new HashMap<String, String>() {{
    put("data", "data + 1");
  }}
);

set: rules to update a row as a Java map between target column names and corresponding update expressions as SQL formatted strings.

Annotations: @Evolving()
Since: 0.3.0

def updateExpr(set: Map[String, String]): Unit

:: Evolving ::

Update rows in the table based on the rules defined by set.

Scala example to increment the column data.

deltaTable.updateExpr(Map("data" -> "data + 1")))

set: rules to update a row as a Scala map between target column names and corresponding update expressions as SQL formatted strings.

Annotations: @Evolving()
Since: 0.3.0

def vacuum(): DataFrame

:: Evolving ::

Recursively delete files and directories in the table that are not needed by the table for maintaining older versions up to the given retention threshold. This method will return an empty DataFrame on successful completion.

note: This will use the default retention period of 7 days.

Annotations: @Evolving()
Since: 0.3.0

def vacuum(retentionHours: Double): DataFrame

:: Evolving ::

Recursively delete files and directories in the table that are not needed by the table for maintaining older versions up to the given retention threshold. This method will return an empty DataFrame on successful completion.

retentionHours: The retention threshold in hours. Files required by the table for reading versions earlier than this will be preserved and the rest of them will be deleted.

Annotations: @Evolving()
Since: 0.3.0

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: @native() @throws( ... )

Packages

DeltaTable

Companion object DeltaTable

class DeltaTable extends DeltaTableOperations

Value Members

Inherited from DeltaTableOperations

Inherited from AnalysisHelper

Inherited from AnyRef

Inherited from Any

Ungrouped

Packages

DeltaTable 

Companion object DeltaTable

class DeltaTable extends DeltaTableOperations

Value Members

Inherited from DeltaTableOperations

Inherited from AnalysisHelper

Inherited from AnyRef

Inherited from Any

Ungrouped

DeltaTable