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

> kinetica.InsertRecordsFromQueryRequest.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_1InsertRecordsFromQueryRequest#a127ab9e379588542a109678e0bc8909a" title="Optional parameters.">InsertRecordsFromQueryRequest.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:a5287da5aff3874e3425e97d50566e6bf" id="r_a5287da5aff3874e3425e97d50566e6bf">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a5287da5aff3874e3425e97d50566e6bf">BAD\_RECORD\_TABLE\_NAME</a> = "bad\_record\_table\_name"</td>
      </tr>

      <tr className="memdesc:a5287da5aff3874e3425e97d50566e6bf">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of a table to which records that were rejected are written. <br /></td>
      </tr>

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

      <tr className="memitem:ae3e531faf3b04b4ebf44a2db1885cb6d" id="r_ae3e531faf3b04b4ebf44a2db1885cb6d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae3e531faf3b04b4ebf44a2db1885cb6d">BAD\_RECORD\_TABLE\_LIMIT</a> = "bad\_record\_table\_limit"</td>
      </tr>

      <tr className="memdesc:ae3e531faf3b04b4ebf44a2db1885cb6d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">A positive integer indicating the maximum number of records that can be written to the bad-record-table. <br /></td>
      </tr>

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

      <tr className="memitem:a979cda60f908704cb0de3f7be27012b0" id="r_a979cda60f908704cb0de3f7be27012b0">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a979cda60f908704cb0de3f7be27012b0">BATCH\_SIZE</a> = "batch\_size"</td>
      </tr>

      <tr className="memdesc:a979cda60f908704cb0de3f7be27012b0">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Number of records per batch when inserting data. <br /></td>
      </tr>

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

      <tr className="memitem:aa6347b51ec5a27d2a5b5dc11738847c2" id="r_aa6347b51ec5a27d2a5b5dc11738847c2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aa6347b51ec5a27d2a5b5dc11738847c2">DATASOURCE\_NAME</a> = "datasource\_name"</td>
      </tr>

      <tr className="memdesc:aa6347b51ec5a27d2a5b5dc11738847c2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of an existing external data source from which table will be loaded. <br /></td>
      </tr>

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

      <tr className="memitem:a4784c4515a9155178689abbcce8a8ab9" id="r_a4784c4515a9155178689abbcce8a8ab9">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a> = "error\_handling"</td>
      </tr>

      <tr className="memdesc:a4784c4515a9155178689abbcce8a8ab9">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Specifies how errors should be handled upon insertion. <br /></td>
      </tr>

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

      <tr className="memitem:a1c952fad1306368be55f2ac99d23437a" id="r_a1c952fad1306368be55f2ac99d23437a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a1c952fad1306368be55f2ac99d23437a">PERMISSIVE</a> = "permissive"</td>
      </tr>

      <tr className="memdesc:a1c952fad1306368be55f2ac99d23437a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight"><a className="el" href="/content/api/cs/namespacekinetica_1_1Records">Records</a> with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped. <br /></td>
      </tr>

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

      <tr className="memitem:a0d62ad2e864d1e3ccb445b40b78d0e56" id="r_a0d62ad2e864d1e3ccb445b40b78d0e56">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a0d62ad2e864d1e3ccb445b40b78d0e56">SKIP</a> = "skip"</td>
      </tr>

      <tr className="memdesc:a0d62ad2e864d1e3ccb445b40b78d0e56">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Malformed records are skipped. <br /></td>
      </tr>

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

      <tr className="memitem:aef95531fb624a759ba49bfa45bb61321" id="r_aef95531fb624a759ba49bfa45bb61321">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aef95531fb624a759ba49bfa45bb61321">IGNORE\_BAD\_RECORDS</a> = "ignore\_bad\_records"</td>
      </tr>

      <tr className="memdesc:aef95531fb624a759ba49bfa45bb61321">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Deprecated. <br /></td>
      </tr>

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

      <tr className="memitem:a458d3f6bfb9eb1bc97db4be57900aff5" id="r_a458d3f6bfb9eb1bc97db4be57900aff5">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a458d3f6bfb9eb1bc97db4be57900aff5">ABORT</a> = "abort"</td>
      </tr>

      <tr className="memdesc:a458d3f6bfb9eb1bc97db4be57900aff5">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Stops current insertion and aborts entire operation when an error is encountered. <br /></td>
      </tr>

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

      <tr className="memitem:acb2a8b5df8577f6001d7d7110759ba0d" id="r_acb2a8b5df8577f6001d7d7110759ba0d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acb2a8b5df8577f6001d7d7110759ba0d">PK\_CONFLICT\_PREDICATE\_HIGHER</a> = "pk\_conflict\_predicate\_higher"</td>
      </tr>

      <tr className="memdesc:acb2a8b5df8577f6001d7d7110759ba0d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The record with higher value for the column resolves the primary-key insert conflict. <br /></td>
      </tr>

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

      <tr className="memitem:ae853c0ed8d6a2504e83e5b06b47e575d" id="r_ae853c0ed8d6a2504e83e5b06b47e575d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ae853c0ed8d6a2504e83e5b06b47e575d">PK\_CONFLICT\_PREDICATE\_LOWER</a> = "pk\_conflict\_predicate\_lower"</td>
      </tr>

      <tr className="memdesc:ae853c0ed8d6a2504e83e5b06b47e575d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The record with lower value for the column resolves the primary-key insert conflict. <br /></td>
      </tr>

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

      <tr className="memitem:a69f08bf21f5358b6e8fc982916ad32b2" id="r_a69f08bf21f5358b6e8fc982916ad32b2">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a69f08bf21f5358b6e8fc982916ad32b2">IGNORE\_EXISTING\_PK</a> = "ignore\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:a69f08bf21f5358b6e8fc982916ad32b2">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Specifies the record collision error-suppression policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when not in upsert mode (upsert mode is disabled when <a className="el" href="#abb7d143f7e000a0cf0015dd482d94b2a">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>). <br /></td>
      </tr>

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

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

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

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

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

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

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

      <tr className="memitem:aaeffe34535378efd8e5fba1fdbd2f2eb" id="r_aaeffe34535378efd8e5fba1fdbd2f2eb">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#aaeffe34535378efd8e5fba1fdbd2f2eb">INGESTION\_MODE</a> = "ingestion\_mode"</td>
      </tr>

      <tr className="memdesc:aaeffe34535378efd8e5fba1fdbd2f2eb">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Whether to do a full load, dry run, or perform a type inference on the source data. <br /></td>
      </tr>

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

      <tr className="memitem:a63201a457115794fd7112acb171aa08d" id="r_a63201a457115794fd7112acb171aa08d">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a63201a457115794fd7112acb171aa08d">FULL</a> = "full"</td>
      </tr>

      <tr className="memdesc:a63201a457115794fd7112acb171aa08d">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Run a type inference on the source data (if needed) and ingest. <br /></td>
      </tr>

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

      <tr className="memitem:a717d039c86ac48e054223ae5aef5c78c" id="r_a717d039c86ac48e054223ae5aef5c78c">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a717d039c86ac48e054223ae5aef5c78c">DRY\_RUN</a> = "dry\_run"</td>
      </tr>

      <tr className="memdesc:a717d039c86ac48e054223ae5aef5c78c">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Does not load data, but walks through the source data and determines the number of valid records, taking into account the current mode of <a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a>. <br /></td>
      </tr>

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

      <tr className="memitem:a900558d5be050aee8e4f95aaf65cd971" id="r_a900558d5be050aee8e4f95aaf65cd971">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a900558d5be050aee8e4f95aaf65cd971">TYPE\_INFERENCE\_ONLY</a> = "type\_inference\_only"</td>
      </tr>

      <tr className="memdesc:a900558d5be050aee8e4f95aaf65cd971">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Infer the type of the source data and return, without ingesting any data. <br /></td>
      </tr>

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

      <tr className="memitem:a6cd10130202ab023b5ba4ae8f04ff886" id="r_a6cd10130202ab023b5ba4ae8f04ff886">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6cd10130202ab023b5ba4ae8f04ff886">JDBC\_FETCH\_SIZE</a> = "jdbc\_fetch\_size"</td>
      </tr>

      <tr className="memdesc:a6cd10130202ab023b5ba4ae8f04ff886">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">The JDBC fetch size, which determines how many rows to fetch per round trip. <br /></td>
      </tr>

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

      <tr className="memitem:a3232ba8dc1f0c6a58d318023e693001c" id="r_a3232ba8dc1f0c6a58d318023e693001c">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3232ba8dc1f0c6a58d318023e693001c">JDBC\_SESSION\_INIT\_STATEMENT</a> = "jdbc\_session\_init\_statement"</td>
      </tr>

      <tr className="memdesc:a3232ba8dc1f0c6a58d318023e693001c">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Executes the statement per each JDBC session before doing actual load. <br /></td>
      </tr>

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

      <tr className="memitem:a2d3a5914e4fe71da6c8057fa49ff8ce1" id="r_a2d3a5914e4fe71da6c8057fa49ff8ce1">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a2d3a5914e4fe71da6c8057fa49ff8ce1">NUM\_SPLITS\_PER\_RANK</a> = "num\_splits\_per\_rank"</td>
      </tr>

      <tr className="memdesc:a2d3a5914e4fe71da6c8057fa49ff8ce1">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Number of splits for reading data per rank. <br /></td>
      </tr>

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

      <tr className="memitem:a6c0ac239dd4cd49cc587db4e8f203036" id="r_a6c0ac239dd4cd49cc587db4e8f203036">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a6c0ac239dd4cd49cc587db4e8f203036">NUM\_TASKS\_PER\_RANK</a> = "num\_tasks\_per\_rank"</td>
      </tr>

      <tr className="memdesc:a6c0ac239dd4cd49cc587db4e8f203036">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Number of tasks for reading data per rank. <br /></td>
      </tr>

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

      <tr className="memitem:a92faabb3bfe6f359b4132e7f08883345" id="r_a92faabb3bfe6f359b4132e7f08883345">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a92faabb3bfe6f359b4132e7f08883345">PRIMARY\_KEYS</a> = "primary\_keys"</td>
      </tr>

      <tr className="memdesc:a92faabb3bfe6f359b4132e7f08883345">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma separated list of column names, to set as primary keys, when not specified in the type. <br /></td>
      </tr>

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

      <tr className="memitem:acc85662cf45a26191a2d3aea4e6e59e4" id="r_acc85662cf45a26191a2d3aea4e6e59e4">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acc85662cf45a26191a2d3aea4e6e59e4">SHARD\_KEYS</a> = "shard\_keys"</td>
      </tr>

      <tr className="memdesc:acc85662cf45a26191a2d3aea4e6e59e4">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Comma separated list of column names, to set as shard keys, when not specified in the type. <br /></td>
      </tr>

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

      <tr className="memitem:a805312b92233e873b220ad5cca2174be" id="r_a805312b92233e873b220ad5cca2174be">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a805312b92233e873b220ad5cca2174be">SUBSCRIBE</a> = "subscribe"</td>
      </tr>

      <tr className="memdesc:a805312b92233e873b220ad5cca2174be">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Continuously poll the data source to check for new data and load it into the table. <br /></td>
      </tr>

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

      <tr className="memitem:a7225831df16a6021bf9d93fd82334ed7" id="r_a7225831df16a6021bf9d93fd82334ed7">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a7225831df16a6021bf9d93fd82334ed7">TRUNCATE\_TABLE</a> = "truncate\_table"</td>
      </tr>

      <tr className="memdesc:a7225831df16a6021bf9d93fd82334ed7">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, truncates the table specified by <a className="el" href="/content/api/cs/classkinetica_1_1InsertRecordsFromQueryRequest#a40d8410e3a973a396dbede4afb352bb8" title="Name of the table into which the data will be inserted, in [schema_name.">InsertRecordsFromQueryRequest.table\_name</a> prior to loading the data. <br /></td>
      </tr>

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

      <tr className="memitem:a4c98e971fe4a6d5100397e24c3aace9a" id="r_a4c98e971fe4a6d5100397e24c3aace9a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4c98e971fe4a6d5100397e24c3aace9a">REMOTE\_QUERY</a> = "remote\_query"</td>
      </tr>

      <tr className="memdesc:a4c98e971fe4a6d5100397e24c3aace9a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Remote SQL query from which data will be sourced. <br /></td>
      </tr>

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

      <tr className="memitem:acf2143bb3d32a775b20cd642f89378d3" id="r_acf2143bb3d32a775b20cd642f89378d3">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acf2143bb3d32a775b20cd642f89378d3">REMOTE\_QUERY\_ORDER\_BY</a> = "remote\_query\_order\_by"</td>
      </tr>

      <tr className="memdesc:acf2143bb3d32a775b20cd642f89378d3">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of column to be used for splitting the query into multiple sub-queries using ordering of given column. <br /></td>
      </tr>

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

      <tr className="memitem:a8ab591279ab55420bf921efa4ad8e548" id="r_a8ab591279ab55420bf921efa4ad8e548">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a8ab591279ab55420bf921efa4ad8e548">REMOTE\_QUERY\_FILTER\_COLUMN</a> = "remote\_query\_filter\_column"</td>
      </tr>

      <tr className="memdesc:a8ab591279ab55420bf921efa4ad8e548">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Name of column to be used for splitting the query into multiple sub-queries using the data distribution of given column. <br /></td>
      </tr>

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

      <tr className="memitem:a610130dfea115551787f8482d9f826e4" id="r_a610130dfea115551787f8482d9f826e4">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a610130dfea115551787f8482d9f826e4">REMOTE\_QUERY\_INCREASING\_COLUMN</a> = "remote\_query\_increasing\_column"</td>
      </tr>

      <tr className="memdesc:a610130dfea115551787f8482d9f826e4">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Column on subscribed remote query result that will increase for new records (e.g., TIMESTAMP). <br /></td>
      </tr>

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

      <tr className="memitem:ad9aea6f798a43387e1af3aae7453e7cf" id="r_ad9aea6f798a43387e1af3aae7453e7cf">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ad9aea6f798a43387e1af3aae7453e7cf">REMOTE\_QUERY\_PARTITION\_COLUMN</a> = "remote\_query\_partition\_column"</td>
      </tr>

      <tr className="memdesc:ad9aea6f798a43387e1af3aae7453e7cf">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Alias name for <a className="el" href="#a8ab591279ab55420bf921efa4ad8e548">REMOTE\_QUERY\_FILTER\_COLUMN</a>. <br /></td>
      </tr>

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

      <tr className="memitem:a77356602cd8a854b38ccadf30eda5a4f" id="r_a77356602cd8a854b38ccadf30eda5a4f">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a77356602cd8a854b38ccadf30eda5a4f">TRUNCATE\_STRINGS</a> = "truncate\_strings"</td>
      </tr>

      <tr className="memdesc:a77356602cd8a854b38ccadf30eda5a4f">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, truncate string values that are longer than the column's type size. <br /></td>
      </tr>

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

      <tr className="memitem:a4bce2f23494f786730cb2583da8da21a" id="r_a4bce2f23494f786730cb2583da8da21a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4bce2f23494f786730cb2583da8da21a">ENABLE\_INPLACE\_UPDATES</a> = "enable\_inplace\_updates"</td>
      </tr>

      <tr className="memdesc:a4bce2f23494f786730cb2583da8da21a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Applies only when upserting (when update\_on\_existing\_pk is true). <br /></td>
      </tr>

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

      <tr className="memitem:abb7d143f7e000a0cf0015dd482d94b2a" id="r_abb7d143f7e000a0cf0015dd482d94b2a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#abb7d143f7e000a0cf0015dd482d94b2a">UPDATE\_ON\_EXISTING\_PK</a> = "update\_on\_existing\_pk"</td>
      </tr>

      <tr className="memdesc:abb7d143f7e000a0cf0015dd482d94b2a">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. <br /></td>
      </tr>

      <tr className="separator:abb7d143f7e000a0cf0015dd482d94b2a">
        <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_1InsertRecordsFromQueryRequest#a127ab9e379588542a109678e0bc8909a" title="Optional parameters.">InsertRecordsFromQueryRequest.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/InsertRecordsFromQuery.cs#L283">283</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
    </div>

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

    <div id="a458d3f6bfb9eb1bc97db4be57900aff5" />

    <h2 className="memtitle"><span className="permalink"><a href="#a458d3f6bfb9eb1bc97db4be57900aff5">◆ </a></span>ABORT</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.InsertRecordsFromQueryRequest.Options.ABORT = "abort"</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>Stops current insertion and aborts entire operation when an error is encountered. </p>
        <p>Primary key collisions are considered abortable errors in this mode.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L363">363</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="ae3e531faf3b04b4ebf44a2db1885cb6d" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae3e531faf3b04b4ebf44a2db1885cb6d">◆ </a></span>BAD\_RECORD\_TABLE\_LIMIT</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.InsertRecordsFromQueryRequest.Options.BAD\_RECORD\_TABLE\_LIMIT = "bad\_record\_table\_limit"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>A positive integer indicating the maximum number of records that can be written to the bad-record-table. </p>
        <p>Default value is 10000.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L296">296</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a5287da5aff3874e3425e97d50566e6bf" />

    <h2 className="memtitle"><span className="permalink"><a href="#a5287da5aff3874e3425e97d50566e6bf">◆ </a></span>BAD\_RECORD\_TABLE\_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.InsertRecordsFromQueryRequest.Options.BAD\_RECORD\_TABLE\_NAME = "bad\_record\_table\_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>Name of a table to which records that were rejected are written. </p>
        <p>The bad-record-table has the following columns: line\_number (long), line\_rejected (string), error\_message (string). When error handling is Abort, bad records table is not populated. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L291">291</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a979cda60f908704cb0de3f7be27012b0" />

    <h2 className="memtitle"><span className="permalink"><a href="#a979cda60f908704cb0de3f7be27012b0">◆ </a></span>BATCH\_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.InsertRecordsFromQueryRequest.Options.BATCH\_SIZE = "batch\_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>Number of records per batch when inserting data. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L299">299</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="aa6347b51ec5a27d2a5b5dc11738847c2" />

    <h2 className="memtitle"><span className="permalink"><a href="#aa6347b51ec5a27d2a5b5dc11738847c2">◆ </a></span>DATASOURCE\_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.InsertRecordsFromQueryRequest.Options.DATASOURCE\_NAME = "datasource\_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>Name of an existing external data source from which table will be loaded. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L303">303</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a717d039c86ac48e054223ae5aef5c78c" />

    <h2 className="memtitle"><span className="permalink"><a href="#a717d039c86ac48e054223ae5aef5c78c">◆ </a></span>DRY\_RUN</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.InsertRecordsFromQueryRequest.Options.DRY\_RUN = "dry\_run"</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>Does not load data, but walks through the source data and determines the number of valid records, taking into account the current mode of <a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L475">475</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a4bce2f23494f786730cb2583da8da21a" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4bce2f23494f786730cb2583da8da21a">◆ </a></span>ENABLE\_INPLACE\_UPDATES</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.InsertRecordsFromQueryRequest.Options.ENABLE\_INPLACE\_UPDATES = "enable\_inplace\_updates"</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>Applies only when upserting (when update\_on\_existing\_pk is true). </p>
        <p>If set to true (the default), an existing record matched by primary key is modified in place. If set to false, the matched record is updated by deleting it and inserting a replacement (delete and insert), which prevents the change from being reflected in dependent materialized views until they are refreshed. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a> </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L630">630</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a4784c4515a9155178689abbcce8a8ab9" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4784c4515a9155178689abbcce8a8ab9">◆ </a></span>ERROR\_HANDLING</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.InsertRecordsFromQueryRequest.Options.ERROR\_HANDLING = "error\_handling"</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>Specifies how errors should be handled upon insertion. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a1c952fad1306368be55f2ac99d23437a">PERMISSIVE</a>: <a className="el" href="/content/api/cs/namespacekinetica_1_1Records">Records</a> with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped. </li>
          <li> <a className="el" href="#a0d62ad2e864d1e3ccb445b40b78d0e56">SKIP</a>: Malformed records are skipped. </li>
          <li> <a className="el" href="#aef95531fb624a759ba49bfa45bb61321">IGNORE\_BAD\_RECORDS</a>: Deprecated. Alias for <a className="el" href="#a0d62ad2e864d1e3ccb445b40b78d0e56">SKIP</a>. </li>
          <li> <a className="el" href="#a458d3f6bfb9eb1bc97db4be57900aff5">ABORT</a>: Stops current insertion and aborts entire operation when an error is encountered. Primary key collisions are considered abortable errors in this mode. </li>
        </ul>

        <p>The default value is <a className="el" href="#a458d3f6bfb9eb1bc97db4be57900aff5">ABORT</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L344">344</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a93062a5a281ff65a5c03137bc3781fe7" />

    <h2 className="memtitle"><span className="permalink"><a href="#a93062a5a281ff65a5c03137bc3781fe7">◆ </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.InsertRecordsFromQueryRequest.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_1InsertRecordsFromQueryRequest_1_1Options" title="A set of string constants for the parameter InsertRecordsFromQueryRequest.options.">InsertRecordsFromQueryRequest.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/InsertRecordsFromQuery.cs#L429">429</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a63201a457115794fd7112acb171aa08d" />

    <h2 className="memtitle"><span className="permalink"><a href="#a63201a457115794fd7112acb171aa08d">◆ </a></span>FULL</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.InsertRecordsFromQueryRequest.Options.FULL = "full"</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>Run a type inference on the source data (if needed) and ingest. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L468">468</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="aef95531fb624a759ba49bfa45bb61321" />

    <h2 className="memtitle"><span className="permalink"><a href="#aef95531fb624a759ba49bfa45bb61321">◆ </a></span>IGNORE\_BAD\_RECORDS</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.InsertRecordsFromQueryRequest.Options.IGNORE\_BAD\_RECORDS = "ignore\_bad\_records"</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. </p>
        <p>Alias for <a className="el" href="#a0d62ad2e864d1e3ccb445b40b78d0e56">SKIP</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L357">357</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a69f08bf21f5358b6e8fc982916ad32b2" />

    <h2 className="memtitle"><span className="permalink"><a href="#a69f08bf21f5358b6e8fc982916ad32b2">◆ </a></span>IGNORE\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.InsertRecordsFromQueryRequest.Options.IGNORE\_EXISTING\_PK = "ignore\_existing\_pk"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Specifies the record collision error-suppression policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when not in upsert mode (upsert mode is disabled when <a className="el" href="#abb7d143f7e000a0cf0015dd482d94b2a">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>). </p>
        <p>If set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, any record being inserted that is rejected for having primary key values that match those of an existing table record will be ignored with no error generated. If <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>, the rejection of any record for having primary key values matching an existing record will result in an error being reported, as determined by <a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a>. If the specified table does not have a primary key or if upsert mode is in effect (<a className="el" href="#abb7d143f7e000a0cf0015dd482d94b2a">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>), then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>: Ignore new records whose primary key values collide with those of existing records. </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>: Treat as errors any new records whose primary key values collide with those of existing records. </li>
        </ul>

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

    <div id="aaeffe34535378efd8e5fba1fdbd2f2eb" />

    <h2 className="memtitle"><span className="permalink"><a href="#aaeffe34535378efd8e5fba1fdbd2f2eb">◆ </a></span>INGESTION\_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.InsertRecordsFromQueryRequest.Options.INGESTION\_MODE = "ingestion\_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>Whether to do a full load, dry run, or perform a type inference on the source data. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a63201a457115794fd7112acb171aa08d">FULL</a>: Run a type inference on the source data (if needed) and ingest. </li>
          <li> <a className="el" href="#a717d039c86ac48e054223ae5aef5c78c">DRY\_RUN</a>: Does not load data, but walks through the source data and determines the number of valid records, taking into account the current mode of <a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a>. </li>
          <li> <a className="el" href="#a900558d5be050aee8e4f95aaf65cd971">TYPE\_INFERENCE\_ONLY</a>: Infer the type of the source data and return, without ingesting any data. The inferred type is returned in the response. </li>
        </ul>

        <p>The default value is <a className="el" href="#a63201a457115794fd7112acb171aa08d">FULL</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L464">464</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a6cd10130202ab023b5ba4ae8f04ff886" />

    <h2 className="memtitle"><span className="permalink"><a href="#a6cd10130202ab023b5ba4ae8f04ff886">◆ </a></span>JDBC\_FETCH\_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.InsertRecordsFromQueryRequest.Options.JDBC\_FETCH\_SIZE = "jdbc\_fetch\_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>The JDBC fetch size, which determines how many rows to fetch per round trip. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L485">485</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a3232ba8dc1f0c6a58d318023e693001c" />

    <h2 className="memtitle"><span className="permalink"><a href="#a3232ba8dc1f0c6a58d318023e693001c">◆ </a></span>JDBC\_SESSION\_INIT\_STATEMENT</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.InsertRecordsFromQueryRequest.Options.JDBC\_SESSION\_INIT\_STATEMENT = "jdbc\_session\_init\_statement"</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>Executes the statement per each JDBC session before doing actual load. </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/InsertRecordsFromQuery.cs#L490">490</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a2d3a5914e4fe71da6c8057fa49ff8ce1" />

    <h2 className="memtitle"><span className="permalink"><a href="#a2d3a5914e4fe71da6c8057fa49ff8ce1">◆ </a></span>NUM\_SPLITS\_PER\_RANK</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.InsertRecordsFromQueryRequest.Options.NUM\_SPLITS\_PER\_RANK = "num\_splits\_per\_rank"</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>Number of splits for reading data per rank. </p>
        <p>Default will be <a href="/content/config/#config-main-external-files" target="_top">external\_file\_reader\_num\_tasks</a>. 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/InsertRecordsFromQuery.cs#L497">497</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a6c0ac239dd4cd49cc587db4e8f203036" />

    <h2 className="memtitle"><span className="permalink"><a href="#a6c0ac239dd4cd49cc587db4e8f203036">◆ </a></span>NUM\_TASKS\_PER\_RANK</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.InsertRecordsFromQueryRequest.Options.NUM\_TASKS\_PER\_RANK = "num\_tasks\_per\_rank"</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>Number of tasks for reading data per rank. </p>
        <p>Default will be <a href="/content/config/#config-main-external-files" target="_top">external\_file\_reader\_num\_tasks</a>.</p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L503">503</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a1c952fad1306368be55f2ac99d23437a" />

    <h2 className="memtitle"><span className="permalink"><a href="#a1c952fad1306368be55f2ac99d23437a">◆ </a></span>PERMISSIVE</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.InsertRecordsFromQueryRequest.Options.PERMISSIVE = "permissive"</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 className="el" href="/content/api/cs/namespacekinetica_1_1Records">Records</a> with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L348">348</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="acb2a8b5df8577f6001d7d7110759ba0d" />

    <h2 className="memtitle"><span className="permalink"><a href="#acb2a8b5df8577f6001d7d7110759ba0d">◆ </a></span>PK\_CONFLICT\_PREDICATE\_HIGHER</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.InsertRecordsFromQueryRequest.Options.PK\_CONFLICT\_PREDICATE\_HIGHER = "pk\_conflict\_predicate\_higher"</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 record with higher value for the column resolves the primary-key insert conflict. </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/InsertRecordsFromQuery.cs#L368">368</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="ae853c0ed8d6a2504e83e5b06b47e575d" />

    <h2 className="memtitle"><span className="permalink"><a href="#ae853c0ed8d6a2504e83e5b06b47e575d">◆ </a></span>PK\_CONFLICT\_PREDICATE\_LOWER</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.InsertRecordsFromQueryRequest.Options.PK\_CONFLICT\_PREDICATE\_LOWER = "pk\_conflict\_predicate\_lower"</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 record with lower value for the column resolves the primary-key insert conflict. </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/InsertRecordsFromQuery.cs#L373">373</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a92faabb3bfe6f359b4132e7f08883345" />

    <h2 className="memtitle"><span className="permalink"><a href="#a92faabb3bfe6f359b4132e7f08883345">◆ </a></span>PRIMARY\_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.InsertRecordsFromQueryRequest.Options.PRIMARY\_KEYS = "primary\_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 column names, to set as primary keys, when not specified in the type. </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/InsertRecordsFromQuery.cs#L508">508</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a4c98e971fe4a6d5100397e24c3aace9a" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4c98e971fe4a6d5100397e24c3aace9a">◆ </a></span>REMOTE\_QUERY</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.InsertRecordsFromQueryRequest.Options.REMOTE\_QUERY = "remote\_query"</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>Remote SQL query from which data will be sourced. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L560">560</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a8ab591279ab55420bf921efa4ad8e548" />

    <h2 className="memtitle"><span className="permalink"><a href="#a8ab591279ab55420bf921efa4ad8e548">◆ </a></span>REMOTE\_QUERY\_FILTER\_COLUMN</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.InsertRecordsFromQueryRequest.Options.REMOTE\_QUERY\_FILTER\_COLUMN = "remote\_query\_filter\_column"</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>Name of column to be used for splitting the query into multiple sub-queries using the data distribution of given column. </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/InsertRecordsFromQuery.cs#L571">571</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a610130dfea115551787f8482d9f826e4" />

    <h2 className="memtitle"><span className="permalink"><a href="#a610130dfea115551787f8482d9f826e4">◆ </a></span>REMOTE\_QUERY\_INCREASING\_COLUMN</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.InsertRecordsFromQueryRequest.Options.REMOTE\_QUERY\_INCREASING\_COLUMN = "remote\_query\_increasing\_column"</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>Column on subscribed remote query result that will increase for new records (e.g., TIMESTAMP). </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/InsertRecordsFromQuery.cs#L576">576</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="acf2143bb3d32a775b20cd642f89378d3" />

    <h2 className="memtitle"><span className="permalink"><a href="#acf2143bb3d32a775b20cd642f89378d3">◆ </a></span>REMOTE\_QUERY\_ORDER\_BY</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.InsertRecordsFromQueryRequest.Options.REMOTE\_QUERY\_ORDER\_BY = "remote\_query\_order\_by"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Name of column to be used for splitting the query into multiple sub-queries using ordering of given column. </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/InsertRecordsFromQuery.cs#L565">565</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="ad9aea6f798a43387e1af3aae7453e7cf" />

    <h2 className="memtitle"><span className="permalink"><a href="#ad9aea6f798a43387e1af3aae7453e7cf">◆ </a></span>REMOTE\_QUERY\_PARTITION\_COLUMN</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.InsertRecordsFromQueryRequest.Options.REMOTE\_QUERY\_PARTITION\_COLUMN = "remote\_query\_partition\_column"</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>Alias name for <a className="el" href="#a8ab591279ab55420bf921efa4ad8e548">REMOTE\_QUERY\_FILTER\_COLUMN</a>. </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/InsertRecordsFromQuery.cs#L582">582</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="acc85662cf45a26191a2d3aea4e6e59e4" />

    <h2 className="memtitle"><span className="permalink"><a href="#acc85662cf45a26191a2d3aea4e6e59e4">◆ </a></span>SHARD\_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.InsertRecordsFromQueryRequest.Options.SHARD\_KEYS = "shard\_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 column names, to set as shard keys, when not specified in the type. </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/InsertRecordsFromQuery.cs#L513">513</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a0d62ad2e864d1e3ccb445b40b78d0e56" />

    <h2 className="memtitle"><span className="permalink"><a href="#a0d62ad2e864d1e3ccb445b40b78d0e56">◆ </a></span>SKIP</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.InsertRecordsFromQueryRequest.Options.SKIP = "skip"</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>Malformed records are skipped. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L351">351</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a805312b92233e873b220ad5cca2174be" />

    <h2 className="memtitle"><span className="permalink"><a href="#a805312b92233e873b220ad5cca2174be">◆ </a></span>SUBSCRIBE</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.InsertRecordsFromQueryRequest.Options.SUBSCRIBE = "subscribe"</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>Continuously poll the data source to check for new data and load it into the table. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a> </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a> </li>
        </ul>

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

    <div id="a4e2111444a1cf2af5d7f48f694c6d4b9" />

    <h2 className="memtitle"><span className="permalink"><a href="#a4e2111444a1cf2af5d7f48f694c6d4b9">◆ </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.InsertRecordsFromQueryRequest.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_1InsertRecordsFromQueryRequest_1_1Options" title="A set of string constants for the parameter InsertRecordsFromQueryRequest.options.">InsertRecordsFromQueryRequest.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/InsertRecordsFromQuery.cs#L425">425</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="a77356602cd8a854b38ccadf30eda5a4f" />

    <h2 className="memtitle"><span className="permalink"><a href="#a77356602cd8a854b38ccadf30eda5a4f">◆ </a></span>TRUNCATE\_STRINGS</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.InsertRecordsFromQueryRequest.Options.TRUNCATE\_STRINGS = "truncate\_strings"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>If set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, truncate string values that are longer than the column's type size. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a> </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a> </li>
        </ul>

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

    <div id="a7225831df16a6021bf9d93fd82334ed7" />

    <h2 className="memtitle"><span className="permalink"><a href="#a7225831df16a6021bf9d93fd82334ed7">◆ </a></span>TRUNCATE\_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.InsertRecordsFromQueryRequest.Options.TRUNCATE\_TABLE = "truncate\_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 set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, truncates the table specified by <a className="el" href="/content/api/cs/classkinetica_1_1InsertRecordsFromQueryRequest#a40d8410e3a973a396dbede4afb352bb8" title="Name of the table into which the data will be inserted, in [schema_name.">InsertRecordsFromQueryRequest.table\_name</a> prior to loading the data. </p>
        <p>Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a> </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a> </li>
        </ul>

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

    <div id="a900558d5be050aee8e4f95aaf65cd971" />

    <h2 className="memtitle"><span className="permalink"><a href="#a900558d5be050aee8e4f95aaf65cd971">◆ </a></span>TYPE\_INFERENCE\_ONLY</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.InsertRecordsFromQueryRequest.Options.TYPE\_INFERENCE\_ONLY = "type\_inference\_only"</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>Infer the type of the source data and return, without ingesting any data. </p>
        <p>The inferred type is returned in the response. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L481">481</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <div id="abb7d143f7e000a0cf0015dd482d94b2a" />

    <h2 className="memtitle"><span className="permalink"><a href="#abb7d143f7e000a0cf0015dd482d94b2a">◆ </a></span>UPDATE\_ON\_EXISTING\_PK</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">const string kinetica.InsertRecordsFromQueryRequest.Options.UPDATE\_ON\_EXISTING\_PK = "update\_on\_existing\_pk"</td>
                </tr>
              </table>
            </td>

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

      <div className="memdoc">
        <p>Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. </p>
        <p>If set to <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>, any existing table record with primary key values that match those of a record being inserted will be replaced by that new record (the new data will be "upserted"). If set to <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>, any existing table record with primary key values that match those of a record being inserted will remain unchanged, while the new record will be rejected and the error handled as determined by <a className="el" href="#a69f08bf21f5358b6e8fc982916ad32b2">IGNORE\_EXISTING\_PK</a> and <a className="el" href="#a4784c4515a9155178689abbcce8a8ab9">ERROR\_HANDLING</a>. If the specified table does not have a primary key, then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#a4e2111444a1cf2af5d7f48f694c6d4b9">TRUE</a>: Upsert new records when primary keys match existing records. </li>
          <li> <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>: Reject new records when primary keys match existing records. </li>
        </ul>

        <p>The default value is <a className="el" href="#a93062a5a281ff65a5c03137bc3781fe7">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs#L669">669</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/Protocol/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.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/InsertRecordsFromQuery.cs">InsertRecordsFromQuery.cs</a></li>
    </ul>
  </div>
</div>


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