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

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Static Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a0cf506290b6d7de0277cb35a7bc50a2a" id="r_a0cf506290b6d7de0277cb35a7bc50a2a">
        <td className="memItemLeft" align="right" valign="top">const string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a0cf506290b6d7de0277cb35a7bc50a2a">BAD\_RECORD\_TABLE\_NAME</a> = "bad\_record\_table\_name"</td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:aafe56a653f1991b5f7219194b7eccb79">
        <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="#afa39c47ae87f00a2fae9f4a3337937e3">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>). <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a69c1871242bb3800649d8009012457a5">
        <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="#aa6e556c8e5d9270ea46dc23771e2f36c">ERROR\_HANDLING</a>. <br /></td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

      <tr className="memdesc:a156167fa47f4b73da7d40b1ec23bd656">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">If set to <a className="el" href="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>, truncates the table specified by <a className="el" href="/content/api/cs/classkinetica_1_1InsertRecordsFromQueryRequest#af14c8eef377a35820ee43544f4e5fbb5" 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:a156167fa47f4b73da7d40b1ec23bd656">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    <div className="textblock">
      <p>A set of string constants for the parameter <a className="el" href="/content/api/cs/classkinetica_1_1InsertRecordsFromQueryRequest#ad2ff2fbd7ba6c0d695a0f8bf3a321335" title="Optional parameters.">InsertRecordsFromQueryRequest.options</a>. </p>
      <p>Optional parameters.</p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00283">283</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#a4d6a9a494d17013aace2e50acf90945b">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00349">349</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a51744203aefac7dd72372576d4fe9324">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00296">296</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0cf506290b6d7de0277cb35a7bc50a2a">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00291">291</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a2678102d9ddc71af3ae9b03acc23bd37">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00299">299</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a7e57b00c26eb302c51456e03bed89164">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00303">303</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a69c1871242bb3800649d8009012457a5">◆ </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="#aa6e556c8e5d9270ea46dc23771e2f36c">ERROR\_HANDLING</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00451">451</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

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

        <p>The default value is <a className="el" href="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00603">603</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa6e556c8e5d9270ea46dc23771e2f36c">◆ </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="#a5273c0909daca3fcb14e72f523fbb192">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="#ac23251057bed74de4688b14fbfe06d12">IGNORE\_BAD\_RECORDS</a>: Malformed records are skipped. </li>
          <li> <a className="el" href="#a4d6a9a494d17013aace2e50acf90945b">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="#a4d6a9a494d17013aace2e50acf90945b">ABORT</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00336">336</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a40eb27eee505c5fbd530ab4c957397cd">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00405">405</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5cb1e63f192a05273ac84a4e41936585">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00444">444</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac23251057bed74de4688b14fbfe06d12">◆ </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>Malformed records are skipped. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00343">343</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aafe56a653f1991b5f7219194b7eccb79">◆ </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="#afa39c47ae87f00a2fae9f4a3337937e3">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>). </p>
        <p>If set to <a className="el" href="#ac37b15d9cab97a8895646ae27d92f9b0">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="#a40eb27eee505c5fbd530ab4c957397cd">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="#aa6e556c8e5d9270ea46dc23771e2f36c">ERROR\_HANDLING</a>. If the specified table does not have a primary key or if upsert mode is in effect (<a className="el" href="#afa39c47ae87f00a2fae9f4a3337937e3">UPDATE\_ON\_EXISTING\_PK</a> is <a className="el" href="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>), then this option has no effect. Supported values:</p>

        <ul>
          <li> <a className="el" href="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>: Ignore new records whose primary key values collide with those of existing records. </li>
          <li> <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">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="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00397">397</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#af41e8c88bd0a7aafd246efe5b4a09170">◆ </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="#a5cb1e63f192a05273ac84a4e41936585">FULL</a>: Run a type inference on the source data (if needed) and ingest. </li>
          <li> <a className="el" href="#a69c1871242bb3800649d8009012457a5">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="#aa6e556c8e5d9270ea46dc23771e2f36c">ERROR\_HANDLING</a>. </li>
          <li> <a className="el" href="#aa92e0f3cbbf24804644db393ff94e0c3">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="#a5cb1e63f192a05273ac84a4e41936585">FULL</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00440">440</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#abea18423ac15b8be62da5218b42e1db5">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00461">461</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a073214968e42f2f4ac502ecd16a00db0">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00466">466</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a749faa8b93bf201612088467013b748a">◆ </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 external\_file\_reader\_num\_tasks. The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00471">471</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a0162505655986fb399729d1586a537e2">◆ </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 external\_file\_reader\_num\_tasks. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00476">476</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a5273c0909daca3fcb14e72f523fbb192">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00340">340</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a8b2d23793ccaf1067fed34d6d2fb1dfa">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00481">481</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3f19ca563ade7bea3830069d1e061a80">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00533">533</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#acd84a0bf9194891f127571c78f55e813">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00544">544</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a971f40d38c112607301f005f066be5be">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00549">549</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a1b3ea0404a2344c070f2f1a7ad5f8d50">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00538">538</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ada419f6f15f99a3a3452795b4871b141">◆ </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="#acd84a0bf9194891f127571c78f55e813">REMOTE\_QUERY\_FILTER\_COLUMN</a>. </p>
        <p>The default value is ''.</p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00555">555</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a7a300e446710a79d49310d0ee38b11ba">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00486">486</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

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

        <p>The default value is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00506">506</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#ac37b15d9cab97a8895646ae27d92f9b0">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00401">401</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

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

        <p>The default value is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00577">577</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a156167fa47f4b73da7d40b1ec23bd656">◆ </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="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>, truncates the table specified by <a className="el" href="/content/api/cs/classkinetica_1_1InsertRecordsFromQueryRequest#af14c8eef377a35820ee43544f4e5fbb5" 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="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a> </li>
          <li> <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a> </li>
        </ul>

        <p>The default value is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00529">529</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#aa92e0f3cbbf24804644db393ff94e0c3">◆ </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="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00457">457</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#afa39c47ae87f00a2fae9f4a3337937e3">◆ </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="#ac37b15d9cab97a8895646ae27d92f9b0">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="#a40eb27eee505c5fbd530ab4c957397cd">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="#aafe56a653f1991b5f7219194b7eccb79">IGNORE\_EXISTING\_PK</a> and <a className="el" href="#aa6e556c8e5d9270ea46dc23771e2f36c">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="#ac37b15d9cab97a8895646ae27d92f9b0">TRUE</a>: Upsert new records when primary keys match existing records. </li>
          <li> <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>: Reject new records when primary keys match existing records. </li>
        </ul>

        <p>The default value is <a className="el" href="#a40eb27eee505c5fbd530ab4c957397cd">FALSE</a>. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source#l00642">642</a> of file <a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a>.</p>
      </div>
    </div>

    <hr />

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

    <ul>
      <li>\_build/public-os\_ubuntu24.04-arch\_amd64-cc\_gcc\_13.3.0/install/Kinetica/Protocol/<a className="el" href="/content/api/cs/__build_2public-os__ubuntu24_804-arch__amd64-cc__gcc__13_83_80_2install_2Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a></li>
      <li>Kinetica/Protocol/<a className="el" href="/content/api/cs/Kinetica_2Protocol_2InsertRecordsFromQuery_8cs_source">InsertRecordsFromQuery.cs</a></li>
    </ul>
  </div>
</div>