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

Enclosing class:

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

Field Summary

Fields
Modifier and Type	Field	Description
`static String`	`CHUNK_SIZE`	Maximum number of records per joined-chunk for this table.
`static String`	`COLLECTION_NAME`	[DEPRECATED--please specify the containing schema for the join as part of `joinTableName` and use `GPUdb.createSchema` to create the schema if non-existent] Name of a schema for the join.
`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 `joinTableName`.
`static String`	`ENABLE_EQUI_JOIN_LAZY_RESULT_STORE`	Allow using the lazy result store to cache computation of one side of a multichunk equi-join.
`static String`	`ENABLE_PK_EQUI_JOIN`	Use equi-join to do primary key joins rather than using primary-key-index
`static String`	`ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE`	Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join.
`static String`	`ENABLE_SPARSE_VIRTUAL_CHUNKING`	materialize virtual chunks with only non-deleted values.
`static String`	`ENABLE_VIRTUAL_CHUNKING`	Collect chunks with accumulated size less than chunk_size into a single chunk.
`static String`	`FALSE`
`static String`	`MAX_QUERY_DIMENSIONS`	No longer used.
`static String`	`MAX_VIRTUAL_CHUNK_SIZE`	Maximum number of records per virtual-chunk.
`static String`	`MIN_VIRTUAL_CHUNK_SIZE`	Minimum number of records per virtual-chunk.
`static String`	`NO_COUNT`	Return a count of 0 for the join table for logging and for `GPUdb.showTable`; optimization needed for large overlapped equi-join stencils.
`static String`	`STRATEGY_DEFINITION`	The tier strategy for the table and its columns.
`static String`	`TRUE`
`static String`	`TTL`	Sets the TTL of the join table specified in `joinTableName`.
`static String`	`VIEW_ID`	view this projection is part of.

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 joinTableName. This is always allowed even if the caller does not have permission to create tables. The generated name is returned in QUALIFIED_JOIN_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 join as part of joinTableName and use GPUdb.createSchema to create the schema if non-existent] Name of a schema for the join. If the schema is non-existent, it will be automatically created. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - MAX_QUERY_DIMENSIONS
```
public static final String MAX_QUERY_DIMENSIONS
```
    No longer used.
    
    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
  - TTL
```
public static final String TTL
```
    Sets the TTL of the join table specified in joinTableName.
    
    See Also:
    
    Constant Field Values
  - VIEW_ID
```
public static final String VIEW_ID
```
    view this projection is part of. The default value is ''.
    
    See Also:
    
    Constant Field Values
  - NO_COUNT
```
public static final String NO_COUNT
```
    Return a count of 0 for the join table for logging and for GPUdb.showTable; optimization needed for large overlapped equi-join stencils. The default value is 'false'.
    
    See Also:
    
    Constant Field Values
  - CHUNK_SIZE
```
public static final String CHUNK_SIZE
```
    Maximum number of records per joined-chunk for this table. Defaults to the gpudb.conf file chunk size
    
    See Also:
    
    Constant Field Values
  - ENABLE_VIRTUAL_CHUNKING
```
public static final String ENABLE_VIRTUAL_CHUNKING
```
    Collect chunks with accumulated size less than chunk_size into a single chunk. The default value is 'false'.
    
    See Also:
    
    Constant Field Values
  - MAX_VIRTUAL_CHUNK_SIZE
```
public static final String MAX_VIRTUAL_CHUNK_SIZE
```
    Maximum number of records per virtual-chunk. When set, enables virtual chunking. Defaults to chunk_size if virtual chunking otherwise enabled.
    
    See Also:
    
    Constant Field Values
  - MIN_VIRTUAL_CHUNK_SIZE
```
public static final String MIN_VIRTUAL_CHUNK_SIZE
```
    Minimum number of records per virtual-chunk. When set, enables virtual chunking. Defaults to chunk_size if virtual chunking otherwise enabled.
    
    See Also:
    
    Constant Field Values
  - ENABLE_SPARSE_VIRTUAL_CHUNKING
```
public static final String ENABLE_SPARSE_VIRTUAL_CHUNKING
```
    materialize virtual chunks with only non-deleted values. The default value is 'false'.
    
    See Also:
    
    Constant Field Values
  - ENABLE_EQUI_JOIN_LAZY_RESULT_STORE
```
public static final String ENABLE_EQUI_JOIN_LAZY_RESULT_STORE
```
    Allow using the lazy result store to cache computation of one side of a multichunk equi-join. Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join
    
    See Also:
    
    Constant Field Values
  - ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE
```
public static final String ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE
```
    Allow using the lazy result store to cache computation of one side of a multichunk predicate-equi-join. Reduces computation but also reduces parallelism to the number of chunks on the other side of the equi-join
    
    See Also:
    
    Constant Field Values
  - ENABLE_PK_EQUI_JOIN
```
public static final String ENABLE_PK_EQUI_JOIN
```
    Use equi-join to do primary key joins rather than using primary-key-index
    
    See Also:
    
    Constant Field Values

Class CreateJoinTableRequest.Options

Field Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

CREATE_TEMP_TABLE

TRUE

FALSE

COLLECTION_NAME

MAX_QUERY_DIMENSIONS

STRATEGY_DEFINITION

TTL

VIEW_ID

NO_COUNT

CHUNK_SIZE

ENABLE_VIRTUAL_CHUNKING

MAX_VIRTUAL_CHUNK_SIZE

MIN_VIRTUAL_CHUNK_SIZE

ENABLE_SPARSE_VIRTUAL_CHUNKING

ENABLE_EQUI_JOIN_LAZY_RESULT_STORE

ENABLE_PREDICATE_EQUI_JOIN_LAZY_RESULT_STORE

ENABLE_PK_EQUI_JOIN