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

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

      <tr className="memdesc:a2aef96f3263d7b8973d0dafafc7cfb88">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

      <tr className="memdesc:a4f0bac244071daccc0ee99c700e67c63">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">\[DEPRECATED–please specify the containing schema for the projection as part of <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</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 for the projection. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a6cb03ecaf20f98e460241bacb1944ca7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">An optional filter <a href="/content/concepts/expressions/" target="_top">expression</a> to be applied to the source table prior to the projection. <br /></td>
      </tr>

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

      <tr className="memitem:a3875d2f89fcd70bf1d3508940d15218b" id="r_a3875d2f89fcd70bf1d3508940d15218b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3875d2f89fcd70bf1d3508940d15218b">IS\_REPLICATED</a> = "is\_replicated"</td>
      </tr>

      <tr className="memdesc:a3875d2f89fcd70bf1d3508940d15218b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> then the projection will be replicated even if the source table is not. <br /></td>
      </tr>

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

      <tr className="memitem:a87724e7ac5923cb58959bfc265597999" id="r_a87724e7ac5923cb58959bfc265597999">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a87724e7ac5923cb58959bfc265597999">OFFSET</a> = "offset"</td>
      </tr>

      <tr className="memdesc:a87724e7ac5923cb58959bfc265597999">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The number of initial results to skip (this can be useful for paging through the results). <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:acadf98a93effa715dfbada891287e138">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the projection specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</a>. <br /></td>
      </tr>

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

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

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

      <tr className="memitem:a75e843dad2c7696be158b5ea66bf351e" id="r_a75e843dad2c7696be158b5ea66bf351e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a75e843dad2c7696be158b5ea66bf351e">PERSIST</a> = "persist"</td>
      </tr>

      <tr className="memdesc:a75e843dad2c7696be158b5ea66bf351e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, then the projection specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</a> will be persisted and will not expire unless a <a className="el" href="#acadf98a93effa715dfbada891287e138">TTL</a> is specified. <br /></td>
      </tr>

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

      <tr className="memitem:ad65eb9158729733fea57f7080d167f31" id="r_ad65eb9158729733fea57f7080d167f31">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad65eb9158729733fea57f7080d167f31">PRESERVE\_DICT\_ENCODING</a> = "preserve\_dict\_encoding"</td>
      </tr>

      <tr className="memdesc:ad65eb9158729733fea57f7080d167f31">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, then columns that were dict encoded in the source table will be dict encoded in the projection. <br /></td>
      </tr>

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

      <tr className="memitem:aeab70d782ccfe1df9c21230d4a3c8f25" id="r_aeab70d782ccfe1df9c21230d4a3c8f25">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aeab70d782ccfe1df9c21230d4a3c8f25">RETAIN\_PARTITIONS</a> = "retain\_partitions"</td>
      </tr>

      <tr className="memdesc:aeab70d782ccfe1df9c21230d4a3c8f25">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Determines whether the created projection will retain the partitioning scheme from the source table. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a3102d525f0bb1c0b3ed0bd67c8378b62">
        <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="#a47c71fa7fbde0080add3631fb2679337">PARTITION\_DEFINITIONS</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

      <tr className="memdesc:a27375b3f1764acd8b55b297926010ae7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">ID of view of which this projection is a member. <br /></td>
      </tr>

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

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

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

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

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

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

      <tr className="memitem:af88ffe10803227f5bba60213398b078b" id="r_af88ffe10803227f5bba60213398b078b">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af88ffe10803227f5bba60213398b078b">JOIN\_WINDOW\_FUNCTIONS</a> = "join\_window\_functions"</td>
      </tr>

      <tr className="memdesc:af88ffe10803227f5bba60213398b078b">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set, window functions which require a reshard will be computed separately and joined back together, if the width of the projection is greater than the join\_window\_functions\_threshold. <br /></td>
      </tr>

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

      <tr className="memitem:a109bab5703ea5d35bdf5053793e8bef4" id="r_a109bab5703ea5d35bdf5053793e8bef4">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a109bab5703ea5d35bdf5053793e8bef4">JOIN\_WINDOW\_FUNCTIONS\_THRESHOLD</a> = "join\_window\_functions\_threshold"</td>
      </tr>

      <tr className="memdesc:a109bab5703ea5d35bdf5053793e8bef4">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If the projection is greater than this width (in bytes), then window functions which require a reshard will be computed separately and joined back together. <br /></td>
      </tr>

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

      <tr className="memitem:a5f8350a29667fc0b23d3eb3101b13362" id="r_a5f8350a29667fc0b23d3eb3101b13362">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5f8350a29667fc0b23d3eb3101b13362">QUALIFY\_FILTER</a> = "qualify\_filter"</td>
      </tr>

      <tr className="memdesc:a5f8350a29667fc0b23d3eb3101b13362">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">An optional filter <a href="/content/concepts/expressions/" target="_top">expression</a> applied to the projection after window function evaluation, equivalent to a SQL QUALIFY clause. <br /></td>
      </tr>

      <tr className="separator:a5f8350a29667fc0b23d3eb3101b13362">
        <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_1CreateProjectionRequest#a1ee7cc717b67527a9c743cf7b42d9e10" title="Optional parameters.">CreateProjectionRequest.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_2CreateProjection_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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#af724fbb531fed805a90c1227bb3fed98">◆ </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.CreateProjectionRequest.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 this projection. </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_2CreateProjection_8cs_source#l00150">150</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a2c167f501d317ed1da05f7984d9b6330">◆ </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.CreateProjectionRequest.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 this projection. </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_2CreateProjection_8cs_source#l00154">154</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3c6980294b8e3d54cf381e9ef43afc06">◆ </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.CreateProjectionRequest.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 this projection. </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_2CreateProjection_8cs_source#l00146">146</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a4f0bac244071daccc0ee99c700e67c63">◆ </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.CreateProjectionRequest.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 for the projection as part of <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</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 for the projection. </p>
        <p>If the schema is non-existent, it will be automatically created. 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_2CreateProjection_8cs_source#l00096">96</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#abb7bd645cc7bd4046df3d276d67ed444">◆ </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.CreateProjectionRequest.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 projection'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_2CreateProjection_8cs_source#l00384">384</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a9ef978d3e4f1665ebf1811933773c3b3">◆ </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.CreateProjectionRequest.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 projection. </p>
        <p>The columns specified must be present in <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a4a7321b046bfa4779ccb74cd567a7aa4" title="List of columns from CreateProjectionRequest.table_name to be included in the projection.">CreateProjectionRequest.column\_names</a>. 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_2CreateProjection_8cs_source#l00162">162</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a2aef96f3263d7b8973d0dafafc7cfb88">◆ </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.CreateProjectionRequest.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="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, a unique temporary table name will be generated in the sys\_temp schema and used in place of <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</a>. </p>
        <p>If <a className="el" href="#a75e843dad2c7696be158b5ea66bf351e">PERSIST</a> is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_1CreateProjectionResponse_1_1Info#aea0e5190d3a4b1425b5a899247c62aef">QUALIFIED\_PROJECTION\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_2CreateProjection_8cs_source#l00078">78</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a6cb03ecaf20f98e460241bacb1944ca7">◆ </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.CreateProjectionRequest.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>An optional filter <a href="/content/concepts/expressions/" target="_top">expression</a> to be applied to the source table prior to the projection. </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_2CreateProjection_8cs_source#l00103">103</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">◆ </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.CreateProjectionRequest.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_1CreateProjectionRequest_1_1Options" title="A set of string constants for the parameter CreateProjectionRequest.options.">CreateProjectionRequest.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_2CreateProjection_8cs_source#l00086">86</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a96f7be043eed2f3ea15831fdfe88ad8e">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00314">314</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8f07f2d83d165bb777dd62b41ebcff55">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00304">304</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a03193a433d7b335d8f8cad27dda5a3c3">◆ </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.CreateProjectionRequest.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="#ad15c044800c4149c3e60bab80957a503">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="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_2CreateProjection_8cs_source#l00369">369</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3875d2f89fcd70bf1d3508940d15218b">◆ </a></span>IS\_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.CreateProjectionRequest.Options.IS\_REPLICATED = "is\_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>If <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> then the projection will be replicated even if the source table is not. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_2CreateProjection_8cs_source#l00125">125</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af88ffe10803227f5bba60213398b078b">◆ </a></span>JOIN\_WINDOW\_FUNCTIONS</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.CreateProjectionRequest.Options.JOIN\_WINDOW\_FUNCTIONS = "join\_window\_functions"</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 set, window functions which require a reshard will be computed separately and joined back together, if the width of the projection is greater than the join\_window\_functions\_threshold. </p>
        <p>The default value is 'true'.</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_2CreateProjection_8cs_source#l00391">391</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a109bab5703ea5d35bdf5053793e8bef4">◆ </a></span>JOIN\_WINDOW\_FUNCTIONS\_THRESHOLD</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.CreateProjectionRequest.Options.JOIN\_WINDOW\_FUNCTIONS\_THRESHOLD = "join\_window\_functions\_threshold"</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 the projection is greater than this width (in bytes), then window functions which require a reshard will be computed separately and joined back together. </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_2CreateProjection_8cs_source#l00397">397</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac71c2a23fd1728f9099e7f46dae6e119">◆ </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.CreateProjectionRequest.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 '-9999'.</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_2CreateProjection_8cs_source#l00134">134</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ab02347301266a6926843ccd868ac0c15">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00309">309</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a87724e7ac5923cb58959bfc265597999">◆ </a></span>OFFSET</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.CreateProjectionRequest.Options.OFFSET = "offset"</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 initial results to skip (this can be useful for paging through the results). </p>
        <p>The default value is '0'.</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_2CreateProjection_8cs_source#l00130">130</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a637e845a09b79e724140334e5f8a0220">◆ </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.CreateProjectionRequest.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 <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a4a7321b046bfa4779ccb74cd567a7aa4" title="List of columns from CreateProjectionRequest.table_name to be included in the projection.">CreateProjectionRequest.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_2CreateProjection_8cs_source#l00142">142</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a47c71fa7fbde0080add3631fb2679337">◆ </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.CreateProjectionRequest.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="#ad6b678abf70cb4aff828542ef4d4d821">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_2CreateProjection_8cs_source#l00344">344</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3102d525f0bb1c0b3ed0bd67c8378b62">◆ </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.CreateProjectionRequest.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="#a47c71fa7fbde0080add3631fb2679337">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_2CreateProjection_8cs_source#l00326">326</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad6b678abf70cb4aff828542ef4d4d821">◆ </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.CreateProjectionRequest.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. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad6882c5ef4be2ad441f933587fe060c0">RANGE</a>: Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </li>
          <li> <a className="el" href="#a8f07f2d83d165bb777dd62b41ebcff55">INTERVAL</a>: Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </li>
          <li> <a className="el" href="#ab02347301266a6926843ccd868ac0c15">LIST</a>: Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </li>
          <li> <a className="el" href="#a96f7be043eed2f3ea15831fdfe88ad8e">HASH</a>: Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </li>
          <li> <a className="el" href="#a83754508260bf221c8b97041f04cc03b">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_2CreateProjection_8cs_source#l00294">294</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a75e843dad2c7696be158b5ea66bf351e">◆ </a></span>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.CreateProjectionRequest.Options.PERSIST = "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="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, then the projection specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</a> will be persisted and will not expire unless a <a className="el" href="#acadf98a93effa715dfbada891287e138">TTL</a> is specified. </p>
        <p>If <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a>, then the projection will be an in-memory table and will expire unless a <a className="el" href="#acadf98a93effa715dfbada891287e138">TTL</a> is specified otherwise. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_2CreateProjection_8cs_source#l00205">205</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad65eb9158729733fea57f7080d167f31">◆ </a></span>PRESERVE\_DICT\_ENCODING</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.CreateProjectionRequest.Options.PRESERVE\_DICT\_ENCODING = "preserve\_dict\_encoding"</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="#ad15c044800c4149c3e60bab80957a503">TRUE</a>, then columns that were dict encoded in the source table will be dict encoded in the projection. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</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_2CreateProjection_8cs_source#l00227">227</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5f8350a29667fc0b23d3eb3101b13362">◆ </a></span>QUALIFY\_FILTER</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.CreateProjectionRequest.Options.QUALIFY\_FILTER = "qualify\_filter"</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>An optional filter <a href="/content/concepts/expressions/" target="_top">expression</a> applied to the projection after window function evaluation, equivalent to a SQL QUALIFY clause. </p>
        <p>May reference window function aliases as well as any other column in the projection. Rows for which the expression evaluates to false (or NULL) are removed from the projection. 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_2CreateProjection_8cs_source#l00407">407</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad6882c5ef4be2ad441f933587fe060c0">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00299">299</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aeab70d782ccfe1df9c21230d4a3c8f25">◆ </a></span>RETAIN\_PARTITIONS</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.CreateProjectionRequest.Options.RETAIN\_PARTITIONS = "retain\_partitions"</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>Determines whether the created projection will retain the partitioning scheme from the source table. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#ad15c044800c4149c3e60bab80957a503">TRUE</a> </li>
          <li> <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a8c07c24fa0e0900c88cb7c4cd1f1c11a">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_2CreateProjection_8cs_source#l00247">247</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a83754508260bf221c8b97041f04cc03b">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00319">319</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a569f8a5089d86e6a33b0a4ac6f664167">◆ </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.CreateProjectionRequest.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_1CreateProjectionRequest#a4a7321b046bfa4779ccb74cd567a7aa4" title="List of columns from CreateProjectionRequest.table_name to be included in the projection.">CreateProjectionRequest.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_2CreateProjection_8cs_source#l00175">175</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#adadf59e524ed1a00d01118a6ed6453c9">◆ </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.CreateProjectionRequest.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_2CreateProjection_8cs_source#l00378">378</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad15c044800c4149c3e60bab80957a503">◆ </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.CreateProjectionRequest.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_1CreateProjectionRequest_1_1Options" title="A set of string constants for the parameter CreateProjectionRequest.options.">CreateProjectionRequest.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_2CreateProjection_8cs_source#l00082">82</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#acadf98a93effa715dfbada891287e138">◆ </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.CreateProjectionRequest.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 projection specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateProjectionRequest#a5a4b0ee66b65afdcb045e02551a9a49a" title="Name of the projection to be created, in [schema_name.">CreateProjectionRequest.projection\_name</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_2CreateProjection_8cs_source#l00167">167</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_2CreateProjection_8cs_source">CreateProjection.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a27375b3f1764acd8b55b297926010ae7">◆ </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.CreateProjectionRequest.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 this projection is 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_2CreateProjection_8cs_source#l00373">373</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_2CreateProjection_8cs_source">CreateProjection.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_2CreateProjection_8cs_source">CreateProjection.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2CreateProjection_8cs_source">CreateProjection.cs</a></li>
    </ul>
  </div>
</div>