​

Field Details

• ​

  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