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

> kinetica.AggregateUnpivotRequest.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_1AggregateUnpivotRequest#a18cd0708760575cf0622e05156a0def0" title="Optional parameters.">AggregateUnpivotRequest.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:afb533db2611755533a5557bf7b3f29bb" id="r_afb533db2611755533a5557bf7b3f29bb">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#afb533db2611755533a5557bf7b3f29bb">CREATE\_TEMP\_TABLE</a> = "create\_temp\_table"</td>
      </tr>

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a0b095211dc6a901dc5d5eba400b9d19d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–please specify the containing schema as part of <a className="el" href="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">RESULT\_TABLE</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memitem:a3d826f39af96e0949aa909445cc74214" id="r_a3d826f39af96e0949aa909445cc74214">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3d826f39af96e0949aa909445cc74214">LIMIT</a> = "limit"</td>
      </tr>

      <tr className="memdesc:a3d826f39af96e0949aa909445cc74214">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The number of records to keep. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:a8a5cd47ea438d331a832eabbfccea55a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">View this result table is part of. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a700dea93c17890c99e38317e7023e0b2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma-separated list of columns on which to create indexes on the table specified in <a className="el" href="#a1e8ab3e318f8d848dc5f9c9d0fd08098">RESULT\_TABLE</a>. <br /></td>
      </tr>

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

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

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

      <tr className="separator:a015bf153889cb4e44760891bd615bb43">
        <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_1AggregateUnpivotRequest#a18cd0708760575cf0622e05156a0def0" title="Optional parameters.">AggregateUnpivotRequest.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_2AggregateUnpivot_8cs_source#l00048">48</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#ad10ad4ddae3eb7410deae309d264c2c1">◆ </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.AggregateUnpivotRequest.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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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_2AggregateUnpivot_8cs_source#l00166">166</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0411d1f6f16bde7eca1d14158947098d">◆ </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.AggregateUnpivotRequest.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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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_2AggregateUnpivot_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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a1c4e5af1914aabc6ce4cd5aa89ea7516">◆ </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.AggregateUnpivotRequest.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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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_2AggregateUnpivot_8cs_source#l00159">159</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0b095211dc6a901dc5d5eba400b9d19d">◆ </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.AggregateUnpivotRequest.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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">RESULT\_TABLE</a>. </p>
        <p>If the schema 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_2AggregateUnpivot_8cs_source#l00100">100</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad57ac28e07d323ed075a45a3cd738982">◆ </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.AggregateUnpivotRequest.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_2AggregateUnpivot_8cs_source#l00179">179</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a700dea93c17890c99e38317e7023e0b2">◆ </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.AggregateUnpivotRequest.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 table specified in <a className="el" href="#a1e8ab3e318f8d848dc5f9c9d0fd08098">RESULT\_TABLE</a>. </p>
        <p>The columns specified must be present in output column names. If any alias is given for any column name, the alias must be used, rather than the original column name.</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_2AggregateUnpivot_8cs_source#l00203">203</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afb533db2611755533a5557bf7b3f29bb">◆ </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.AggregateUnpivotRequest.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="#ae90d247d74994d1e4fe512989eea7e2c">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="#a1e8ab3e318f8d848dc5f9c9d0fd08098">RESULT\_TABLE</a>. </p>
        <p>If <a className="el" href="#ad99304643156bd971822be5159059ec4">RESULT\_TABLE\_PERSIST</a> is <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">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_1AggregateUnpivotResponse_1_1Info#a160c76134e9b9c8c3bb011f8d0f36746">QUALIFIED\_RESULT\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ae90d247d74994d1e4fe512989eea7e2c">TRUE</a> </li>
          <li> <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">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_2AggregateUnpivot_8cs_source#l00079">79</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a92044a5cbb0d6fae7556975bc84db366">◆ </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.AggregateUnpivotRequest.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 unpivot processing. </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_2AggregateUnpivot_8cs_source#l00144">144</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">◆ </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.AggregateUnpivotRequest.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_1AggregateUnpivotRequest_1_1Options" title="A set of string constants for the parameter AggregateUnpivotRequest.options.">AggregateUnpivotRequest.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_2AggregateUnpivot_8cs_source#l00087">87</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3d826f39af96e0949aa909445cc74214">◆ </a></span>LIMIT</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.AggregateUnpivotRequest.Options.LIMIT = "limit"</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 number of records to keep. </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_2AggregateUnpivot_8cs_source#l00183">183</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0fb8c61f1f1729b08962b6774a65b895">◆ </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.AggregateUnpivotRequest.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; e.g. </p>
        <p>'timestamp asc, x desc'. </p>
        <p>The columns specified must be present in input table. 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_2AggregateUnpivot_8cs_source#l00152">152</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a1e8ab3e318f8d848dc5f9c9d0fd08098">◆ </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.AggregateUnpivotRequest.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>If present, no results are returned in the response. </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_2AggregateUnpivot_8cs_source#l00110">110</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

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

        <ul>
          <li> <a className="el" href="#ae90d247d74994d1e4fe512989eea7e2c">TRUE</a> </li>
          <li> <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">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_2AggregateUnpivot_8cs_source#l00226">226</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

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

        <ul>
          <li> <a className="el" href="#ae90d247d74994d1e4fe512989eea7e2c">TRUE</a> </li>
          <li> <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ad08d12c994ed4f4d5cf4bb701a2a2bdc">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_2AggregateUnpivot_8cs_source#l00140">140</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae90d247d74994d1e4fe512989eea7e2c">◆ </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.AggregateUnpivotRequest.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_1AggregateUnpivotRequest_1_1Options" title="A set of string constants for the parameter AggregateUnpivotRequest.options.">AggregateUnpivotRequest.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_2AggregateUnpivot_8cs_source#l00083">83</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad7cee8a9d37c19dc9f99cabd94717e66">◆ </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.AggregateUnpivotRequest.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="#a1e8ab3e318f8d848dc5f9c9d0fd08098">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_2AggregateUnpivot_8cs_source#l00189">189</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8a5cd47ea438d331a832eabbfccea55a">◆ </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.AggregateUnpivotRequest.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>View this result table is part of. </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_2AggregateUnpivot_8cs_source#l00193">193</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_2AggregateUnpivot_8cs_source">AggregateUnpivot.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_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2AggregateUnpivot_8cs_source">AggregateUnpivot.cs</a></li>
    </ul>
  </div>
</div>