com.gpudb.protocol

Class CreateJoinTableRequest.Options

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 and 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_PK_EQUI_JOIN Use equi-join to do primary key joins rather than using primary-key-index
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	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	OPTIMIZE_LOOKUPS Use more memory to speed up the joining of tables.
static String	STRATEGY_DEFINITION The	static String	TRUE
static String	TTL Sets the	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

OPTIMIZE_LOOKUPS

public static final String OPTIMIZE_LOOKUPS

Use more memory to speed up the joining of tables. 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

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

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