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

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

      <tr className="memdesc:a193b9821cfaadc86dee6cef2e79c663e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">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_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

      <tr className="memdesc:acf4a9e79627a3b1717228efbc738ce22">
        <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_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_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 the schema for the output table. <br /></td>
      </tr>

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

      <tr className="memitem:af8600d62b19f69d419b35a6a95333405" id="r_af8600d62b19f69d419b35a6a95333405">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af8600d62b19f69d419b35a6a95333405">MODE</a> = "mode"</td>
      </tr>

      <tr className="memdesc:af8600d62b19f69d419b35a6a95333405">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The mode describes what rows of the tables being unioned will be retained. <br /></td>
      </tr>

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

      <tr className="memitem:af18332ed052a4d1c46ed8fe092bc4346" id="r_af18332ed052a4d1c46ed8fe092bc4346">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#af18332ed052a4d1c46ed8fe092bc4346">UNION\_ALL</a> = "union\_all"</td>
      </tr>

      <tr className="memdesc:af18332ed052a4d1c46ed8fe092bc4346">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all rows from the specified tables. <br /></td>
      </tr>

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

      <tr className="memitem:a5232e7e0ced4d7056caf994d554b1297" id="r_a5232e7e0ced4d7056caf994d554b1297">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5232e7e0ced4d7056caf994d554b1297">UNION</a> = "union"</td>
      </tr>

      <tr className="memdesc:a5232e7e0ced4d7056caf994d554b1297">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all unique rows from the specified tables (synonym for <a className="el" href="#a311485fbbaa8581bd72da27571164633">UNION\_DISTINCT</a>). <br /></td>
      </tr>

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

      <tr className="memitem:a311485fbbaa8581bd72da27571164633" id="r_a311485fbbaa8581bd72da27571164633">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a311485fbbaa8581bd72da27571164633">UNION\_DISTINCT</a> = "union\_distinct"</td>
      </tr>

      <tr className="memdesc:a311485fbbaa8581bd72da27571164633">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all unique rows from the specified tables. <br /></td>
      </tr>

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

      <tr className="memitem:ae2cbe1811cbe4956c82d55a90a43fa78" id="r_ae2cbe1811cbe4956c82d55a90a43fa78">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae2cbe1811cbe4956c82d55a90a43fa78">EXCEPT</a> = "except"</td>
      </tr>

      <tr className="memdesc:ae2cbe1811cbe4956c82d55a90a43fa78">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables). <br /></td>
      </tr>

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

      <tr className="memitem:a3d1df32abeb6a97f5df98536cb92bbc3" id="r_a3d1df32abeb6a97f5df98536cb92bbc3">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3d1df32abeb6a97f5df98536cb92bbc3">EXCEPT\_ALL</a> = "except\_all"</td>
      </tr>

      <tr className="memdesc:a3d1df32abeb6a97f5df98536cb92bbc3">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables). <br /></td>
      </tr>

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

      <tr className="memitem:a3486ebd5b5b2ec8bdcb3d693803139c6" id="r_a3486ebd5b5b2ec8bdcb3d693803139c6">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3486ebd5b5b2ec8bdcb3d693803139c6">INTERSECT</a> = "intersect"</td>
      </tr>

      <tr className="memdesc:a3486ebd5b5b2ec8bdcb3d693803139c6">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all unique rows that appear in both of the specified tables (only works on 2 tables). <br /></td>
      </tr>

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

      <tr className="memitem:a2b1f40ecf7218561cfb059fb4feaca05" id="r_a2b1f40ecf7218561cfb059fb4feaca05">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a2b1f40ecf7218561cfb059fb4feaca05">INTERSECT\_ALL</a> = "intersect\_all"</td>
      </tr>

      <tr className="memdesc:a2b1f40ecf7218561cfb059fb4feaca05">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables). <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a3fc680fdd604c0c17a32469d0e2f6d55">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a>. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a8af5c6ff03dd7b96780db720ca2b5ead">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a> will be persisted and will not expire unless a <a className="el" href="#a3fc680fdd604c0c17a32469d0e2f6d55">TTL</a> is specified. <br /></td>
      </tr>

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

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

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

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

      <tr className="memitem:a17d2aff69d10d63ba5ab07c3576cc7d8" id="r_a17d2aff69d10d63ba5ab07c3576cc7d8">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a17d2aff69d10d63ba5ab07c3576cc7d8">FORCE\_REPLICATED</a> = "force\_replicated"</td>
      </tr>

      <tr className="memdesc:a17d2aff69d10d63ba5ab07c3576cc7d8">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a> will be replicated even if the source tables are not. <br /></td>
      </tr>

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

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

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

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

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

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

      <tr className="memitem:a88c7e7391c3ede557a2ed9c688d6162e" id="r_a88c7e7391c3ede557a2ed9c688d6162e">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a88c7e7391c3ede557a2ed9c688d6162e">NO\_COUNT</a> = "no\_count"</td>
      </tr>

      <tr className="memdesc:a88c7e7391c3ede557a2ed9c688d6162e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Return a count of 0 for the union table response to avoid the cost of counting; optimization needed for many chunk virtual unions. <br /></td>
      </tr>

      <tr className="separator:a88c7e7391c3ede557a2ed9c688d6162e">
        <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_1CreateUnionRequest#a1b8d2a5ae23af9726252a8c42b65b646" title="Optional parameters.">CreateUnionRequest.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_2CreateUnion_8cs_source#l00036">36</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a7445bf25dee30a173fd72b572cc50cbb">◆ </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.CreateUnionRequest.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 output table. </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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aeb8e68c96aa461468686a465d3b772ba">◆ </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.CreateUnionRequest.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 output table. </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_2CreateUnion_8cs_source#l00187">187</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae31a249aa5423be1d06ca9f2a0726120">◆ </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.CreateUnionRequest.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 output table. </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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#acf4a9e79627a3b1717228efbc738ce22">◆ </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.CreateUnionRequest.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_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_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 the schema for the output table. </p>
        <p>If the schema provided 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_2CreateUnion_8cs_source#l00081">81</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a05fbd746d5bc90a8b85bfc0d7f11927e">◆ </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.CreateUnionRequest.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 this 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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ab4b2ea15b438a45f7caecabbffb157ee">◆ </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.CreateUnionRequest.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 output table. </p>
        <p>The columns specified must be present in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#ac600d84779ba65521380177b15de2333" title="The list of names of the columns to be stored in the output table.">CreateUnionRequest.output\_column\_names</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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a193b9821cfaadc86dee6cef2e79c663e">◆ </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.CreateUnionRequest.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="#a7ff13d328205c2ec4653cad8c7285eae">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_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a>. </p>
        <p>If <a className="el" href="#a8af5c6ff03dd7b96780db720ca2b5ead">PERSIST</a> is <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">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_1CreateUnionResponse_1_1Info#ac5fae771f679cbf7ed96f332e5090f99">QUALIFIED\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a> </li>
          <li> <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">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_2CreateUnion_8cs_source#l00063">63</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ae2cbe1811cbe4956c82d55a90a43fa78">◆ </a></span>EXCEPT</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.CreateUnionRequest.Options.EXCEPT = "except"</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>Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables). </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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3d1df32abeb6a97f5df98536cb92bbc3">◆ </a></span>EXCEPT\_ALL</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.CreateUnionRequest.Options.EXCEPT\_ALL = "except\_all"</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>Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables). </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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aedaa337e1e18ae69dd20b529eb210897">◆ </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.CreateUnionRequest.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_1CreateUnionRequest_1_1Options" title="A set of string constants for the parameter CreateUnionRequest.options.">CreateUnionRequest.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_2CreateUnion_8cs_source#l00071">71</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a17d2aff69d10d63ba5ab07c3576cc7d8">◆ </a></span>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.CreateUnionRequest.Options.FORCE\_REPLICATED = "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>If <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a> will be replicated even if the source tables are not. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a> </li>
          <li> <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">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_2CreateUnion_8cs_source#l00367">367</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ab959bd7ef495f5d05f9c5efdd9cc8dee">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00258">258</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3486ebd5b5b2ec8bdcb3d693803139c6">◆ </a></span>INTERSECT</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.CreateUnionRequest.Options.INTERSECT = "intersect"</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>Retains all unique rows that appear in both of the specified tables (only works on 2 tables). </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_2CreateUnion_8cs_source#l00171">171</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a2b1f40ecf7218561cfb059fb4feaca05">◆ </a></span>INTERSECT\_ALL</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.CreateUnionRequest.Options.INTERSECT\_ALL = "intersect\_all"</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>Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables). </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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ad26142c52d2649ea090047ec16d87309">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00248">248</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa1d9d10b908a775e0108d3f90b0d80da">◆ </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.CreateUnionRequest.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="#a7ff13d328205c2ec4653cad8c7285eae">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="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a> </li>
          <li> <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">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_2CreateUnion_8cs_source#l00310">310</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a74b0b9f1db5bee284bb8110e28679ffd">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00253">253</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af8600d62b19f69d419b35a6a95333405">◆ </a></span>MODE</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.CreateUnionRequest.Options.MODE = "mode"</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 mode describes what rows of the tables being unioned will be retained. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#af18332ed052a4d1c46ed8fe092bc4346">UNION\_ALL</a>: Retains all rows from the specified tables. </li>
          <li> <a className="el" href="#a5232e7e0ced4d7056caf994d554b1297">UNION</a>: Retains all unique rows from the specified tables (synonym for <a className="el" href="#a311485fbbaa8581bd72da27571164633">UNION\_DISTINCT</a>). </li>
          <li> <a className="el" href="#a311485fbbaa8581bd72da27571164633">UNION\_DISTINCT</a>: Retains all unique rows from the specified tables. </li>
          <li> <a className="el" href="#ae2cbe1811cbe4956c82d55a90a43fa78">EXCEPT</a>: Retains all unique rows from the first table that do not appear in the second table (only works on 2 tables). </li>
          <li> <a className="el" href="#a3d1df32abeb6a97f5df98536cb92bbc3">EXCEPT\_ALL</a>: Retains all rows(including duplicates) from the first table that do not appear in the second table (only works on 2 tables). </li>
          <li> <a className="el" href="#a3486ebd5b5b2ec8bdcb3d693803139c6">INTERSECT</a>: Retains all unique rows that appear in both of the specified tables (only works on 2 tables). </li>
          <li> <a className="el" href="#a2b1f40ecf7218561cfb059fb4feaca05">INTERSECT\_ALL</a>: Retains all rows(including duplicates) that appear in both of the specified tables (only works on 2 tables). </li>
        </ul>

        <p>The default value is <a className="el" href="#af18332ed052a4d1c46ed8fe092bc4346">UNION\_ALL</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_2CreateUnion_8cs_source#l00145">145</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a88c7e7391c3ede557a2ed9c688d6162e">◆ </a></span>NO\_COUNT</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.CreateUnionRequest.Options.NO\_COUNT = "no\_count"</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>Return a count of 0 for the union table response to avoid the cost of counting; optimization needed for many chunk virtual unions. </p>
        <p>The default value is 'false'.</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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a9afd7d7ad77f093c69567d1401fe16d6">◆ </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.CreateUnionRequest.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="#a66e7265fbfe78f8bb91d65817fe48e8e">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_2CreateUnion_8cs_source#l00288">288</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a623981f3b0f8879a4778a087f8c3159c">◆ </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.CreateUnionRequest.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="#a9afd7d7ad77f093c69567d1401fe16d6">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_2CreateUnion_8cs_source#l00270">270</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a66e7265fbfe78f8bb91d65817fe48e8e">◆ </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.CreateUnionRequest.Options.PARTITION\_TYPE = "partition\_type"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p><a href="/content/concepts/tables/#partitioning" target="_top">Partitioning</a> scheme to use for the output table. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a26480b770c6121f5384de46bc36c536f">RANGE</a>: Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </li>
          <li> <a className="el" href="#ad26142c52d2649ea090047ec16d87309">INTERVAL</a>: Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </li>
          <li> <a className="el" href="#a74b0b9f1db5bee284bb8110e28679ffd">LIST</a>: Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </li>
          <li> <a className="el" href="#ab959bd7ef495f5d05f9c5efdd9cc8dee">HASH</a>: Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </li>
          <li> <a className="el" href="#a98c7652f150548bfa39031fcbf9cca43">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_2CreateUnion_8cs_source#l00238">238</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8af5c6ff03dd7b96780db720ca2b5ead">◆ </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.CreateUnionRequest.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="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a> will be persisted and will not expire unless a <a className="el" href="#a3fc680fdd604c0c17a32469d0e2f6d55">TTL</a> is specified. </p>
        <p>If <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">FALSE</a>, then the output table will be an in-memory table and will expire unless a <a className="el" href="#a3fc680fdd604c0c17a32469d0e2f6d55">TTL</a> is specified otherwise. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a7ff13d328205c2ec4653cad8c7285eae">TRUE</a> </li>
          <li> <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#aedaa337e1e18ae69dd20b529eb210897">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_2CreateUnion_8cs_source#l00342">342</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a26480b770c6121f5384de46bc36c536f">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00243">243</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a98c7652f150548bfa39031fcbf9cca43">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00263">263</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a4979443060c1a2d908d277d0e7cd9791">◆ </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.CreateUnionRequest.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_2CreateUnion_8cs_source#l00372">372</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a7ff13d328205c2ec4653cad8c7285eae">◆ </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.CreateUnionRequest.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_1CreateUnionRequest_1_1Options" title="A set of string constants for the parameter CreateUnionRequest.options.">CreateUnionRequest.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_2CreateUnion_8cs_source#l00067">67</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3fc680fdd604c0c17a32469d0e2f6d55">◆ </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.CreateUnionRequest.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 output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#aa798575639c3d83216b26cd5e87b8245" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_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_2CreateUnion_8cs_source#l00315">315</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5232e7e0ced4d7056caf994d554b1297">◆ </a></span>UNION</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.CreateUnionRequest.Options.UNION = "union"</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>Retains all unique rows from the specified tables (synonym for <a className="el" href="#a311485fbbaa8581bd72da27571164633">UNION\_DISTINCT</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_2CreateUnion_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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af18332ed052a4d1c46ed8fe092bc4346">◆ </a></span>UNION\_ALL</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.CreateUnionRequest.Options.UNION\_ALL = "union\_all"</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>Retains all rows from the specified tables. </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_2CreateUnion_8cs_source#l00148">148</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a311485fbbaa8581bd72da27571164633">◆ </a></span>UNION\_DISTINCT</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.CreateUnionRequest.Options.UNION\_DISTINCT = "union\_distinct"</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>Retains all unique rows from the specified tables. </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_2CreateUnion_8cs_source#l00158">158</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_2CreateUnion_8cs_source">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa44d7915fbf64ddf7328aef86452aa33">◆ </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.CreateUnionRequest.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 output table 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_2CreateUnion_8cs_source#l00347">347</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_2CreateUnion_8cs_source">CreateUnion.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_2CreateUnion_8cs_source">CreateUnion.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2CreateUnion_8cs_source">CreateUnion.cs</a></li>
    </ul>
  </div>
</div>