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

> kinetica.AggregateGroupByRequest.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_1AggregateGroupByRequest#aadc486025c5577fa0c66a5271d1a38ed" title="Optional parameters.">AggregateGroupByRequest.options</a>. <a href="#details">More...</a></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a6b08a07880f8a648e1bf30dd0c9c19e5">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–please specify the containing schema as part of <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a>. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a3a55b9aafe05c74e9e17034a8507d85a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Filter expression to apply to the table prior to computing the aggregate group by. <br /></td>
      </tr>

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

      <tr className="memitem:ad8d7cb3887b1e213cd445302f3702474" id="r_ad8d7cb3887b1e213cd445302f3702474">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad8d7cb3887b1e213cd445302f3702474">PIPELINED\_EXPRESSION\_EVALUATION</a> = "pipelined\_expression\_evaluation"</td>
      </tr>

      <tr className="memdesc:ad8d7cb3887b1e213cd445302f3702474">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Evaluate the group-by during last JoinedSet filter plan step. <br /></td>
      </tr>

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

      <tr className="memitem:a144b881d8dfe71dff5157fc55f5015c9" id="r_a144b881d8dfe71dff5157fc55f5015c9">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a144b881d8dfe71dff5157fc55f5015c9">HAVING</a> = "having"</td>
      </tr>

      <tr className="memdesc:a144b881d8dfe71dff5157fc55f5015c9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Filter expression to apply to the aggregated results. <br /></td>
      </tr>

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

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

      <tr className="memdesc:aabe32e95440a1fec1a0f3fdcf06becb7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–use order\_by instead] String indicating how the returned values should be sorted - ascending or descending. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a495b55dd44fd0a100bff46b7219620a3">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates that the returned values should be sorted in ascending order. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a60fc4668a16118ef9dc910ade7ccfdf9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates that the returned values should be sorted in descending order. <br /></td>
      </tr>

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

      <tr className="memitem:af75fa9075aef9300c6df83d78f04e805" id="r_af75fa9075aef9300c6df83d78f04e805">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af75fa9075aef9300c6df83d78f04e805">SORT\_BY</a> = "sort\_by"</td>
      </tr>

      <tr className="memdesc:af75fa9075aef9300c6df83d78f04e805">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–use order\_by instead] String determining how the results are sorted. <br /></td>
      </tr>

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

      <tr className="memitem:aef06e28af7079aa21976474f2d0ae19b" id="r_aef06e28af7079aa21976474f2d0ae19b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aef06e28af7079aa21976474f2d0ae19b">KEY</a> = "key"</td>
      </tr>

      <tr className="memdesc:aef06e28af7079aa21976474f2d0ae19b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates that the returned values should be sorted by key, which corresponds to the grouping columns. <br /></td>
      </tr>

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

      <tr className="memitem:aee6bb7d2ed57ce491c90005be49e6e6f" id="r_aee6bb7d2ed57ce491c90005be49e6e6f">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aee6bb7d2ed57ce491c90005be49e6e6f">VALUE</a> = "value"</td>
      </tr>

      <tr className="memdesc:aee6bb7d2ed57ce491c90005be49e6e6f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Indicates that the returned values should be sorted by value, which corresponds to the aggregates. <br /></td>
      </tr>

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

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

      <tr className="memdesc:ae06b1630e13553f738a360519a7ead72">
        <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:ae06b1630e13553f738a360519a7ead72">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a868cc07decb52439bacb48510db1c26d" id="r_a868cc07decb52439bacb48510db1c26d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a868cc07decb52439bacb48510db1c26d">STRATEGY\_DEFINITION</a> = "strategy\_definition"</td>
      </tr>

      <tr className="memdesc:a868cc07decb52439bacb48510db1c26d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns. <br /></td>
      </tr>

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

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

      <tr className="memdesc:aa3e54d93649a1dc182f82d081fbef7f3">
        <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:aa3e54d93649a1dc182f82d081fbef7f3">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a5df13fd58ea362eadf7593768e4f76cd">
        <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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a>. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a23fd5b82a1429b6f2af318e7294e612c">
        <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:a23fd5b82a1429b6f2af318e7294e612c">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:af6d0b51c056f4debd16bee16cabfbb98">
        <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:af6d0b51c056f4debd16bee16cabfbb98">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

      <tr className="memdesc:aabea6aa40ad1c15e659e90b6d29e5add">
        <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:aabea6aa40ad1c15e659e90b6d29e5add">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ae86f7828634f28d6958039222074b050" id="r_ae86f7828634f28d6958039222074b050">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae86f7828634f28d6958039222074b050">CREATE\_INDEXES</a> = "create\_indexes"</td>
      </tr>

      <tr className="memdesc:ae86f7828634f28d6958039222074b050">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of columns on which to create indexes on the result table. <br /></td>
      </tr>

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

      <tr className="memitem:ac5894717b4ca84990b7e9816eeb24793" id="r_ac5894717b4ca84990b7e9816eeb24793">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ac5894717b4ca84990b7e9816eeb24793">PARTITION\_TYPE</a> = "partition\_type"</td>
      </tr>

      <tr className="memdesc:ac5894717b4ca84990b7e9816eeb24793">
        <td className="mdescLeft"> </td>
        <td className="mdescRight"><a href="/content/concepts/tables/#partitioning" target="_top">Partitioning</a> scheme to use for the result table. <br /></td>
      </tr>

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

      <tr className="memitem:a08991524b7c16f8a2a86209f2858441c" id="r_a08991524b7c16f8a2a86209f2858441c">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a08991524b7c16f8a2a86209f2858441c">RANGE</a> = "RANGE"</td>
      </tr>

      <tr className="memdesc:a08991524b7c16f8a2a86209f2858441c">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. <br /></td>
      </tr>

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

      <tr className="memitem:ada06173c832bad6c08489a7b63d55588" id="r_ada06173c832bad6c08489a7b63d55588">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ada06173c832bad6c08489a7b63d55588">INTERVAL</a> = "INTERVAL"</td>
      </tr>

      <tr className="memdesc:ada06173c832bad6c08489a7b63d55588">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. <br /></td>
      </tr>

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

      <tr className="memitem:acd2627a3b36719fc7dc7d8e105fd4e5d" id="r_acd2627a3b36719fc7dc7d8e105fd4e5d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acd2627a3b36719fc7dc7d8e105fd4e5d">LIST</a> = "LIST"</td>
      </tr>

      <tr className="memdesc:acd2627a3b36719fc7dc7d8e105fd4e5d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. <br /></td>
      </tr>

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

      <tr className="memitem:af2f13219bb1250d97abe55fc04705dda" id="r_af2f13219bb1250d97abe55fc04705dda">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af2f13219bb1250d97abe55fc04705dda">HASH</a> = "HASH"</td>
      </tr>

      <tr className="memdesc:af2f13219bb1250d97abe55fc04705dda">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. <br /></td>
      </tr>

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

      <tr className="memitem:afac01262af576ae719b54365e5761ce3" id="r_afac01262af576ae719b54365e5761ce3">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#afac01262af576ae719b54365e5761ce3">SERIES</a> = "SERIES"</td>
      </tr>

      <tr className="memdesc:afac01262af576ae719b54365e5761ce3">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>. <br /></td>
      </tr>

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

      <tr className="memitem:ad60e5c0250d8007ed26815811c692b5e" id="r_ad60e5c0250d8007ed26815811c692b5e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad60e5c0250d8007ed26815811c692b5e">PARTITION\_KEYS</a> = "partition\_keys"</td>
      </tr>

      <tr className="memdesc:ad60e5c0250d8007ed26815811c692b5e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by <a className="el" href="#a5cecc944c83016b5f6cb00f3fab1ba50">PARTITION\_DEFINITIONS</a>. <br /></td>
      </tr>

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

      <tr className="memitem:a5cecc944c83016b5f6cb00f3fab1ba50" id="r_a5cecc944c83016b5f6cb00f3fab1ba50">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5cecc944c83016b5f6cb00f3fab1ba50">PARTITION\_DEFINITIONS</a> = "partition\_definitions"</td>
      </tr>

      <tr className="memdesc:a5cecc944c83016b5f6cb00f3fab1ba50">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of partition definitions, whose format depends on the choice of <a className="el" href="#ac5894717b4ca84990b7e9816eeb24793">PARTITION\_TYPE</a>. <br /></td>
      </tr>

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

      <tr className="memitem:a5d5ebd0e63a5581842ae249121b9061f" id="r_a5d5ebd0e63a5581842ae249121b9061f">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5d5ebd0e63a5581842ae249121b9061f">IS\_AUTOMATIC\_PARTITION</a> = "is\_automatic\_partition"</td>
      </tr>

      <tr className="memdesc:a5d5ebd0e63a5581842ae249121b9061f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a>, a new partition will be created for values which don't fall into an existing partition. <br /></td>
      </tr>

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

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

      <tr className="memdesc:af84e9c8c66fa7ce1edb4777f4172ef8b">
        <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:af84e9c8c66fa7ce1edb4777f4172ef8b">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a9b436af89e4e3a9424f855e9321a984b" id="r_a9b436af89e4e3a9424f855e9321a984b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a9b436af89e4e3a9424f855e9321a984b">PIVOT</a> = "pivot"</td>
      </tr>

      <tr className="memdesc:a9b436af89e4e3a9424f855e9321a984b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Pivot column. <br /></td>
      </tr>

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

      <tr className="memitem:abf1bf256ee2da0f3264daa6b3052477a" id="r_abf1bf256ee2da0f3264daa6b3052477a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#abf1bf256ee2da0f3264daa6b3052477a">PIVOT\_VALUES</a> = "pivot\_values"</td>
      </tr>

      <tr className="memdesc:abf1bf256ee2da0f3264daa6b3052477a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of the values in the <a className="el" href="#a9b436af89e4e3a9424f855e9321a984b">PIVOT</a> column. <br /></td>
      </tr>

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

      <tr className="memitem:af8583b762d40514caffe90b3753d12fc" id="r_af8583b762d40514caffe90b3753d12fc">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af8583b762d40514caffe90b3753d12fc">GROUPING\_SETS</a> = "grouping\_sets"</td>
      </tr>

      <tr className="memdesc:af8583b762d40514caffe90b3753d12fc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Customize the grouping attribute sets to compute the aggregates. <br /></td>
      </tr>

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

      <tr className="memitem:aa1d86da990da1c92be7699d05db68b54" id="r_aa1d86da990da1c92be7699d05db68b54">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aa1d86da990da1c92be7699d05db68b54">ROLLUP</a> = "rollup"</td>
      </tr>

      <tr className="memdesc:aa1d86da990da1c92be7699d05db68b54">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">This option is used to specify the multilevel aggregates. <br /></td>
      </tr>

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

      <tr className="memitem:ad8f375f67e66b9f35ab0f2c3c4e1f458" id="r_ad8f375f67e66b9f35ab0f2c3c4e1f458">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad8f375f67e66b9f35ab0f2c3c4e1f458">CUBE</a> = "cube"</td>
      </tr>

      <tr className="memdesc:ad8f375f67e66b9f35ab0f2c3c4e1f458">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">This option is used to specify the multidimensional aggregates. <br /></td>
      </tr>

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

      <tr className="memitem:a3774a0c1f7662a6fdd88d3aeaf736e85" id="r_a3774a0c1f7662a6fdd88d3aeaf736e85">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3774a0c1f7662a6fdd88d3aeaf736e85">SHARD\_KEY</a> = "shard\_key"</td>
      </tr>

      <tr className="memdesc:a3774a0c1f7662a6fdd88d3aeaf736e85">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of the columns to be sharded on; e.g. <br /></td>
      </tr>

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

    <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_1AggregateGroupByRequest#aadc486025c5577fa0c66a5271d1a38ed" title="Optional parameters.">AggregateGroupByRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00093">93</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a495b55dd44fd0a100bff46b7219620a3">◆ </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.AggregateGroupByRequest.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>Indicates that the returned values should be sorted in ascending order. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00202">202</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af6d0b51c056f4debd16bee16cabfbb98">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00401">401</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aabea6aa40ad1c15e659e90b6d29e5add">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00408">408</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a23fd5b82a1429b6f2af318e7294e612c">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00394">394</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a6b08a07880f8a648e1bf30dd0c9c19e5">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> and use <a className="el" href="/content/api/cs/classkinetica_1_1Kinetica#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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00145">145</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa3e54d93649a1dc182f82d081fbef7f3">◆ </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.AggregateGroupByRequest.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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00267">267</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae86f7828634f28d6958039222074b050">◆ </a></span>CREATE\_INDEXES</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.AggregateGroupByRequest.Options.CREATE\_INDEXES = "create\_indexes"</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 columns on which to create indexes on the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00415">415</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a4a584ee3ce95955100dd509039b8789b">◆ </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.AggregateGroupByRequest.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="#a838cd36539c612040de6a3b633f41053">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a>. </p>
        <p>If <a className="el" href="#a1fe48bed5997449a14cebfe879c1ecae">RESULT\_TABLE\_PERSIST</a> is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">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_1AggregateGroupByResponse_1_1Info#afb376ff5fca7356798accf2f1198dda8">QUALIFIED\_RESULT\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00124">124</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad8f375f67e66b9f35ab0f2c3c4e1f458">◆ </a></span>CUBE</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.AggregateGroupByRequest.Options.CUBE = "cube"</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>This option is used to specify the multidimensional aggregates. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00569">569</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a60fc4668a16118ef9dc910ade7ccfdf9">◆ </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.AggregateGroupByRequest.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>Indicates that the returned values should be sorted in descending order. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00206">206</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3a55b9aafe05c74e9e17034a8507d85a">◆ </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.AggregateGroupByRequest.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 prior to computing the aggregate group by. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00149">149</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afc9ee6260782b6392540cbfcfe528bc4">◆ </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.AggregateGroupByRequest.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_1AggregateGroupByRequest_1_1Options" title="A set of string constants for the parameter AggregateGroupByRequest.options.">AggregateGroupByRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00132">132</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af8583b762d40514caffe90b3753d12fc">◆ </a></span>GROUPING\_SETS</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.AggregateGroupByRequest.Options.GROUPING\_SETS = "grouping\_sets"</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>Customize the grouping attribute sets to compute the aggregates. </p>
        <p>These sets can include ROLLUP or CUBE operators. The attribute sets should be enclosed in parentheses and can include composite attributes. All attributes specified in the grouping sets must present in the group-by attributes.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00561">561</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af2f13219bb1250d97abe55fc04705dda">◆ </a></span>HASH</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.AggregateGroupByRequest.Options.HASH = "HASH"</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>Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00483">483</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a144b881d8dfe71dff5157fc55f5015c9">◆ </a></span>HAVING</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.AggregateGroupByRequest.Options.HAVING = "having"</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 aggregated results. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00173">173</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ada06173c832bad6c08489a7b63d55588">◆ </a></span>INTERVAL</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.AggregateGroupByRequest.Options.INTERVAL = "INTERVAL"</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>Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00473">473</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5d5ebd0e63a5581842ae249121b9061f">◆ </a></span>IS\_AUTOMATIC\_PARTITION</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.AggregateGroupByRequest.Options.IS\_AUTOMATIC\_PARTITION = "is\_automatic\_partition"</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="#a838cd36539c612040de6a3b633f41053">TRUE</a>, a new partition will be created for values which don't fall into an existing partition. </p>
        <p>Currently only supported for <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitions</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00538">538</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aef06e28af7079aa21976474f2d0ae19b">◆ </a></span>KEY</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.AggregateGroupByRequest.Options.KEY = "key"</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 that the returned values should be sorted by key, which corresponds to the grouping columns. </p>
        <p>If you have multiple grouping columns (and are sorting by key), it will first sort the first grouping column, then the second grouping column, etc.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00243">243</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#acd2627a3b36719fc7dc7d8e105fd4e5d">◆ </a></span>LIST</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.AggregateGroupByRequest.Options.LIST = "LIST"</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>Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00478">478</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae06b1630e13553f738a360519a7ead72">◆ </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.AggregateGroupByRequest.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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00256">256</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5cecc944c83016b5f6cb00f3fab1ba50">◆ </a></span>PARTITION\_DEFINITIONS</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.AggregateGroupByRequest.Options.PARTITION\_DEFINITIONS = "partition\_definitions"</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 partition definitions, whose format depends on the choice of <a className="el" href="#ac5894717b4ca84990b7e9816eeb24793">PARTITION\_TYPE</a>. </p>
        <p>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.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00513">513</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad60e5c0250d8007ed26815811c692b5e">◆ </a></span>PARTITION\_KEYS</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.AggregateGroupByRequest.Options.PARTITION\_KEYS = "partition\_keys"</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 partition keys, which are the columns or column expressions by which records will be assigned to partitions defined by <a className="el" href="#a5cecc944c83016b5f6cb00f3fab1ba50">PARTITION\_DEFINITIONS</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00495">495</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac5894717b4ca84990b7e9816eeb24793">◆ </a></span>PARTITION\_TYPE</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.AggregateGroupByRequest.Options.PARTITION\_TYPE = "partition\_type"</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 href="/content/concepts/tables/#partitioning" target="_top">Partitioning</a> scheme to use for the result table. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a08991524b7c16f8a2a86209f2858441c">RANGE</a>: Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </li>
          <li> <a className="el" href="#ada06173c832bad6c08489a7b63d55588">INTERVAL</a>: Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </li>
          <li> <a className="el" href="#acd2627a3b36719fc7dc7d8e105fd4e5d">LIST</a>: Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </li>
          <li> <a className="el" href="#af2f13219bb1250d97abe55fc04705dda">HASH</a>: Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </li>
          <li> <a className="el" href="#afac01262af576ae719b54365e5761ce3">SERIES</a>: Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>. </li>
        </ul>

        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00463">463</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad8d7cb3887b1e213cd445302f3702474">◆ </a></span>PIPELINED\_EXPRESSION\_EVALUATION</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.AggregateGroupByRequest.Options.PIPELINED\_EXPRESSION\_EVALUATION = "pipelined\_expression\_evaluation"</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>Evaluate the group-by during last JoinedSet filter plan step. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00169">169</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a9b436af89e4e3a9424f855e9321a984b">◆ </a></span>PIVOT</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.AggregateGroupByRequest.Options.PIVOT = "pivot"</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>Pivot column. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00546">546</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#abf1bf256ee2da0f3264daa6b3052477a">◆ </a></span>PIVOT\_VALUES</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.AggregateGroupByRequest.Options.PIVOT\_VALUES = "pivot\_values"</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 values in the <a className="el" href="#a9b436af89e4e3a9424f855e9321a984b">PIVOT</a> column. </p>
        <p>The list provided will become the column header prefixes in the output.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00553">553</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a08991524b7c16f8a2a86209f2858441c">◆ </a></span>RANGE</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.AggregateGroupByRequest.Options.RANGE = "RANGE"</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>Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00468">468</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">◆ </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.AggregateGroupByRequest.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 a 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>Column names (group-by and aggregate fields) need to be given aliases e.g. \["FChar256 as fchar256", "sum(FDouble) as sfd"]. If present, no results are returned in the response. This option is not available if one of the grouping attributes is an unrestricted string (i.e.; not charN) type.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00280">280</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5d5717399eff0372c06fd66fc36dd410">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00333">333</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af67899b3569e580238c3273c0fb4a33f">◆ </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.AggregateGroupByRequest.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="#a838cd36539c612040de6a3b633f41053">TRUE</a> then set a primary key for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00357">357</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa23b98a822957bb640dcdb9a05192365">◆ </a></span>RESULT\_TABLE\_GENERATE\_SOFT\_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.AggregateGroupByRequest.Options.RESULT\_TABLE\_GENERATE\_SOFT\_PK = "result\_table\_generate\_soft\_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="#a838cd36539c612040de6a3b633f41053">TRUE</a> then set a soft primary key for the result table. </p>
        <p>Must be used in combination with the <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> option. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00381">381</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a1fe48bed5997449a14cebfe879c1ecae">◆ </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.AggregateGroupByRequest.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="#a838cd36539c612040de6a3b633f41053">TRUE</a>, then the result table specified in <a className="el" href="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a> will be persisted and will not expire unless a <a className="el" href="#a5df13fd58ea362eadf7593768e4f76cd">TTL</a> is specified. </p>
        <p>If <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>, then the result table will be an in-memory table and will expire unless a <a className="el" href="#a5df13fd58ea362eadf7593768e4f76cd">TTL</a> is specified otherwise. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a838cd36539c612040de6a3b633f41053">TRUE</a> </li>
          <li> <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#afc9ee6260782b6392540cbfcfe528bc4">FALSE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00310">310</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa1d86da990da1c92be7699d05db68b54">◆ </a></span>ROLLUP</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.AggregateGroupByRequest.Options.ROLLUP = "rollup"</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>This option is used to specify the multilevel aggregates. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00565">565</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afac01262af576ae719b54365e5761ce3">◆ </a></span>SERIES</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.AggregateGroupByRequest.Options.SERIES = "SERIES"</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>Use <a href="/content/concepts/tables/#partitioning-by-series" target="_top">series partitioning</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00488">488</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3774a0c1f7662a6fdd88d3aeaf736e85">◆ </a></span>SHARD\_KEY</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.AggregateGroupByRequest.Options.SHARD\_KEY = "shard\_key"</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 sharded on; e.g. </p>
        <p>'column1, column2'. </p>
        <p>The columns specified must be present in <a className="el" href="/content/api/cs/classkinetica_1_1AggregateGroupByRequest#af63b70cacf486d4c470559abdcb30a30" title="List of one or more column names, expressions, and aggregate expressions.">AggregateGroupByRequest.column\_names</a>. If any alias is given for any column name, the alias must be used, rather than the original column name. The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00577">577</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af75fa9075aef9300c6df83d78f04e805">◆ </a></span>SORT\_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.AggregateGroupByRequest.Options.SORT\_BY = "sort\_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>\[DEPRECATED–use order\_by instead] String determining how the results are sorted. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#aef06e28af7079aa21976474f2d0ae19b">KEY</a>: Indicates that the returned values should be sorted by key, which corresponds to the grouping columns. If you have multiple grouping columns (and are sorting by key), it will first sort the first grouping column, then the second grouping column, etc. </li>
          <li> <a className="el" href="#aee6bb7d2ed57ce491c90005be49e6e6f">VALUE</a>: Indicates that the returned values should be sorted by value, which corresponds to the aggregates. If you have multiple aggregates (and are sorting by value), it will first sort by the first aggregate, then the second aggregate, etc. </li>
        </ul>

        <p>The default value is <a className="el" href="#aee6bb7d2ed57ce491c90005be49e6e6f">VALUE</a>.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00236">236</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aabe32e95440a1fec1a0f3fdcf06becb7">◆ </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.AggregateGroupByRequest.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>\[DEPRECATED–use order\_by instead] String indicating how the returned values should be sorted - ascending or descending. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a495b55dd44fd0a100bff46b7219620a3">ASCENDING</a>: Indicates that the returned values should be sorted in ascending order. </li>
          <li> <a className="el" href="#a60fc4668a16118ef9dc910ade7ccfdf9">DESCENDING</a>: Indicates that the returned values should be sorted in descending order. </li>
        </ul>

        <p>The default value is <a className="el" href="#a495b55dd44fd0a100bff46b7219620a3">ASCENDING</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00198">198</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a868cc07decb52439bacb48510db1c26d">◆ </a></span>STRATEGY\_DEFINITION</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.AggregateGroupByRequest.Options.STRATEGY\_DEFINITION = "strategy\_definition"</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 <a href="/content/rm/concepts/#tier-strategies" target="_top">tier strategy</a> for the table and its columns. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00261">261</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a838cd36539c612040de6a3b633f41053">◆ </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.AggregateGroupByRequest.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_1AggregateGroupByRequest_1_1Options" title="A set of string constants for the parameter AggregateGroupByRequest.options.">AggregateGroupByRequest.Options</a> options. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00128">128</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5df13fd58ea362eadf7593768e4f76cd">◆ </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.AggregateGroupByRequest.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="#aabc2f4ef62b509abe7d93b2f78dc9a8d">RESULT\_TABLE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00387">387</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aee6bb7d2ed57ce491c90005be49e6e6f">◆ </a></span>VALUE</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.AggregateGroupByRequest.Options.VALUE = "value"</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 that the returned values should be sorted by value, which corresponds to the aggregates. </p>
        <p>If you have multiple aggregates (and are sorting by value), it will first sort by the first aggregate, then the second aggregate, etc.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00250">250</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af84e9c8c66fa7ce1edb4777f4172ef8b">◆ </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.AggregateGroupByRequest.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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source#l00543">543</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a>.</p>
      </div>
    </div>

    <hr />

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

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2AggregateGroupBy_8cs_source">AggregateGroupBy.cs</a></li>
    </ul>
  </div>
</div>