CreateProjectionRequest.Options (Kinetica Java API 6.0.1 API)

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

Enclosing class:

CreateProjectionRequest
```
public static final class CreateProjectionRequest.Options
extends Object
```
Optional parameters.
- COLLECTION_NAME: Name of a collection to which the projection is to be assigned as a child. If the collection provided is non-existent, the collection will be automatically created.
- EXPRESSION: An optional filter expression to be applied to the source table prior to the projection.
- LIMIT: The number of records to keep.
- ORDER_BY: Comma-separated list of the columns to be sorted by; e.g. 'timestamp asc, x desc'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.
- MATERIALIZE_ON_GPU: If true then the columns of the projection will be cached on the GPU. Supported values:
  - TRUE
  - FALSE
  The default value is FALSE.
- TTL: Sets the TTL of the table, view, or collection specified in projectionName. The value must be the desired TTL in minutes.
- SHARD_KEY: Comma-separated list of the columns to be sharded on; e.g. 'column1, column2'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.
- PERSIST: If true then the projection 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 projection 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 to which the projection is to be assigned as a child.
`static String`	`EXPRESSION` An optional filter expression to be applied to the source table prior to the projection.
`static String`	`FALSE`
`static String`	`LIMIT` The number of records to keep.
`static String`	`MATERIALIZE_ON_GPU` If `true` then the columns of the projection will be cached on the GPU.
`static String`	`ORDER_BY` Comma-separated list of the columns to be sorted by; e.g.
`static String`	`PERSIST` If `true` then the projection 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`	`SHARD_KEY` Comma-separated list of the columns to be sharded on; e.g.
`static String`	`TRUE`
`static String`	`TTL` Sets the TTL of the table, view, or collection specified in `projectionName`.

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 to which the projection is to be assigned as a child. If the collection provided is non-existent, the collection will be automatically created.
    
    See Also:
    Constant Field Values
  - EXPRESSION
```
public static final String EXPRESSION
```
    An optional filter expression to be applied to the source table prior to the projection.
    
    See Also:
    Constant Field Values
  - LIMIT
```
public static final String LIMIT
```
    The number of records to keep.
    
    See Also:
    Constant Field Values
  - ORDER_BY
```
public static final String ORDER_BY
```
    Comma-separated list of the columns to be sorted by; e.g. 'timestamp asc, x desc'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.
    
    See Also:
    Constant Field Values
  - MATERIALIZE_ON_GPU
```
public static final String MATERIALIZE_ON_GPU
```
    If true then the columns of the projection 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
  - TTL
```
public static final String TTL
```
    Sets the TTL of the table, view, or collection specified in projectionName. The value must be the desired TTL in minutes.
    
    See Also:
    Constant Field Values
  - SHARD_KEY
```
public static final String SHARD_KEY
```
    Comma-separated list of the columns to be sharded on; e.g. 'column1, column2'. The columns specified must be present in columnNames. If any alias is given for any column name, the alias must be used, rather than the original column name.
    
    See Also:
    Constant Field Values
  - PERSIST
```
public static final String PERSIST
```
    If true then the projection 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 projection will be a read-only, memory-only temporary table. Supported values:
    - TRUE
    - FALSE
    The default value is FALSE.
    See Also:
    Constant Field Values

Class CreateProjectionRequest.Options

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

COLLECTION_NAME

EXPRESSION

LIMIT

ORDER_BY

MATERIALIZE_ON_GPU

TRUE

FALSE

TTL

SHARD_KEY

PERSIST