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. Grouped
  2. Alphabetic
  3. 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