CreateUnionRequest.Options (Kinetica Java API 7.2.3.0 API)

java.lang.Object
- com.gpudb.protocol.CreateUnionRequest.Options

Enclosing class:

CreateUnionRequest
```
public static final class CreateUnionRequest.Options
extends Object
```
A set of string constants for the CreateUnionRequest parameter options.
Optional parameters.

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`CHUNK_COLUMN_MAX_MEMORY` Indicates the target maximum data size for each column in a chunk to be used for this output table.
`static String`	`CHUNK_MAX_MEMORY` Indicates the target maximum data size for all columns in a chunk to be used for this output table.
`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` 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 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
  - CHUNK_COLUMN_MAX_MEMORY
```
public static final String CHUNK_COLUMN_MAX_MEMORY
```
    Indicates the target maximum data size for each column in a chunk to be used for this output table.
    
    See Also:
    
    Constant Field Values
  - CHUNK_MAX_MEMORY
```
public static final String CHUNK_MAX_MEMORY
```
    Indicates the target maximum data size for all columns in a 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

Class CreateUnionRequest.Options

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

CREATE_TEMP_TABLE

TRUE

FALSE

COLLECTION_NAME

MODE

UNION_ALL

UNION

UNION_DISTINCT

EXCEPT

EXCEPT_ALL

INTERSECT

INTERSECT_ALL

MERGE_VIEWS

CHUNK_SIZE

CHUNK_COLUMN_MAX_MEMORY

CHUNK_MAX_MEMORY

CREATE_INDEXES

TTL

PERSIST

VIEW_ID

FORCE_REPLICATED

STRATEGY_DEFINITION