class NotMatchedClauseBuilder extends AnyRef
Builder for a not matched clause. It provides APIs to build insert actions
- Since
0.7.0
- Alphabetic
- By Inheritance
- NotMatchedClauseBuilder
- AnyRef
- Any
- Hide All
- Show All
- Public
- Protected
Value Members
- 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
- final def asInstanceOf[T0]: T0
- Definition Classes
- Any
- def clone(): AnyRef
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.CloneNotSupportedException]) @HotSpotIntrinsicCandidate() @native()
- final def eq(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- def equals(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef → Any
- final def getClass(): Class[_ <: AnyRef]
- Definition Classes
- AnyRef → Any
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- def hashCode(): Int
- Definition Classes
- AnyRef → Any
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- 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
- Since
0.7.0
- 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
- Since
0.7.0
- 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
- Since
0.7.0
- final def isInstanceOf[T0]: Boolean
- Definition Classes
- Any
- final def ne(arg0: AnyRef): Boolean
- Definition Classes
- AnyRef
- final def notify(): Unit
- Definition Classes
- AnyRef
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- final def notifyAll(): Unit
- Definition Classes
- AnyRef
- Annotations
- @HotSpotIntrinsicCandidate() @native()
- final def synchronized[T0](arg0: => T0): T0
- Definition Classes
- AnyRef
- def toString(): String
- Definition Classes
- AnyRef → Any
- final def wait(arg0: Long, arg1: Int): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
- final def wait(arg0: Long): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException]) @native()
- final def wait(): Unit
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.InterruptedException])
Deprecated Value Members
- def finalize(): Unit
- Attributes
- protected[lang]
- Definition Classes
- AnyRef
- Annotations
- @throws(classOf[java.lang.Throwable]) @Deprecated
- Deprecated
(Since version 9)