tableUpsert

swordfish.function.tableUpsert()

Insert rows into a table if the values with the key do not already exist, or update them if they do.

参数:

• obj (Constant) -- A keyed table, indexed table, or a DFS table.

• newData (Constant) -- An in-memory table.

• ignoreNull (Constant, optional) -- A Boolean value, by default DFLT. If set to true, for the null values in newData, the corresponding elements in obj are not updated.

• keyColNames (Constant, optional) -- A STRING scalar/vector, by default DFLT. When obj is a DFS table, keyColNames are considered as the key columns.

• sortColumns (Constant, optional) --

  A STRING scalar or vector, by default DFLT. The updated partitions will be sorted on sortColumns (only within each partition, not across partitions).

  备注

  • sortColumns is supported in upser_ only with the OLAP engine.

  • To specify sortColumns, obj must be a DFS table.

  • When obj is an empty table, setting sortColumns has no effect. That is, the system will not sort the inserted data.

返回:

A LONG pair. The first element represents the number of inserted records, and the second represents the number of updated records.

返回类型:

Constant