> ## 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#a26799ca8dd5805c66741191c22f3f332" title="Optional parameters.">CreateUnionRequest.options</a>. <a href="#details">More...</a></p>

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:af26584a2dfd8b1e84451e05d66871704">
        <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#a2daf55df32ea375f1effb81fec622428" 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/createschema#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:af26584a2dfd8b1e84451e05d66871704">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:ae76e338d78c3a364a7070d45c7bf3d53">
        <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#a2daf55df32ea375f1effb81fec622428" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a>. <br /></td>
      </tr>

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

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

      <tr className="memdesc:a99297fe0676ca3868f1a3e1b182c5864">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#a2daf55df32ea375f1effb81fec622428" 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="#ae76e338d78c3a364a7070d45c7bf3d53">TTL</a> is specified. <br /></td>
      </tr>

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

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

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

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

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

      <tr className="memdesc:a9745b8f137358623b015bbc4ad325172">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If <a className="el" href="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#a2daf55df32ea375f1effb81fec622428" 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:a9745b8f137358623b015bbc4ad325172">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

    <div id="details" />

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

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#a26799ca8dd5805c66741191c22f3f332" title="Optional parameters.">CreateUnionRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L36">36</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
    </div>

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

    <div id="aebf0b66f20901e28498fd169a8fc6321" />

    <h2 className="memtitle"><span className="permalink"><a href="#aebf0b66f20901e28498fd169a8fc6321">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L183">183</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a65d61f07104688c8cb3936aadab35e27" />

    <h2 className="memtitle"><span className="permalink"><a href="#a65d61f07104688c8cb3936aadab35e27">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L187">187</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a346909c522f11c59eacad361ea355b4b" />

    <h2 className="memtitle"><span className="permalink"><a href="#a346909c522f11c59eacad361ea355b4b">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L179">179</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="af26584a2dfd8b1e84451e05d66871704" />

    <h2 className="memtitle"><span className="permalink"><a href="#af26584a2dfd8b1e84451e05d66871704">◆ </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#a2daf55df32ea375f1effb81fec622428" 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/createschema#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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L81">81</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="aeda99527985b37bf49d7b0eaca745fee" />

    <h2 className="memtitle"><span className="permalink"><a href="#aeda99527985b37bf49d7b0eaca745fee">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L378">378</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a65460d2747ef226c5d5010f53297254b" />

    <h2 className="memtitle"><span className="permalink"><a href="#a65460d2747ef226c5d5010f53297254b">◆ </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#a1b84269ea1e9648a4e1388812f18b260" 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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L193">193</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="ac7d26b60a613cc89d4c9699fc396d0ba" />

    <h2 className="memtitle"><span className="permalink"><a href="#ac7d26b60a613cc89d4c9699fc396d0ba">◆ </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="#af4b60287222b752c8dc75ece2d1bc32e">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#a2daf55df32ea375f1effb81fec622428" title="Name of the table to be created, in [schema_name.">CreateUnionRequest.table\_name</a>. </p>
        <p>If <a className="el" href="#a99297fe0676ca3868f1a3e1b182c5864">PERSIST</a> is <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">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#a68413faf61e48937c3c125c8845cf96e">QUALIFIED\_TABLE\_NAME</a>. Supported values:</p>

        <ul>
          <li> <a className="el" href="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a> </li>
          <li> <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">FALSE</a> </li>
        </ul>

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

    <div id="a870cf09709741292e860e85f9421cf65" />

    <h2 className="memtitle"><span className="permalink"><a href="#a870cf09709741292e860e85f9421cf65">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L162">162</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a8ae5fba81d6db32a4c3b17b16d9c34a0" />

    <h2 className="memtitle"><span className="permalink"><a href="#a8ae5fba81d6db32a4c3b17b16d9c34a0">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L167">167</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a48c1aa0bb4f1fdf2acb8b414c0980e95" />

    <h2 className="memtitle"><span className="permalink"><a href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L71">71</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a9745b8f137358623b015bbc4ad325172" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9745b8f137358623b015bbc4ad325172">◆ </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="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#a2daf55df32ea375f1effb81fec622428" 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="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a> </li>
          <li> <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">FALSE</a> </li>
        </ul>

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

    <div id="a7d4a4c668c462b71e91c83747d2c20bd" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7d4a4c668c462b71e91c83747d2c20bd">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L258">258</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a6ee32394bf2fbb1f234dac3605084c58" />

    <h2 className="memtitle"><span className="permalink"><a href="#a6ee32394bf2fbb1f234dac3605084c58">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L171">171</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="af5f6f7125a0692297c6da712d79105e7" />

    <h2 className="memtitle"><span className="permalink"><a href="#af5f6f7125a0692297c6da712d79105e7">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L175">175</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a73ad91096cc4af02d162eff42cb4ec7d" />

    <h2 className="memtitle"><span className="permalink"><a href="#a73ad91096cc4af02d162eff42cb4ec7d">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L248">248</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="ae2a4e2a45fa2582be44e265c650c0eef" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae2a4e2a45fa2582be44e265c650c0eef">◆ </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="#af4b60287222b752c8dc75ece2d1bc32e">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="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a> </li>
          <li> <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">FALSE</a> </li>
        </ul>

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

    <div id="ae37aee06c2f7b010d950387b6f3a924d" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae37aee06c2f7b010d950387b6f3a924d">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L253">253</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="ac57534911e5b7dcc7e79e15009729692" />

    <h2 className="memtitle"><span className="permalink"><a href="#ac57534911e5b7dcc7e79e15009729692">◆ </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="#a9154d77feed9c801abfce0a215bb6888">UNION\_ALL</a>: Retains all rows from the specified tables. </li>
          <li> <a className="el" href="#a5cb2860f137db6555a5ccea4d6578c6b">UNION</a>: Retains all unique rows from the specified tables (synonym for <a className="el" href="#a43f432d2053d6d413a3dddac8c68def6">UNION\_DISTINCT</a>). </li>
          <li> <a className="el" href="#a43f432d2053d6d413a3dddac8c68def6">UNION\_DISTINCT</a>: Retains all unique rows from the specified tables. </li>
          <li> <a className="el" href="#a870cf09709741292e860e85f9421cf65">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="#a8ae5fba81d6db32a4c3b17b16d9c34a0">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="#a6ee32394bf2fbb1f234dac3605084c58">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="#af5f6f7125a0692297c6da712d79105e7">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="#a9154d77feed9c801abfce0a215bb6888">UNION\_ALL</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L145">145</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="aed547787e140054378501f91d6e9a535" />

    <h2 className="memtitle"><span className="permalink"><a href="#aed547787e140054378501f91d6e9a535">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L384">384</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a0be150e9cbb1038358762bd63e340dea" />

    <h2 className="memtitle"><span className="permalink"><a href="#a0be150e9cbb1038358762bd63e340dea">◆ </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="#ad69b346fb1af898d73324a9485c3fb54">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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L288">288</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a354c30ff1d31c64c8cb38c712bde6378" />

    <h2 className="memtitle"><span className="permalink"><a href="#a354c30ff1d31c64c8cb38c712bde6378">◆ </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="#a0be150e9cbb1038358762bd63e340dea">PARTITION\_DEFINITIONS</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L270">270</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="ad69b346fb1af898d73324a9485c3fb54" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad69b346fb1af898d73324a9485c3fb54">◆ </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="#a2785f8c48e915690c8c97b4d22edd9d8">RANGE</a>: Use <a href="/content/concepts/tables/#partitioning-by-range" target="_top">range partitioning</a>. </li>
          <li> <a className="el" href="#a73ad91096cc4af02d162eff42cb4ec7d">INTERVAL</a>: Use <a href="/content/concepts/tables/#partitioning-by-interval" target="_top">interval partitioning</a>. </li>
          <li> <a className="el" href="#ae37aee06c2f7b010d950387b6f3a924d">LIST</a>: Use <a href="/content/concepts/tables/#partitioning-by-list" target="_top">list partitioning</a>. </li>
          <li> <a className="el" href="#a7d4a4c668c462b71e91c83747d2c20bd">HASH</a>: Use <a href="/content/concepts/tables/#partitioning-by-hash" target="_top">hash partitioning</a>. </li>
          <li> <a className="el" href="#a650ba296013d1dd1b69bab8da4c49e71">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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L238">238</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a99297fe0676ca3868f1a3e1b182c5864" />

    <h2 className="memtitle"><span className="permalink"><a href="#a99297fe0676ca3868f1a3e1b182c5864">◆ </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="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a>, then the output table specified in <a className="el" href="/content/api/cs/classkinetica_1_1CreateUnionRequest#a2daf55df32ea375f1effb81fec622428" 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="#ae76e338d78c3a364a7070d45c7bf3d53">TTL</a> is specified. </p>
        <p>If <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">FALSE</a>, then the output table will be an in-memory table and will expire unless a <a className="el" href="#ae76e338d78c3a364a7070d45c7bf3d53">TTL</a> is specified otherwise. Supported values:</p>

        <ul>
          <li> <a className="el" href="#af4b60287222b752c8dc75ece2d1bc32e">TRUE</a> </li>
          <li> <a className="el" href="#a48c1aa0bb4f1fdf2acb8b414c0980e95">FALSE</a> </li>
        </ul>

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

    <div id="a2785f8c48e915690c8c97b4d22edd9d8" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2785f8c48e915690c8c97b4d22edd9d8">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L243">243</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a650ba296013d1dd1b69bab8da4c49e71" />

    <h2 className="memtitle"><span className="permalink"><a href="#a650ba296013d1dd1b69bab8da4c49e71">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L263">263</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a3ef16904f9aa2a862885ce4f19da3a74" />

    <h2 className="memtitle"><span className="permalink"><a href="#a3ef16904f9aa2a862885ce4f19da3a74">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L372">372</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="af4b60287222b752c8dc75ece2d1bc32e" />

    <h2 className="memtitle"><span className="permalink"><a href="#af4b60287222b752c8dc75ece2d1bc32e">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L67">67</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="ae76e338d78c3a364a7070d45c7bf3d53" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae76e338d78c3a364a7070d45c7bf3d53">◆ </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#a2daf55df32ea375f1effb81fec622428" 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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L315">315</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a5cb2860f137db6555a5ccea4d6578c6b" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5cb2860f137db6555a5ccea4d6578c6b">◆ </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="#a43f432d2053d6d413a3dddac8c68def6">UNION\_DISTINCT</a>). </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L154">154</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a9154d77feed9c801abfce0a215bb6888" />

    <h2 className="memtitle"><span className="permalink"><a href="#a9154d77feed9c801abfce0a215bb6888">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L148">148</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a43f432d2053d6d413a3dddac8c68def6" />

    <h2 className="memtitle"><span className="permalink"><a href="#a43f432d2053d6d413a3dddac8c68def6">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L158">158</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <div id="a84d9b622ed6d6033e6e1818dfe00ce7d" />

    <h2 className="memtitle"><span className="permalink"><a href="#a84d9b622ed6d6033e6e1818dfe00ce7d">◆ </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="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs#L347">347</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/CreateUnion.cs">CreateUnion.cs</a>.</p>
      </div>
    </div>

    <hr />

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

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


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