> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CreateUnionRequest.Options

> CreateUnionRequest.Options — Kinetica Java API

<div className="kinetica-javadoc">
  <div className="header">
    <div className="sub-title"><span className="package-label-in-type">Package</span> <a href="/content/api/java/com/gpudb/protocol/package-summary">com.gpudb.protocol</a></div>
    <h1 title="Class CreateUnionRequest.Options" className="title">Class CreateUnionRequest.Options</h1>
  </div>

  <div className="inheritance" title="Inheritance Tree">
    <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">java.lang.Object</a>
    <div className="inheritance">com.gpudb.protocol.CreateUnionRequest.Options</div>
  </div>

  <div className="section class-description" id="class-description">
    <div className="dl notes">
      <div className="dt">Enclosing class:</div>
      <div className="dd"><code><a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest" title="class in com.gpudb.protocol">CreateUnionRequest</a></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">CreateUnionRequest.Options</span> <span className="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></span></div>

    <div className="block">
      A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest" title="class in com.gpudb.protocol"><code>CreateUnionRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getOptions()"><code>options</code></a>.
      <p> Optional parameters.</p>
    </div>
  </div>

  <div className="section summary">
    <ul className="summary-list">
      <li>
        <div className="section field-summary" id="field-summary">
          <h2>Field Summary</h2>
          <div className="caption"><span>Fields</span></div>

          <div className="summary-table three-column-summary">
            <div className="table-header col-first">Modifier and Type</div>
            <div className="table-header col-second">Field</div>
            <div className="table-header col-last">Description</div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#CHUNK_COLUMN_MAX_MEMORY" className="member-name-link">CHUNK\_COLUMN\_MAX\_MEMORY</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Indicates the target maximum data size for each column in a chunk to be used for this output table.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#CHUNK_MAX_MEMORY" className="member-name-link">CHUNK\_MAX\_MEMORY</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Indicates the target maximum data size for all columns in a chunk to be used for this output table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#CHUNK_SIZE" className="member-name-link">CHUNK\_SIZE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Indicates the number of records per chunk to be used for this output table.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#COLLECTION_NAME" className="member-name-link">COLLECTION\_NAME</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">\[DEPRECATED--please specify the containing schema for the projection as part of <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> and use <a href="/content/api/java/com/gpudb/GPUdb#createSchema(com.gpudb.protocol.CreateSchemaRequest)"><code>GPUdb.createSchema</code></a> to create the schema if non-existent] Name of the schema for the output table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#COMPRESSION_CODEC" className="member-name-link">COMPRESSION\_CODEC</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">The default <a href="/content/concepts/column_compression/" target="_top">compression codec</a> for this table's columns.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#CREATE_INDEXES" className="member-name-link">CREATE\_INDEXES</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Comma-separated list of columns on which to create indexes on the output table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#CREATE_TEMP_TABLE" className="member-name-link">CREATE\_TEMP\_TABLE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#EXCEPT" className="member-name-link">EXCEPT</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#EXCEPT_ALL" className="member-name-link">EXCEPT\_ALL</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#FALSE" className="member-name-link">FALSE</a></code></div>
            <div className="col-last odd-row-color"> </div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#FORCE_REPLICATED" className="member-name-link">FORCE\_REPLICATED</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, then the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> will be replicated even if the source tables are not.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#HASH" className="member-name-link">HASH</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#INTERSECT" className="member-name-link">INTERSECT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Retains all unique rows that appear in both of the specified tables (only works on 2 tables).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#INTERSECT_ALL" className="member-name-link">INTERSECT\_ALL</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#INTERVAL" className="member-name-link">INTERVAL</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#IS_AUTOMATIC_PARTITION" className="member-name-link">IS\_AUTOMATIC\_PARTITION</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, a new partition will be created for values which don't fall into an existing partition.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#LIST" className="member-name-link">LIST</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#MODE" className="member-name-link">MODE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The mode describes what rows of the tables being unioned will be retained.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#NO_COUNT" className="member-name-link">NO\_COUNT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Return a count of 0 for the union table response to avoid the cost of counting; optimization needed for many chunk virtual unions.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PARTITION_DEFINITIONS" className="member-name-link">PARTITION\_DEFINITIONS</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Comma-separated list of partition definitions, whose format depends on the choice of <a href="#PARTITION_TYPE"><code>PARTITION\_TYPE</code></a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PARTITION_KEYS" className="member-name-link">PARTITION\_KEYS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by <a href="#PARTITION_DEFINITIONS"><code>PARTITION\_DEFINITIONS</code></a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PARTITION_TYPE" className="member-name-link">PARTITION\_TYPE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block"><a href="/content/concepts/tables/#partitioning" target="_top">Partitioning</a> scheme to use for the output table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PERSIST" className="member-name-link">PERSIST</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, then the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> will be persisted and will not expire unless a <a href="#TTL"><code>TTL</code></a> is specified.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#RANGE" className="member-name-link">RANGE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#SERIES" className="member-name-link">SERIES</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#STRATEGY_DEFINITION" className="member-name-link">STRATEGY\_DEFINITION</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TRUE" className="member-name-link">TRUE</a></code></div>
            <div className="col-last even-row-color"> </div>
            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#TTL" className="member-name-link">TTL</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#UNION" className="member-name-link">UNION</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Retains all unique rows from the specified tables (synonym for <a href="#UNION_DISTINCT"><code>UNION\_DISTINCT</code></a>).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#UNION_ALL" className="member-name-link">UNION\_ALL</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Retains all rows from the specified tables.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#UNION_DISTINCT" className="member-name-link">UNION\_DISTINCT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Retains all unique rows from the specified tables.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#VIEW_ID" className="member-name-link">VIEW\_ID</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">ID of view of which this output table is a member.</div>
            </div>
          </div>
        </div>
      </li>

      <li>
        <div className="section method-summary" id="method-summary">
          <h2>Method Summary</h2>

          <div className="inherited-list">
            <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></h3>
            <code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" className="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" className="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" className="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" className="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" className="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" className="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" className="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" className="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" className="external-link">wait</a></code>
          </div>
        </div>
      </li>
    </ul>
  </div>

  <div className="section details">
    <ul className="details-list">
      <li>
        <div className="section field-details" id="field-detail">
          <h2>Field Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="CREATE_TEMP_TABLE">
                <h3>CREATE\_TEMP\_TABLE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CREATE\_TEMP\_TABLE</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a>. If <a href="#PERSIST"><code>PERSIST</code></a> is <a href="#FALSE"><code>FALSE</code></a> (or unspecified), then this is always allowed even if the caller does not have permission to create tables. The generated name is returned in <a href="/content/api/java/com/gpudb/protocol/CreateUnionResponse.Info#QUALIFIED_TABLE_NAME"><code>QUALIFIED\_TABLE\_NAME</code></a>. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.CREATE_TEMP_TABLE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUE">
                <h3>TRUE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.TRUE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FALSE">
                <h3>FALSE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FALSE</span></div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.FALSE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="COLLECTION_NAME">
                <h3>COLLECTION\_NAME</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">COLLECTION\_NAME</span></div>
                <div className="block">\[DEPRECATED--please specify the containing schema for the projection as part of <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> and use <a href="/content/api/java/com/gpudb/GPUdb#createSchema(com.gpudb.protocol.CreateSchemaRequest)"><code>GPUdb.createSchema</code></a> to create the schema if non-existent] Name of the schema for the output table. If the schema provided is non-existent, it will be automatically created. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.COLLECTION_NAME">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="MODE">
                <h3>MODE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">MODE</span></div>

                <div className="block">
                  The mode describes what rows of the tables being unioned will be retained. Supported values:

                  <ul>
                    <li><a href="#UNION_ALL"><code>UNION\_ALL</code></a>: Retains all rows from the specified tables. </li>
                    <li><a href="#UNION"><code>UNION</code></a>: Retains all unique rows from the specified tables (synonym for <a href="#UNION_DISTINCT"><code>UNION\_DISTINCT</code></a>). </li>
                    <li><a href="#UNION_DISTINCT"><code>UNION\_DISTINCT</code></a>: Retains all unique rows from the specified tables. </li>
                    <li><a href="#EXCEPT"><code>EXCEPT</code></a>: Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables). </li>
                    <li><a href="#EXCEPT_ALL"><code>EXCEPT\_ALL</code></a>: Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables). </li>
                    <li><a href="#INTERSECT"><code>INTERSECT</code></a>: Retains all unique rows that appear in both of the specified tables (only works on 2 tables). </li>
                    <li><a href="#INTERSECT_ALL"><code>INTERSECT\_ALL</code></a>: Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables). </li>
                  </ul>

                  The default value is <a href="#UNION_ALL"><code>UNION\_ALL</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.MODE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="UNION_ALL">
                <h3>UNION\_ALL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UNION\_ALL</span></div>
                <div className="block">Retains all rows from the specified tables.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.UNION_ALL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="UNION">
                <h3>UNION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UNION</span></div>
                <div className="block">Retains all unique rows from the specified tables (synonym for <a href="#UNION_DISTINCT"><code>UNION\_DISTINCT</code></a>).</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.UNION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="UNION_DISTINCT">
                <h3>UNION\_DISTINCT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UNION\_DISTINCT</span></div>
                <div className="block">Retains all unique rows from the specified tables.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.UNION_DISTINCT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="EXCEPT">
                <h3>EXCEPT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">EXCEPT</span></div>
                <div className="block">Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables).</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.EXCEPT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="EXCEPT_ALL">
                <h3>EXCEPT\_ALL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">EXCEPT\_ALL</span></div>
                <div className="block">Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables).</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.EXCEPT_ALL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="INTERSECT">
                <h3>INTERSECT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">INTERSECT</span></div>
                <div className="block">Retains all unique rows that appear in both of the specified tables (only works on 2 tables).</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.INTERSECT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="INTERSECT_ALL">
                <h3>INTERSECT\_ALL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">INTERSECT\_ALL</span></div>
                <div className="block">Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables).</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.INTERSECT_ALL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="CHUNK_SIZE">
                <h3>CHUNK\_SIZE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CHUNK\_SIZE</span></div>
                <div className="block">Indicates the number of records per chunk to be used for this output table.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.CHUNK_SIZE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="CHUNK_COLUMN_MAX_MEMORY">
                <h3>CHUNK\_COLUMN\_MAX\_MEMORY</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CHUNK\_COLUMN\_MAX\_MEMORY</span></div>
                <div className="block">Indicates the target maximum data size for each column in a chunk to be used for this output table.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.CHUNK_COLUMN_MAX_MEMORY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="CHUNK_MAX_MEMORY">
                <h3>CHUNK\_MAX\_MEMORY</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CHUNK\_MAX\_MEMORY</span></div>
                <div className="block">Indicates the target maximum data size for all columns in a chunk to be used for this output table.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.CHUNK_MAX_MEMORY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="CREATE_INDEXES">
                <h3>CREATE\_INDEXES</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">CREATE\_INDEXES</span></div>
                <div className="block">Comma-separated list of columns on which to create indexes on the output table. The columns specified must be present in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getOutputColumnNames()"><code>outputColumnNames</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.CREATE_INDEXES">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PARTITION_TYPE">
                <h3>PARTITION\_TYPE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PARTITION\_TYPE</span></div>

                <div className="block">
                  <a href="/content/concepts/tables/#partitioning" target="_top">Partitioning</a> scheme to use for the output table. Supported values:

                  <ul>
                    <li><a href="#RANGE"><code>RANGE</code></a>: Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </li>
                    <li><a href="#INTERVAL"><code>INTERVAL</code></a>: Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </li>
                    <li><a href="#LIST"><code>LIST</code></a>: Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </li>
                    <li><a href="#HASH"><code>HASH</code></a>: Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </li>
                    <li><a href="#SERIES"><code>SERIES</code></a>: Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>. </li>
                  </ul>
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.PARTITION_TYPE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RANGE">
                <h3>RANGE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">RANGE</span></div>
                <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.RANGE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="INTERVAL">
                <h3>INTERVAL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">INTERVAL</span></div>
                <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.INTERVAL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="LIST">
                <h3>LIST</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">LIST</span></div>
                <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.LIST">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="HASH">
                <h3>HASH</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">HASH</span></div>
                <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.HASH">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="SERIES">
                <h3>SERIES</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">SERIES</span></div>
                <div className="block">Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.SERIES">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PARTITION_KEYS">
                <h3>PARTITION\_KEYS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PARTITION\_KEYS</span></div>
                <div className="block">Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by <a href="#PARTITION_DEFINITIONS"><code>PARTITION\_DEFINITIONS</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.PARTITION_KEYS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PARTITION_DEFINITIONS">
                <h3>PARTITION\_DEFINITIONS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PARTITION\_DEFINITIONS</span></div>
                <div className="block">Comma-separated list of partition definitions, whose format depends on the choice of <a href="#PARTITION_TYPE"><code>PARTITION\_TYPE</code></a>. See <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>, <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>, <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>, <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>, or <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a> for example formats.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.PARTITION_DEFINITIONS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="IS_AUTOMATIC_PARTITION">
                <h3>IS\_AUTOMATIC\_PARTITION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">IS\_AUTOMATIC\_PARTITION</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, a new partition will be created for values which don't fall into an existing partition. Currently only supported for <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitions</a>. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.IS_AUTOMATIC_PARTITION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TTL">
                <h3>TTL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TTL</span></div>
                <div className="block">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.TTL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PERSIST">
                <h3>PERSIST</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PERSIST</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, then the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> will be persisted and will not expire unless a <a href="#TTL"><code>TTL</code></a> is specified. If <a href="#FALSE"><code>FALSE</code></a>, then the output table will be an in-memory table and will expire unless a <a href="#TTL"><code>TTL</code></a> is specified otherwise. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.PERSIST">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="VIEW_ID">
                <h3>VIEW\_ID</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">VIEW\_ID</span></div>
                <div className="block">ID of view of which this output table is a member. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.VIEW_ID">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FORCE_REPLICATED">
                <h3>FORCE\_REPLICATED</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FORCE\_REPLICATED</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, then the output table specified in <a href="/content/api/java/com/gpudb/protocol/CreateUnionRequest#getTableName()"><code>tableName</code></a> will be replicated even if the source tables are not. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.FORCE_REPLICATED">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="STRATEGY_DEFINITION">
                <h3>STRATEGY\_DEFINITION</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">STRATEGY\_DEFINITION</span></div>
                <div className="block">The <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.STRATEGY_DEFINITION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="COMPRESSION_CODEC">
                <h3>COMPRESSION\_CODEC</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">COMPRESSION\_CODEC</span></div>
                <div className="block">The default <a href="/content/concepts/column_compression/" target="_top">compression codec</a> for this table's columns.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.COMPRESSION_CODEC">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="NO_COUNT">
                <h3>NO\_COUNT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">NO\_COUNT</span></div>
                <div className="block">Return a count of 0 for the union table response to avoid the cost of counting; optimization needed for many chunk virtual unions. The default value is 'false'.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.CreateUnionRequest.Options.NO_COUNT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>