Packages

class DeltaTable extends DeltaTableOperations

:: Evolving ::

Main class for programmatically interacting with Delta tables. You can create DeltaTable instances using the static methods.

DeltaTable.forPath(sparkSession, pathToTheDeltaTable)
Annotations
@Evolving()
Since

0.3.0

Linear Supertypes
DeltaTableOperations, AnalysisHelper, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. DeltaTable
  2. DeltaTableOperations
  3. AnalysisHelper
  4. AnyRef
  5. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Value Members

  1. final def !=(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  4. def alias(alias: String): DeltaTable

    :: Evolving ::

    :: 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

  5. def as(alias: String): DeltaTable

    :: Evolving ::

    :: 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

  6. final def asInstanceOf[T0]: T0
    Definition Classes
    Any
  7. def clone(): AnyRef
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @native() @throws( ... )
  8. def delete(): Unit

    :: Evolving ::

    :: Evolving ::

    Delete data from the table.

    Annotations
    @Evolving()
    Since

    0.3.0

  9. def delete(condition: Column): Unit

    :: Evolving ::

    :: Evolving ::

    Delete data from the table that match the given condition.

    condition

    Boolean SQL expression

    Annotations
    @Evolving()
    Since

    0.3.0

  10. def delete(condition: String): Unit

    :: Evolving ::

    :: Evolving ::

    Delete data from the table that match the given condition.

    condition

    Boolean SQL expression

    Annotations
    @Evolving()
    Since

    0.3.0

  11. final def eq(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  12. def equals(arg0: Any): Boolean
    Definition Classes
    AnyRef → Any
  13. def executeDelete(condition: Option[Expression]): Unit
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  14. def executeHistory(deltaLog: DeltaLog, limit: Option[Int]): DataFrame
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  15. def executeUpdate(set: Map[String, Column], condition: Option[Column]): Unit
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  16. def executeVacuum(deltaLog: DeltaLog, retentionHours: Option[Double]): DataFrame
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  17. def finalize(): Unit
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  18. final def getClass(): Class[_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  19. def hashCode(): Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native()
  20. def history(): DataFrame

    :: Evolving ::

    :: 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

  21. def history(limit: Int): DataFrame

    :: Evolving ::

    :: 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

  22. final def isInstanceOf[T0]: Boolean
    Definition Classes
    Any
  23. def makeUpdateTable(target: DeltaTable, onCondition: Option[Column], setColumns: Seq[(String, Column)]): UpdateTable
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  24. def merge(source: DataFrame, condition: Column): DeltaMergeBuilder

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

  26. final def ne(arg0: AnyRef): Boolean
    Definition Classes
    AnyRef
  27. final def notify(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  28. final def notifyAll(): Unit
    Definition Classes
    AnyRef
    Annotations
    @native()
  29. def sparkSession: SparkSession
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  30. final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
    AnyRef
  31. def toDF: Dataset[Row]

    :: Evolving ::

    :: Evolving ::

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

    Annotations
    @Evolving()
    Since

    0.3.0

  32. def toStrColumnMap(map: Map[String, String]): Map[String, Column]
    Attributes
    protected
    Definition Classes
    DeltaTableOperations
  33. def toString(): String
    Definition Classes
    AnyRef → Any
  34. def tryResolveReferences(sparkSession: SparkSession)(expr: Expression, planContainingExpr: LogicalPlan): Expression
    Attributes
    protected
    Definition Classes
    AnalysisHelper
  35. def update(condition: Column, set: Map[String, Column]): Unit

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

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

    :: Evolving ::

    :: 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

  43. def vacuum(): DataFrame

    :: Evolving ::

    :: 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

  44. def vacuum(retentionHours: Double): DataFrame

    :: Evolving ::

    :: 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

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

Inherited from DeltaTableOperations

Inherited from AnalysisHelper

Inherited from AnyRef

Inherited from Any

Ungrouped