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.

• 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.
• COLLECTION_NAME: [DEPRECATED--please specify the containing schema for the join as part of joinTableName and use GPUdb.createSchema(CreateSchemaRequest) 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 ''.
• MAX_QUERY_DIMENSIONS: No longer used.
• OPTIMIZE_LOOKUPS: Use more memory to speed up the joining of tables. Supported values:
  • TRUE
  • FALSE
  The default value is FALSE.
• STRATEGY_DEFINITION: The tier strategy for the table and its columns.
• 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 GPUdb.showTable(ShowTableRequest); 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 [DEPRECATED--please specify the containing schema for the join as part of joinTableName and use GPUdb.createSchema(CreateSchemaRequest) 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	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(ShowTableRequest); 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(CreateSchemaRequest) 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(ShowTableRequest); 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