c

com . snowflake . snowpark

NotMatchedClauseBuilder

class NotMatchedClauseBuilder extends AnyRef

Builder for a not matched clause. It provides APIs to build insert actions

Since

0.7.0

Linear Supertypes
AnyRef , Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. NotMatchedClauseBuilder
  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. final def eq ( arg0: AnyRef ) : Boolean
    Definition Classes
    AnyRef
  7. def equals ( arg0: Any ) : Boolean
    Definition Classes
    AnyRef → Any
  8. final def getClass () : Class [_]
    Definition Classes
    AnyRef → Any
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  9. def hashCode () : Int
    Definition Classes
    AnyRef → Any
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  10. def insert ( assignments: Map [ Column , Column ] ) : MergeBuilder

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

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value. All unspecified columns are set to NULL. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenNotMatched.insert(Map(target("id") -> source("id")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id is assigned to the id of the not matched row.

    returns

    MergeBuilder

    Since

    0.7.0

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

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

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value. All unspecified columns are set to NULL. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenNotMatched.insert(Map("id" -> source("id")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id is assigned to the id of the not matched row.

    returns

    MergeBuilder

    Since

    0.7.0

  12. def insert ( values: Seq [ Column ] ) : MergeBuilder

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <values>.

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <values>. Returns an updated MergeBuilder with the new clause added.

    For example: 

    target.merge(source, target("id") === source("id"))
.whenNotMatched.insert(Seq(source("id"), source("value")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id and value are assigned to the id and value of the not matched row.

    Note: This API inserts into all columns in target with values, so the length of <values> must equal the number of columns in target.

    returns

    MergeBuilder

    Since

    0.7.0

  13. final def isInstanceOf [ T0 ] : Boolean
    Definition Classes
    Any
  14. final def ne ( arg0: AnyRef ) : Boolean
    Definition Classes
    AnyRef
  15. final def notify () : Unit
    Definition Classes
    AnyRef
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  16. final def notifyAll () : Unit
    Definition Classes
    AnyRef
    Annotations
    @native () @HotSpotIntrinsicCandidate ()
  17. final def synchronized [ T0 ] ( arg0: ⇒ T0 ) : T0
    Definition Classes
    AnyRef
  18. def toString () : String
    Definition Classes
    AnyRef → Any
  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