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

Optional parameters.

• COLLECTION_NAME: Name of a collection which is to contain the join. If the collection provided is non-existent, the collection will be automatically created. If empty, then the join will be at the top level. The default value is ''.
• MAX_QUERY_DIMENSIONS: Obsolete in GPUdb v7.0
• OPTIMIZE_LOOKUPS: Use more memory to speed up the joining of tables. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• TTL: Sets the TTL of the join table specified in joinTableName.
• VIEW_ID: view this projection is part of. The default value is ''.
• NO_COUNT: return a count of 0 for the join table for logging and for show_table. optimization needed for large overlapped equi-join stencils. The default value is 'false'.
• CHUNK_SIZE: Maximum number of records per joined-chunk for this table. Defaults to the gpudb.conf file chunk size

The default value is an empty Map. A set of string constants for the parameter options.

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 Name of a collection which is to contain the join.
static String	FALSE
static String	MAX_QUERY_DIMENSIONS Obsolete in GPUdb v7.0
static String	NO_COUNT return a count of 0 for the join table for logging and for show_table.
static String	OPTIMIZE_LOOKUPS Use more memory to speed up the joining of tables.
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

COLLECTION_NAME

public static final String COLLECTION_NAME

Name of a collection which is to contain the join. If the collection provided is non-existent, the collection will be automatically created. If empty, then the join will be at the top level. The default value is ''.

See Also:

Constant Field Values

MAX_QUERY_DIMENSIONS

public static final String MAX_QUERY_DIMENSIONS

Obsolete in GPUdb v7.0

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

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 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 show_table. 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