com.gpudb.protocol

Class CreateUnionRequest.Options

java.lang.Object

com.gpudb.protocol.CreateUnionRequest.Options

Enclosing class:

CreateUnionRequest

public static final class CreateUnionRequest.Options
extends Object

Optional parameters.

• CREATE_TEMP_TABLE: If true, a unique temporary table name will be generated in the sys_temp schema and used in place of tableName. If persist is false (or unspecified), then this is always allowed even if the caller does not have permission to create tables. The generated name is returned in qualified_table_name. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• COLLECTION_NAME: [DEPRECATED--please specify the containing schema for the projection as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of the schema for the output table. If the schema provided is non-existent, it will be automatically created. The default value is ''.
• MODE: If merge_views, then this operation will merge the provided views. All tableNames must be views from the same underlying base table. Supported values:
  • UNION_ALL: Retains all rows from the specified tables.
  • UNION: Retains all unique rows from the specified tables (synonym for union_distinct).
  • UNION_DISTINCT: Retains all unique rows from the specified tables.
  • EXCEPT: Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).
  • EXCEPT_ALL: Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).
  • INTERSECT: Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
  • INTERSECT_ALL: Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).
  • MERGE_VIEWS: Merge two or more views (or views of views) of the same base data set into a new view. If this mode is selected inputColumnNames AND outputColumnNames must be empty. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 20' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 20 OR x <= 10'.
  The default value is UNION_ALL.
• CHUNK_SIZE: Indicates the number of records per chunk to be used for this output table.
• CREATE_INDEXES: Comma-separated list of columns on which to create indexes on the output table. The columns specified must be present in outputColumnNames.
• TTL: Sets the TTL of the output table specified in tableName.
• PERSIST: If true, then the output table specified in tableName will be persisted and will not expire unless a ttl is specified. If false, then the output table will be an in-memory table and will expire unless a ttl is specified otherwise. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• VIEW_ID: ID of view of which this output table is a member. The default value is ''.
• FORCE_REPLICATED: If true, then the output table specified in tableName will be replicated even if the source tables are not. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• STRATEGY_DEFINITION: The tier strategy for the table and its columns.

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	CHUNK_SIZE Indicates the number of records per chunk to be used for this output table.
static String	COLLECTION_NAME [DEPRECATED--please specify the containing schema for the projection as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of the schema for the output table.
static String	CREATE_INDEXES Comma-separated list of columns on which to create indexes on the output table.
static String	CREATE_TEMP_TABLE If true, a unique temporary table name will be generated in the sys_temp schema and used in place of tableName.
static String	EXCEPT Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).
static String	EXCEPT_ALL Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).
static String	FALSE
static String	FORCE_REPLICATED If true, then the output table specified in tableName will be replicated even if the source tables are not.
static String	INTERSECT Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
static String	INTERSECT_ALL Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).
static String	MERGE_VIEWS Merge two or more views (or views of views) of the same base data set into a new view.
static String	MODE If merge_views, then this operation will merge the provided views.
static String	PERSIST If true, then the output table specified in tableName will be persisted and will not expire unless a ttl is specified.
static String	STRATEGY_DEFINITION The	static String	TRUE
static String	TTL Sets the	static String	UNION Retains all unique rows from the specified tables (synonym for union_distinct).
static String	UNION_ALL Retains all rows from the specified tables.
static String	UNION_DISTINCT Retains all unique rows from the specified tables.
static String	VIEW_ID ID of view of which this output table is a member.

Method Summary

Methods inherited from class java.lang.Object

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

Field Detail

CREATE_TEMP_TABLE

public static final String CREATE_TEMP_TABLE

If true, a unique temporary table name will be generated in the sys_temp schema and used in place of tableName. If persist is false (or unspecified), then this is always allowed even if the caller does not have permission to create tables. The generated name is returned in qualified_table_name. 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

COLLECTION_NAME

public static final String COLLECTION_NAME

[DEPRECATED--please specify the containing schema for the projection as part of tableName and use GPUdb.createSchema(CreateSchemaRequest) to create the schema if non-existent] Name of the schema for the output table. If the schema provided is non-existent, it will be automatically created. The default value is ''.

See Also:

Constant Field Values

MODE

public static final String MODE

If merge_views, then this operation will merge the provided views. All tableNames must be views from the same underlying base table. Supported values:

• UNION_ALL: Retains all rows from the specified tables.
• UNION: Retains all unique rows from the specified tables (synonym for union_distinct).
• UNION_DISTINCT: Retains all unique rows from the specified tables.
• EXCEPT: Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).
• EXCEPT_ALL: Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).
• INTERSECT: Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
• INTERSECT_ALL: Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).
• MERGE_VIEWS: Merge two or more views (or views of views) of the same base data set into a new view. If this mode is selected inputColumnNames AND outputColumnNames must be empty. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 20' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 20 OR x <= 10'.

The default value is UNION_ALL.

See Also:

Constant Field Values

UNION_ALL

public static final String UNION_ALL

Retains all rows from the specified tables.

See Also:

Constant Field Values

UNION

public static final String UNION

Retains all unique rows from the specified tables (synonym for union_distinct).

See Also:

Constant Field Values

UNION_DISTINCT

public static final String UNION_DISTINCT

Retains all unique rows from the specified tables.

See Also:

Constant Field Values

EXCEPT

public static final String EXCEPT

Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).

See Also:

Constant Field Values

EXCEPT_ALL

public static final String EXCEPT_ALL

Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).

See Also:

Constant Field Values

INTERSECT

public static final String INTERSECT

Retains all unique rows that appear in both of the specified tables (only works on 2 tables).

See Also:

Constant Field Values

INTERSECT_ALL

public static final String INTERSECT_ALL

Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).

See Also:

Constant Field Values

MERGE_VIEWS

public static final String MERGE_VIEWS

Merge two or more views (or views of views) of the same base data set into a new view. If this mode is selected inputColumnNames AND outputColumnNames must be empty. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 20' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 20 OR x <= 10'.

See Also:

Constant Field Values

CHUNK_SIZE

public static final String CHUNK_SIZE

Indicates the number of records per chunk to be used for this output table.

See Also:

Constant Field Values

CREATE_INDEXES

public static final String CREATE_INDEXES

Comma-separated list of columns on which to create indexes on the output table. The columns specified must be present in outputColumnNames.

See Also:

Constant Field Values

TTL

public static final String TTL

Sets the TTL of the output table specified in tableName.

See Also:

Constant Field Values

PERSIST

public static final String PERSIST

If true, then the output table specified in tableName will be persisted and will not expire unless a ttl is specified. If false, then the output table will be an in-memory table and will expire unless a ttl is specified otherwise. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

VIEW_ID

public static final String VIEW_ID

ID of view of which this output table is a member. The default value is ''.

See Also:

Constant Field Values

FORCE_REPLICATED

public static final String FORCE_REPLICATED

If true, then the output table specified in tableName will be replicated even if the source tables are not. Supported values:

• TRUE
• FALSE

The default value is FALSE.

See Also:

Constant Field Values

STRATEGY_DEFINITION

public static final String STRATEGY_DEFINITION

The tier strategy for the table and its columns.

See Also:

Constant Field Values