com.gpudb.protocol

Class UpdateRecordsRequest.Options

java.lang.Object

com.gpudb.protocol.UpdateRecordsRequest.Options

Enclosing class:

UpdateRecordsRequest<T>

public static final class UpdateRecordsRequest.Options
extends Object

Optional parameters.

• GLOBAL_EXPRESSION: An optional global expression to reduce the search space of the predicates listed in expressions. The default value is ''.
• BYPASS_SAFETY_CHECKS: When set to true, all predicates are available for primary key updates. Keep in mind that it is possible to destroy data in this case, since a single predicate may match multiple objects (potentially all of records of a table), and then updating all of those records to have the same primary key will, due to the primary key uniqueness constraints, effectively delete all but one of those updated records. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• UPDATE_ON_EXISTING_PK: Specifies the record collision policy for tables with a primary key when updating columns of the primary key or inserting new records. If true, existing records with primary key values that match those of a record being updated or inserted will be replaced by the updated and new records. If false, existing records with matching primary key values will remain unchanged, and the updated or new records with primary key values that match those of existing records will be discarded. If the specified table does not have a primary key, then this option has no effect. Supported values:
  • TRUE: Overwrite existing records when updated and inserted records have the same primary keys
  • FALSE: Discard updated and inserted records when the same primary keys already exist
  The default value is FALSE.
• UPDATE_PARTITION: Force qualifying records to be deleted and reinserted so their partition membership will be reevaluated. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• TRUNCATE_STRINGS: If set to true, any strings which are too long for their charN string fields will be truncated to fit. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• USE_EXPRESSIONS_IN_NEW_VALUES_MAPS: When set to true, all new values in newValuesMaps are considered as expression values. When set to false, all new values in newValuesMaps are considered as constants. NOTE: When true, string constants will need to be quoted to avoid being evaluated as expressions. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• RECORD_ID: ID of a single record to be updated (returned in the call to GPUdb.insertRecords(InsertRecordsRequest) or GPUdb.getRecordsFromCollection(Object, GetRecordsFromCollectionRequest)).

The default value is an empty Map. A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	BYPASS_SAFETY_CHECKS When set to true, all predicates are available for primary key updates.
static String	FALSE
static String	GLOBAL_EXPRESSION An optional global expression to reduce the search space of the predicates listed in expressions.
static String	RECORD_ID ID of a single record to be updated (returned in the call to GPUdb.insertRecords(InsertRecordsRequest) or GPUdb.getRecordsFromCollection(Object, GetRecordsFromCollectionRequest)).
static String	TRUE
static String	TRUNCATE_STRINGS If set to true, any strings which are too long for their charN string fields will be truncated to fit.
static String	UPDATE_ON_EXISTING_PK Specifies the record collision policy for tables with a primary key when updating columns of the primary key or inserting new records.
static String	UPDATE_PARTITION Force qualifying records to be deleted and reinserted so their partition membership will be reevaluated.
static String	USE_EXPRESSIONS_IN_NEW_VALUES_MAPS When set to true, all new values in newValuesMaps are considered as expression values.

Method Summary

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

GLOBAL_EXPRESSION

public static final String GLOBAL_EXPRESSION

An optional global expression to reduce the search space of the predicates listed in expressions. The default value is ''.

See Also:

Constant Field Values

BYPASS_SAFETY_CHECKS

public static final String BYPASS_SAFETY_CHECKS

When set to true, all predicates are available for primary key updates. Keep in mind that it is possible to destroy data in this case, since a single predicate may match multiple objects (potentially all of records of a table), and then updating all of those records to have the same primary key will, due to the primary key uniqueness constraints, effectively delete all but one of those updated records. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

TRUE

public static final String TRUE

See Also:

Constant Field Values

FALSE

public static final String FALSE

See Also:

Constant Field Values

UPDATE_ON_EXISTING_PK

public static final String UPDATE_ON_EXISTING_PK

Specifies the record collision policy for tables with a primary key when updating columns of the primary key or inserting new records. If true, existing records with primary key values that match those of a record being updated or inserted will be replaced by the updated and new records. If false, existing records with matching primary key values will remain unchanged, and the updated or new records with primary key values that match those of existing records will be discarded. If the specified table does not have a primary key, then this option has no effect. Supported values:

• TRUE: Overwrite existing records when updated and inserted records have the same primary keys
• FALSE: Discard updated and inserted records when the same primary keys already exist

The default value is FALSE.

See Also:

Constant Field Values

UPDATE_PARTITION

public static final String UPDATE_PARTITION

Force qualifying records to be deleted and reinserted so their partition membership will be reevaluated. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

TRUNCATE_STRINGS

public static final String TRUNCATE_STRINGS

If set to true, any strings which are too long for their charN string fields will be truncated to fit. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

USE_EXPRESSIONS_IN_NEW_VALUES_MAPS

public static final String USE_EXPRESSIONS_IN_NEW_VALUES_MAPS

When set to true, all new values in newValuesMaps are considered as expression values. When set to false, all new values in newValuesMaps are considered as constants. NOTE: When true, string constants will need to be quoted to avoid being evaluated as expressions. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

RECORD_ID

public static final String RECORD_ID

ID of a single record to be updated (returned in the call to GPUdb.insertRecords(InsertRecordsRequest) or GPUdb.getRecordsFromCollection(Object, GetRecordsFromCollectionRequest)).

See Also:

Constant Field Values