CreateUnionRequest.Options (Kinetica Java API 6.0.1 API)

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

Enclosing class:

CreateUnionRequest
```
public static final class CreateUnionRequest.Options
extends Object
```
Optional parameters.
- COLLECTION_NAME: Name of a collection which is to contain the union. If the collection provided is non-existent, the collection will be automatically created. If empty, then the union will be a top-level table.
- MATERIALIZE_ON_GPU: If 'true' then the columns of the union will be cached on the GPU. Supported values:
  - TRUE
  - FALSE
  The default value is FALSE.
- MODE: If 'merge_views' then this operation will merge (i.e. union) the provided views. All 'table_names' 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).
  - INTERSECT: Retains all unique rows 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. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 10' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 10 OR x <= 10'.
  The default value is UNION_ALL.
- TTL: Sets the TTL of the table specified in tableName. The value must be the desired TTL in minutes.
- PERSIST: If true then the union will be persisted as a regular table (it will not be automatically cleared unless a ttl is provided, and the table data can be modified in subsequent operations). If false then the union will be a read-only, memory-only temporary table. Supported values:
  - TRUE
  - FALSE
  The default value is FALSE.
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 which is to contain the union.
`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`	`FALSE`
`static String`	`INTERSECT` Retains all unique rows that appear in both of the specified tables (only works on 2 tables).
`static String`	`MATERIALIZE_ON_GPU` If 'true' then the columns of the union will be cached on the GPU.
`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 (i.e.
`static String`	`PERSIST` If `true` then the union will be persisted as a regular table (it will not be automatically cleared unless a `ttl` is provided, and the table data can be modified in subsequent operations).
`static String`	`TRUE`
`static String`	`TTL` Sets the TTL of the table specified in `tableName`.
`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.

Method Summary
- Methods inherited from class java.lang.Object
  clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

- Field Detail
  - COLLECTION_NAME
```
public static final String COLLECTION_NAME
```
    Name of a collection which is to contain the union. If the collection provided is non-existent, the collection will be automatically created. If empty, then the union will be a top-level table.
    
    See Also:
    Constant Field Values
  - MATERIALIZE_ON_GPU
```
public static final String MATERIALIZE_ON_GPU
```
    If 'true' then the columns of the union will be cached on the GPU. 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
  - MODE
```
public static final String MODE
```
    If 'merge_views' then this operation will merge (i.e. union) the provided views. All 'table_names' 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).
    - INTERSECT: Retains all unique rows 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. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 10' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 10 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
  - 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
  - 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. The resulting view would match the results of a SQL OR operation, e.g., if filter 1 creates a view using the expression 'x = 10' and filter 2 creates a view using the expression 'x <= 10', then the merge views operation creates a new view using the expression 'x = 10 OR x <= 10'.
    
    See Also:
    Constant Field Values
  - TTL
```
public static final String TTL
```
    Sets the TTL of the table specified in tableName. The value must be the desired TTL in minutes.
    
    See Also:
    Constant Field Values
  - PERSIST
```
public static final String PERSIST
```
    If true then the union will be persisted as a regular table (it will not be automatically cleared unless a ttl is provided, and the table data can be modified in subsequent operations). If false then the union will be a read-only, memory-only temporary table. Supported values:
    - TRUE
    - FALSE
    The default value is FALSE.
    See Also:
    Constant Field Values

Class CreateUnionRequest.Options

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

COLLECTION_NAME

MATERIALIZE_ON_GPU

TRUE

FALSE

MODE

UNION_ALL

UNION

UNION_DISTINCT

EXCEPT

INTERSECT

MERGE_VIEWS

TTL

PERSIST