c

com . snowflake . snowpark

MatchedClauseBuilder

class MatchedClauseBuilder extends AnyRef

Builder for a matched clause. It provides APIs to build update and delete actions

Since

0.7.0

Linear Supertypes
AnyRef , Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. MatchedClauseBuilder
  2. AnyRef
  3. 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. final def asInstanceOf [ T0 ] : T0
    Definition Classes
    Any
  5. def clone () : AnyRef
    Attributes
    protected[ lang ]
    Definition Classes
    AnyRef
    Annotations
    @throws ( ... ) @native () @HotSpotIntrinsicCandidate ()
  6. def delete () : MergeBuilder

    Defines a delete action for the matched clause, when a row in target is matched, delete it from target.

    Defines a delete action for the matched clause, when a row in target is matched, delete it from target. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenMatched.delete()

    Adds a matched clause where a row in target is matched if its id equals the id of a row in the DataFrame source. For all such rows, delete it from target.

    returns

    MergeBuilder

    Since

    0.7.0

  7. final def eq ( arg0: AnyRef ) : Boolean
    Definition Classes
    AnyRef
  8. def equals ( arg0: Any ) : Boolean
    Definition Classes
    AnyRef → Any
  9. final def getClass () : Class [_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  10. def hashCode () : Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  11. final def isInstanceOf [ T0 ] : Boolean
    Definition Classes
    Any
  12. final def ne ( arg0: AnyRef ) : Boolean
    Definition Classes
    AnyRef
  13. final def notify () : Unit
    Definition Classes
    AnyRef
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  14. final def notifyAll () : Unit
    Definition Classes
    AnyRef
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  15. final def synchronized [ T0 ] ( arg0: ⇒ T0 ) : T0
    Definition Classes
    AnyRef
  16. def toString () : String
    Definition Classes
    AnyRef → Any
  17. def update ( assignments: Map [ Column , Column ] ) : MergeBuilder

    Defines an update action for the matched clause, when a row in target is matched, update the row in target with <assignments>, where the key specifies column name and value specifies its assigned value.

    Defines an update action for the matched clause, when a row in target is matched, update the row in target with <assignments>, where the key specifies column name and value specifies its assigned value. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenMatched.update(Map(target("value") -> source("value")))

    Adds a matched clause where a row in target is matched if its id equals the id of a row in the DataFrame source. For all such rows, update its value to the value of the corresponding row in source.

    returns

    MergeBuilder

    Since

    0.7.0

  18. def update [ T ] ( assignments: Map [ String , Column ] ) ( implicit arg0: ClassTag [ T ] ) : MergeBuilder

    Defines an update action for the matched clause, when a row in target is matched, update the row in target with <assignments>, where the key specifies column name and value specifies its assigned value.

    Defines an update action for the matched clause, when a row in target is matched, update the row in target with <assignments>, where the key specifies column name and value specifies its assigned value. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenMatched.update(Map("value" -> source("value")))

    Adds a matched clause where a row in target is matched if its id equals the id of a row in the DataFrame source. For all such rows, update its value to the value of the corresponding row in source.

    returns

    MergeBuilder

    Since

    0.7.0

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

Deprecated Value Members

  1. def finalize () : Unit
    Attributes
    protected[ lang ]
    Definition Classes
    AnyRef
    Annotations
    @throws ( classOf[java.lang.Throwable] ) @Deprecated
    Deprecated

Inherited from AnyRef

Inherited from Any

transform

Ungrouped