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

# AggregateUniqueRequest.Options

> AggregateUniqueRequest.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 AggregateUniqueRequest.Options" className="title">Class AggregateUniqueRequest.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.AggregateUniqueRequest.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/AggregateUniqueRequest" title="class in com.gpudb.protocol">AggregateUniqueRequest</a></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">AggregateUniqueRequest.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/AggregateUniqueRequest" title="class in com.gpudb.protocol"><code>AggregateUniqueRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#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="#ASCENDING" className="member-name-link">ASCENDING</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="#CHUNK_COLUMN_MAX_MEMORY" className="member-name-link">CHUNK\_COLUMN\_MAX\_MEMORY</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Indicates the target maximum data size for each column in a chunk to be used for the result 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_MAX_MEMORY" className="member-name-link">CHUNK\_MAX\_MEMORY</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Indicates the target maximum data size for all columns in a chunk to be used for the result 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_SIZE" className="member-name-link">CHUNK\_SIZE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Indicates the number of records per chunk to be used for the result 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="#COLLECTION_NAME" className="member-name-link">COLLECTION\_NAME</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">\[DEPRECATED--please specify the containing schema as part of <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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 a schema which is to contain the table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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="#COMPRESSION_CODEC" className="member-name-link">COMPRESSION\_CODEC</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The default <a href="/content/concepts/column_compression/" target="_top">compression codec</a> for the result table's 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="#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="#RESULT_TABLE"><code>RESULT\_TABLE</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="#DESCENDING" className="member-name-link">DESCENDING</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="#EXPRESSION" className="member-name-link">EXPRESSION</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Filter expression to apply to the 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="#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="#ORDER_BY" className="member-name-link">ORDER\_BY</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma-separated list of the columns to be sorted by as well as the sort direction, e.g., 'timestamp asc, x desc'.</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="#RESULT_TABLE" className="member-name-link">RESULT\_TABLE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The name of the table used to store the results, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</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="#RESULT_TABLE_FORCE_REPLICATED" className="member-name-link">RESULT\_TABLE\_FORCE\_REPLICATED</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Force the result table to be replicated (ignores any sharding).</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="#RESULT_TABLE_GENERATE_PK" className="member-name-link">RESULT\_TABLE\_GENERATE\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a> then set a primary key for the result 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="#RESULT_TABLE_PERSIST" className="member-name-link">RESULT\_TABLE\_PERSIST</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If <a href="#TRUE"><code>TRUE</code></a>, then the result table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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="#SORT_ORDER" className="member-name-link">SORT\_ORDER</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">String indicating how the returned values should be sorted.</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 table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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="#VIEW_ID" className="member-name-link">VIEW\_ID</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">ID of view of which the result table will be 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="#RESULT_TABLE"><code>RESULT\_TABLE</code></a>. If <a href="#RESULT_TABLE_PERSIST"><code>RESULT\_TABLE\_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/AggregateUniqueResponse.Info#QUALIFIED_RESULT_TABLE_NAME"><code>QUALIFIED\_RESULT\_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.AggregateUniqueRequest.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.AggregateUniqueRequest.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.AggregateUniqueRequest.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 as part of <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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 a schema which is to contain the table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a>. If the schema provided is non-existent, it will be automatically created.</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.AggregateUniqueRequest.Options.COLLECTION_NAME">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="EXPRESSION">
                <h3>EXPRESSION</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">EXPRESSION</span></div>
                <div className="block">Filter expression to apply to the 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.AggregateUniqueRequest.Options.EXPRESSION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="SORT_ORDER">
                <h3>SORT\_ORDER</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">SORT\_ORDER</span></div>

                <div className="block">
                  String indicating how the returned values should be sorted. Supported values:

                  <ul>
                    <li><a href="#ASCENDING"><code>ASCENDING</code></a> </li>
                    <li><a href="#DESCENDING"><code>DESCENDING</code></a> </li>
                  </ul>

                  The default value is <a href="#ASCENDING"><code>ASCENDING</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.AggregateUniqueRequest.Options.SORT_ORDER">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ASCENDING">
                <h3>ASCENDING</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">ASCENDING</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.AggregateUniqueRequest.Options.ASCENDING">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DESCENDING">
                <h3>DESCENDING</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">DESCENDING</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.AggregateUniqueRequest.Options.DESCENDING">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ORDER_BY">
                <h3>ORDER\_BY</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">ORDER\_BY</span></div>
                <div className="block">Comma-separated list of the columns to be sorted by as well as the sort direction, e.g., 'timestamp asc, x desc'. 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.AggregateUniqueRequest.Options.ORDER_BY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RESULT_TABLE">
                <h3>RESULT\_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">RESULT\_TABLE</span></div>
                <div className="block">The name of the table used to store the results, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a> and meeting <a href="/content/concepts/tables/#table-naming-criteria" target="_top">table naming criteria</a>. If present, no results are returned in the response. Not available if <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a> is an unrestricted-length string.</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.AggregateUniqueRequest.Options.RESULT_TABLE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RESULT_TABLE_PERSIST">
                <h3>RESULT\_TABLE\_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">RESULT\_TABLE\_PERSIST</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a>, then the result table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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 result 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.AggregateUniqueRequest.Options.RESULT_TABLE_PERSIST">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RESULT_TABLE_FORCE_REPLICATED">
                <h3>RESULT\_TABLE\_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">RESULT\_TABLE\_FORCE\_REPLICATED</span></div>

                <div className="block">
                  Force the result table to be replicated (ignores any sharding). Must be used in combination with the <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a> option. 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.AggregateUniqueRequest.Options.RESULT_TABLE_FORCE_REPLICATED">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="RESULT_TABLE_GENERATE_PK">
                <h3>RESULT\_TABLE\_GENERATE\_PK</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">RESULT\_TABLE\_GENERATE\_PK</span></div>

                <div className="block">
                  If <a href="#TRUE"><code>TRUE</code></a> then set a primary key for the result table. Must be used in combination with the <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a> option. 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.AggregateUniqueRequest.Options.RESULT_TABLE_GENERATE_PK">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 table specified in <a href="#RESULT_TABLE"><code>RESULT\_TABLE</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.AggregateUniqueRequest.Options.TTL">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 the result table. Must be used in combination with the <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a> option.</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.AggregateUniqueRequest.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 the result table. Must be used in combination with the <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a> option.</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.AggregateUniqueRequest.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 the result table. Must be used in combination with the <a href="#RESULT_TABLE"><code>RESULT\_TABLE</code></a> option.</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.AggregateUniqueRequest.Options.CHUNK_MAX_MEMORY">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 the result 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.AggregateUniqueRequest.Options.COMPRESSION_CODEC">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 the result table will be 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.AggregateUniqueRequest.Options.VIEW_ID">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>