com.gpudb.protocol

Class CreateTableRequest.Options

java.lang.Object

com.gpudb.protocol.CreateTableRequest.Options

Enclosing class:

CreateTableRequest

public static final class CreateTableRequest.Options
extends Object

Optional parameters.

• no_error_if_exists: If true, prevents an error from occurring if the table already exists and is of the given type. If a table with the same ID but a different type exists, it is still an error. Values: true, false.
  
  
• collection_name: Name of a collection in GPUdb to which the newly created table is to be assigned as a child table. If empty, then the newly created table will be a top level table. If the collection does not allow duplicate children, then this table creation request will fail if there is an existing child table with the same type id specified in this request.
  
• is_collection: Indicates whether the new table to be created will be a collection. If false, the created table will be a top level table. Values: true, false.
  
  
• disallow_homogeneous_tables: For a collection, indicates whether multiple children of exactly the same data type will be allowed. Values: true, false.
  
  
• is_replicated: For a Table, this is an indication to GPUdb to replicate the table to all the ranks. This is only required when the table will be used to join with other tables in a query. Values: true, false.
  
  
• foreign_keys: Semicolon-separated list of foreign key constraints, of the format 'my_field references primary_table(primary_key_field)'.
  

A set of string constants for the parameter options.

Field Summary

Fields

Modifier and Type	Field and Description
static String	COLLECTION_NAME Name of a collection in GPUdb to which the newly created table is to be assigned as a child table.
static String	DISALLOW_HOMOGENEOUS_TABLES For a collection, indicates whether multiple children of exactly the same data type will be allowed.
static String	FALSE
static String	FOREIGN_KEYS Semicolon-separated list of foreign key constraints, of the format 'my_field references primary_table(primary_key_field)'.
static String	IS_COLLECTION Indicates whether the new table to be created will be a collection.
static String	IS_REPLICATED For a Table, this is an indication to GPUdb to replicate the table to all the ranks.
static String	NO_ERROR_IF_EXISTS If true, prevents an error from occurring if the table already exists and is of the given type.
static String	TRUE

Method Summary

Methods inherited from class java.lang.Object

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

Field Detail

NO_ERROR_IF_EXISTS

public static final String NO_ERROR_IF_EXISTS

If true, prevents an error from occurring if the table already exists and is of the given type. If a table with the same ID but a different type exists, it is still an error. Values: true, 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

COLLECTION_NAME

public static final String COLLECTION_NAME

Name of a collection in GPUdb to which the newly created table is to be assigned as a child table. If empty, then the newly created table will be a top level table. If the collection does not allow duplicate children, then this table creation request will fail if there is an existing child table with the same type id specified in this request.

See Also:

Constant Field Values

IS_COLLECTION

public static final String IS_COLLECTION

Indicates whether the new table to be created will be a collection. If false, the created table will be a top level table. Values: true, false.

See Also:

Constant Field Values

DISALLOW_HOMOGENEOUS_TABLES

public static final String DISALLOW_HOMOGENEOUS_TABLES

For a collection, indicates whether multiple children of exactly the same data type will be allowed. Values: true, false.

See Also:

Constant Field Values

IS_REPLICATED

public static final String IS_REPLICATED

For a Table, this is an indication to GPUdb to replicate the table to all the ranks. This is only required when the table will be used to join with other tables in a query. Values: true, false.

See Also:

Constant Field Values

FOREIGN_KEYS

public static final String FOREIGN_KEYS

Semicolon-separated list of foreign key constraints, of the format 'my_field references primary_table(primary_key_field)'.

See Also:

Constant Field Values