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

# kinetica.AggregateUniqueRequest.Options

> kinetica.AggregateUniqueRequest.Options — Kinetica C# API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1AggregateUniqueRequest#a3be5b1eadead4a160136d7359db31cbe" title="Optional parameters.">AggregateUniqueRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader">
            <div id="pub-static-attribs" />

            Static Public Attributes
          </h2>
        </td>
      </tr>

      <tr className="memitem:a076e42924db73a09437382111c8f7db7" id="r_a076e42924db73a09437382111c8f7db7">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a076e42924db73a09437382111c8f7db7">CREATE\_TEMP\_TABLE</a> = "create\_temp\_table"</td>
      </tr>

      <tr className="memdesc:a076e42924db73a09437382111c8f7db7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. <br /></td>
      </tr>

      <tr className="separator:a076e42924db73a09437382111c8f7db7">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ab7b28697c61fae06b7876021bc31634e" id="r_ab7b28697c61fae06b7876021bc31634e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> = "true"</td>
      </tr>

      <tr className="memdesc:ab7b28697c61fae06b7876021bc31634e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:ab7b28697c61fae06b7876021bc31634e">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ae8c2065de405f52f4d32d856b6a606a7" id="r_ae8c2065de405f52f4d32d856b6a606a7">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a> = "false"</td>
      </tr>

      <tr className="memdesc:ae8c2065de405f52f4d32d856b6a606a7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:ae8c2065de405f52f4d32d856b6a606a7">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac797c2ba0601ee8147876138c5e64c4d" id="r_ac797c2ba0601ee8147876138c5e64c4d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac797c2ba0601ee8147876138c5e64c4d">COLLECTION\_NAME</a> = "collection\_name"</td>
      </tr>

      <tr className="memdesc:ac797c2ba0601ee8147876138c5e64c4d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–please specify the containing schema as part of <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema which is to contain the table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. <br /></td>
      </tr>

      <tr className="separator:ac797c2ba0601ee8147876138c5e64c4d">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a7f3a43059203a87e89373427aa218be6" id="r_a7f3a43059203a87e89373427aa218be6">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7f3a43059203a87e89373427aa218be6">EXPRESSION</a> = "expression"</td>
      </tr>

      <tr className="memdesc:a7f3a43059203a87e89373427aa218be6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Filter expression to apply to the table. <br /></td>
      </tr>

      <tr className="separator:a7f3a43059203a87e89373427aa218be6">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a2bd0fc0ab0ffef29e6230f177ccacdec" id="r_a2bd0fc0ab0ffef29e6230f177ccacdec">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a2bd0fc0ab0ffef29e6230f177ccacdec">SORT\_ORDER</a> = "sort\_order"</td>
      </tr>

      <tr className="memdesc:a2bd0fc0ab0ffef29e6230f177ccacdec">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">String indicating how the returned values should be sorted. <br /></td>
      </tr>

      <tr className="separator:a2bd0fc0ab0ffef29e6230f177ccacdec">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a5d4a1a3f6b231aee09e24cae411b40b8" id="r_a5d4a1a3f6b231aee09e24cae411b40b8">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5d4a1a3f6b231aee09e24cae411b40b8">ASCENDING</a> = "ascending"</td>
      </tr>

      <tr className="memdesc:a5d4a1a3f6b231aee09e24cae411b40b8">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a5d4a1a3f6b231aee09e24cae411b40b8">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a7f459d02a531a1c68448658782abaa39" id="r_a7f459d02a531a1c68448658782abaa39">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7f459d02a531a1c68448658782abaa39">DESCENDING</a> = "descending"</td>
      </tr>

      <tr className="memdesc:a7f459d02a531a1c68448658782abaa39">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. <br /></td>
      </tr>

      <tr className="separator:a7f459d02a531a1c68448658782abaa39">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a423564b591d5325ae17ecdbe5e97c7de" id="r_a423564b591d5325ae17ecdbe5e97c7de">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a423564b591d5325ae17ecdbe5e97c7de">ORDER\_BY</a> = "order\_by"</td>
      </tr>

      <tr className="memdesc:a423564b591d5325ae17ecdbe5e97c7de">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of the columns to be sorted by as well as the sort direction, e.g., 'timestamp asc, x desc'. <br /></td>
      </tr>

      <tr className="separator:a423564b591d5325ae17ecdbe5e97c7de">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:aa9d8e8a96236293304c1cfbe9f64be18" id="r_aa9d8e8a96236293304c1cfbe9f64be18">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> = "result\_table"</td>
      </tr>

      <tr className="memdesc:aa9d8e8a96236293304c1cfbe9f64be18">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The name of the table used to store the results, in \[schema\_name. <br /></td>
      </tr>

      <tr className="separator:aa9d8e8a96236293304c1cfbe9f64be18">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a9f19da7fa86fb0f9939f2e1e96abf35f" id="r_a9f19da7fa86fb0f9939f2e1e96abf35f">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a9f19da7fa86fb0f9939f2e1e96abf35f">RESULT\_TABLE\_PERSIST</a> = "result\_table\_persist"</td>
      </tr>

      <tr className="memdesc:a9f19da7fa86fb0f9939f2e1e96abf35f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a>, then the result table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> will be persisted and will not expire unless a <a className="el" href="#a5129af3c10fe1b6a013db543d5d0284e">TTL</a> is specified. <br /></td>
      </tr>

      <tr className="separator:a9f19da7fa86fb0f9939f2e1e96abf35f">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac2861662b042394ad57ed99a6ff9e7a1" id="r_ac2861662b042394ad57ed99a6ff9e7a1">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac2861662b042394ad57ed99a6ff9e7a1">RESULT\_TABLE\_FORCE\_REPLICATED</a> = "result\_table\_force\_replicated"</td>
      </tr>

      <tr className="memdesc:ac2861662b042394ad57ed99a6ff9e7a1">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Force the result table to be replicated (ignores any sharding). <br /></td>
      </tr>

      <tr className="separator:ac2861662b042394ad57ed99a6ff9e7a1">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ad004e9d292ee8d29969c0f0bfcad83fe" id="r_ad004e9d292ee8d29969c0f0bfcad83fe">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad004e9d292ee8d29969c0f0bfcad83fe">RESULT\_TABLE\_GENERATE\_PK</a> = "result\_table\_generate\_pk"</td>
      </tr>

      <tr className="memdesc:ad004e9d292ee8d29969c0f0bfcad83fe">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> then set a primary key for the result table. <br /></td>
      </tr>

      <tr className="separator:ad004e9d292ee8d29969c0f0bfcad83fe">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a5129af3c10fe1b6a013db543d5d0284e" id="r_a5129af3c10fe1b6a013db543d5d0284e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5129af3c10fe1b6a013db543d5d0284e">TTL</a> = "ttl"</td>
      </tr>

      <tr className="memdesc:a5129af3c10fe1b6a013db543d5d0284e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. <br /></td>
      </tr>

      <tr className="separator:a5129af3c10fe1b6a013db543d5d0284e">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:aed8a369f4d1dfb23c210be5c659e9fda" id="r_aed8a369f4d1dfb23c210be5c659e9fda">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aed8a369f4d1dfb23c210be5c659e9fda">CHUNK\_SIZE</a> = "chunk\_size"</td>
      </tr>

      <tr className="memdesc:aed8a369f4d1dfb23c210be5c659e9fda">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates the number of records per chunk to be used for the result table. <br /></td>
      </tr>

      <tr className="separator:aed8a369f4d1dfb23c210be5c659e9fda">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a88da0ae4180ccb5d6941c1131c49ef84" id="r_a88da0ae4180ccb5d6941c1131c49ef84">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a88da0ae4180ccb5d6941c1131c49ef84">CHUNK\_COLUMN\_MAX\_MEMORY</a> = "chunk\_column\_max\_memory"</td>
      </tr>

      <tr className="memdesc:a88da0ae4180ccb5d6941c1131c49ef84">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates the target maximum data size for each column in a chunk to be used for the result table. <br /></td>
      </tr>

      <tr className="separator:a88da0ae4180ccb5d6941c1131c49ef84">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a75da6dbf077edba67a6e07dc00d19da2" id="r_a75da6dbf077edba67a6e07dc00d19da2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a75da6dbf077edba67a6e07dc00d19da2">CHUNK\_MAX\_MEMORY</a> = "chunk\_max\_memory"</td>
      </tr>

      <tr className="memdesc:a75da6dbf077edba67a6e07dc00d19da2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates the target maximum data size for all columns in a chunk to be used for the result table. <br /></td>
      </tr>

      <tr className="separator:a75da6dbf077edba67a6e07dc00d19da2">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a787e218bd1cbae111cb2d1c487e38ded" id="r_a787e218bd1cbae111cb2d1c487e38ded">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a787e218bd1cbae111cb2d1c487e38ded">COMPRESSION\_CODEC</a> = "compression\_codec"</td>
      </tr>

      <tr className="memdesc:a787e218bd1cbae111cb2d1c487e38ded">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The default <a href="/content/concepts/column_compression/" target="_top">compression codec</a> for the result table's columns. <br /></td>
      </tr>

      <tr className="separator:a787e218bd1cbae111cb2d1c487e38ded">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ac4d3a9f4f97e3f9d6d7bb46489f6b562" id="r_ac4d3a9f4f97e3f9d6d7bb46489f6b562">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac4d3a9f4f97e3f9d6d7bb46489f6b562">VIEW\_ID</a> = "view\_id"</td>
      </tr>

      <tr className="memdesc:ac4d3a9f4f97e3f9d6d7bb46489f6b562">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">ID of view of which the result table will be a member. <br /></td>
      </tr>

      <tr className="separator:ac4d3a9f4f97e3f9d6d7bb46489f6b562">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <div id="details" />

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1AggregateUniqueRequest#a3be5b1eadead4a160136d7359db31cbe" title="Optional parameters.">AggregateUniqueRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L63">63</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>

    <div id="a5d4a1a3f6b231aee09e24cae411b40b8" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5d4a1a3f6b231aee09e24cae411b40b8">◆ </a></span>ASCENDING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.ASCENDING = "ascending"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L142">142</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a88da0ae4180ccb5d6941c1131c49ef84" />

    <h2 className="memtitle"><span className="permalink"><a href="#a88da0ae4180ccb5d6941c1131c49ef84">◆ </a></span>CHUNK\_COLUMN\_MAX\_MEMORY</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.CHUNK\_COLUMN\_MAX\_MEMORY = "chunk\_column\_max\_memory"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Indicates the target maximum data size for each column in a chunk to be used for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L261">261</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a75da6dbf077edba67a6e07dc00d19da2" />

    <h2 className="memtitle"><span className="permalink"><a href="#a75da6dbf077edba67a6e07dc00d19da2">◆ </a></span>CHUNK\_MAX\_MEMORY</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.CHUNK\_MAX\_MEMORY = "chunk\_max\_memory"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Indicates the target maximum data size for all columns in a chunk to be used for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L268">268</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="aed8a369f4d1dfb23c210be5c659e9fda" />

    <h2 className="memtitle"><span className="permalink"><a href="#aed8a369f4d1dfb23c210be5c659e9fda">◆ </a></span>CHUNK\_SIZE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.CHUNK\_SIZE = "chunk\_size"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Indicates the number of records per chunk to be used for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L254">254</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ac797c2ba0601ee8147876138c5e64c4d" />

    <h2 className="memtitle"><span className="permalink"><a href="#ac797c2ba0601ee8147876138c5e64c4d">◆ </a></span>COLLECTION\_NAME</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.COLLECTION\_NAME = "collection\_name"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>\[DEPRECATED–please specify the containing schema as part of <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica/createschema#ac754b44062e7b90b8afa50ddfa8ccbf2">Kinetica.createSchema</a> to create the schema if non-existent] Name of a schema which is to contain the table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. </p>
        <p>If the schema provided is non-existent, it will be automatically created.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L115">115</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a787e218bd1cbae111cb2d1c487e38ded" />

    <h2 className="memtitle"><span className="permalink"><a href="#a787e218bd1cbae111cb2d1c487e38ded">◆ </a></span>COMPRESSION\_CODEC</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.COMPRESSION\_CODEC = "compression\_codec"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>The default <a href="/content/concepts/column_compression/" target="_top">compression codec</a> for the result table's columns. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L274">274</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a076e42924db73a09437382111c8f7db7" />

    <h2 className="memtitle"><span className="permalink"><a href="#a076e42924db73a09437382111c8f7db7">◆ </a></span>CREATE\_TEMP\_TABLE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.CREATE\_TEMP\_TABLE = "create\_temp\_table"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. </p>
        <p>If <a className="el" href="#a9f19da7fa86fb0f9939f2e1e96abf35f">RESULT\_TABLE\_PERSIST</a> is <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</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 className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueResponse_1_1Info#a17b55ecdaba6188b3b3c5a6e171fe087">QUALIFIED\_RESULT\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> </li>
          <li> <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L94">94</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a7f459d02a531a1c68448658782abaa39" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7f459d02a531a1c68448658782abaa39">◆ </a></span>DESCENDING</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.DESCENDING = "descending"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L146">146</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a7f3a43059203a87e89373427aa218be6" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7f3a43059203a87e89373427aa218be6">◆ </a></span>EXPRESSION</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.EXPRESSION = "expression"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Filter expression to apply to the table. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L118">118</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ae8c2065de405f52f4d32d856b6a606a7" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae8c2065de405f52f4d32d856b6a606a7">◆ </a></span>FALSE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.FALSE = "false"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L102">102</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a423564b591d5325ae17ecdbe5e97c7de" />

    <h2 className="memtitle"><span className="permalink"><a href="#a423564b591d5325ae17ecdbe5e97c7de">◆ </a></span>ORDER\_BY</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.ORDER\_BY = "order\_by"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Comma-separated list of the columns to be sorted by as well as the sort direction, e.g., 'timestamp asc, x desc'. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L152">152</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="aa9d8e8a96236293304c1cfbe9f64be18" />

    <h2 className="memtitle"><span className="permalink"><a href="#aa9d8e8a96236293304c1cfbe9f64be18">◆ </a></span>RESULT\_TABLE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.RESULT\_TABLE = "result\_table"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>The name of the table used to store the results, in \[schema\_name. </p>
        <p>]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>. </p>
        <p>If present, no results are returned in the response. Not available if <a className="el" href="/content/api/cs/classkinetica_1_1AggregateUniqueRequest#ac661b4daebec563998273b4a5501914e" title="Name of the column or an expression containing one or more column names on which the unique function ...">AggregateUniqueRequest.column\_name</a> is an unrestricted-length string.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L164">164</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ac2861662b042394ad57ed99a6ff9e7a1" />

    <h2 className="memtitle"><span className="permalink"><a href="#ac2861662b042394ad57ed99a6ff9e7a1">◆ </a></span>RESULT\_TABLE\_FORCE\_REPLICATED</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.RESULT\_TABLE\_FORCE\_REPLICATED = "result\_table\_force\_replicated"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Force the result table to be replicated (ignores any sharding). </p>
        <p>Must be used in combination with the <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> option. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> </li>
          <li> <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L217">217</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ad004e9d292ee8d29969c0f0bfcad83fe" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad004e9d292ee8d29969c0f0bfcad83fe">◆ </a></span>RESULT\_TABLE\_GENERATE\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.RESULT\_TABLE\_GENERATE\_PK = "result\_table\_generate\_pk"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> then set a primary key for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> option. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> </li>
          <li> <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L241">241</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a9f19da7fa86fb0f9939f2e1e96abf35f" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9f19da7fa86fb0f9939f2e1e96abf35f">◆ </a></span>RESULT\_TABLE\_PERSIST</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.RESULT\_TABLE\_PERSIST = "result\_table\_persist"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>If <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a>, then the result table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a> will be persisted and will not expire unless a <a className="el" href="#a5129af3c10fe1b6a013db543d5d0284e">TTL</a> is specified. </p>
        <p>If <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a>, then the result table will be an in-memory table and will expire unless a <a className="el" href="#a5129af3c10fe1b6a013db543d5d0284e">TTL</a> is specified otherwise. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ab7b28697c61fae06b7876021bc31634e">TRUE</a> </li>
          <li> <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ae8c2065de405f52f4d32d856b6a606a7">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L194">194</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a2bd0fc0ab0ffef29e6230f177ccacdec" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2bd0fc0ab0ffef29e6230f177ccacdec">◆ </a></span>SORT\_ORDER</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.SORT\_ORDER = "sort\_order"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

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

        <ul>
          <li> <a className="el" href="#a5d4a1a3f6b231aee09e24cae411b40b8">ASCENDING</a> </li>
          <li> <a className="el" href="#a7f459d02a531a1c68448658782abaa39">DESCENDING</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a5d4a1a3f6b231aee09e24cae411b40b8">ASCENDING</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L138">138</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ab7b28697c61fae06b7876021bc31634e" />

    <h2 className="memtitle"><span className="permalink"><a href="#ab7b28697c61fae06b7876021bc31634e">◆ </a></span>TRUE</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.TRUE = "true"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>A boolean constant for the <a className="el" href="/content/api/cs/structkinetica_1_1AggregateUniqueRequest_1_1Options" title="A set of string constants for the parameter AggregateUniqueRequest.options.">AggregateUniqueRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L98">98</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="a5129af3c10fe1b6a013db543d5d0284e" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5129af3c10fe1b6a013db543d5d0284e">◆ </a></span>TTL</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.TTL = "ttl"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the table specified in <a className="el" href="#aa9d8e8a96236293304c1cfbe9f64be18">RESULT\_TABLE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L247">247</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <div id="ac4d3a9f4f97e3f9d6d7bb46489f6b562" />

    <h2 className="memtitle"><span className="permalink"><a href="#ac4d3a9f4f97e3f9d6d7bb46489f6b562">◆ </a></span>VIEW\_ID</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.AggregateUniqueRequest.Options.VIEW\_ID = "view\_id"</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel static">static</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>ID of view of which the result table will be a member. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs#L279">279</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following file:

    <ul>
      <li>Kinetica/Protocol/<a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/AggregateUnique.cs">AggregateUnique.cs</a></li>
    </ul>
  </div>
</div>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.