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

# InsertRecordsFromQueryRequest.Options

> InsertRecordsFromQueryRequest.Options — Kinetica Java API

<div className="kinetica-javadoc">
  <div className="header">
    <div className="sub-title"><span className="package-label-in-type">Package</span> <a href="/content/api/java/com/gpudb/protocol/package-summary">com.gpudb.protocol</a></div>
    <h1 title="Class InsertRecordsFromQueryRequest.Options" className="title">Class InsertRecordsFromQueryRequest.Options</h1>
  </div>

  <div className="inheritance" title="Inheritance Tree">
    <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">java.lang.Object</a>
    <div className="inheritance">com.gpudb.protocol.InsertRecordsFromQueryRequest.Options</div>
  </div>

  <div className="section class-description" id="class-description">
    <div className="dl notes">
      <div className="dt">Enclosing class:</div>
      <div className="dd"><code><a href="/content/api/java/com/gpudb/protocol/InsertRecordsFromQueryRequest" title="class in com.gpudb.protocol">InsertRecordsFromQueryRequest</a></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">InsertRecordsFromQueryRequest.Options</span> <span className="extends-implements">extends <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></span></div>

    <div className="block">
      A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/InsertRecordsFromQueryRequest" title="class in com.gpudb.protocol"><code>InsertRecordsFromQueryRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/InsertRecordsFromQueryRequest#getOptions()"><code>options</code></a>.
      <p> Optional parameters.</p>
    </div>
  </div>

  <div className="section summary">
    <ul className="summary-list">
      <li>
        <div className="section field-summary" id="field-summary">
          <h2>Field Summary</h2>
          <div className="caption"><span>Fields</span></div>

          <div className="summary-table three-column-summary">
            <div className="table-header col-first">Modifier and Type</div>
            <div className="table-header col-second">Field</div>
            <div className="table-header col-last">Description</div>
            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#ABORT" className="member-name-link">ABORT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Stops current insertion and aborts entire operation when an error is encountered.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#BAD_RECORD_TABLE_LIMIT" className="member-name-link">BAD\_RECORD\_TABLE\_LIMIT</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">A positive integer indicating the maximum number of records that can be written to the bad-record-table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#BAD_RECORD_TABLE_NAME" className="member-name-link">BAD\_RECORD\_TABLE\_NAME</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Name of a table to which records that were rejected are written.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#BATCH_SIZE" className="member-name-link">BATCH\_SIZE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Number of records per batch when inserting data.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#DATASOURCE_NAME" className="member-name-link">DATASOURCE\_NAME</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Name of an existing external data source from which table will be loaded.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#DRY_RUN" className="member-name-link">DRY\_RUN</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">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 href="#ERROR_HANDLING"><code>ERROR\_HANDLING</code></a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#ENABLE_INPLACE_UPDATES" className="member-name-link">ENABLE\_INPLACE\_UPDATES</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Applies only when upserting (when update\_on\_existing\_pk is true).</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#ERROR_HANDLING" className="member-name-link">ERROR\_HANDLING</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Specifies how errors should be handled upon insertion.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#FALSE" className="member-name-link">FALSE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Reject new records when primary keys match existing records.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#FULL" className="member-name-link">FULL</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Run a type inference on the source data (if needed) and ingest.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#IGNORE_BAD_RECORDS" className="member-name-link">IGNORE\_BAD\_RECORDS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Malformed records are skipped.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#IGNORE_EXISTING_PK" className="member-name-link">IGNORE\_EXISTING\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">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 href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#INGESTION_MODE" className="member-name-link">INGESTION\_MODE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Whether to do a full load, dry run, or perform a type inference on the source data.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#JDBC_FETCH_SIZE" className="member-name-link">JDBC\_FETCH\_SIZE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The JDBC fetch size, which determines how many rows to fetch per round trip.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#JDBC_SESSION_INIT_STATEMENT" className="member-name-link">JDBC\_SESSION\_INIT\_STATEMENT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Executes the statement per each JDBC session before doing actual load.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#NUM_SPLITS_PER_RANK" className="member-name-link">NUM\_SPLITS\_PER\_RANK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Number of splits for reading data per rank.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#NUM_TASKS_PER_RANK" className="member-name-link">NUM\_TASKS\_PER\_RANK</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Number of tasks for reading data per rank.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#PERMISSIVE" className="member-name-link">PERMISSIVE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Records with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#PRIMARY_KEYS" className="member-name-link">PRIMARY\_KEYS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma separated list of column names, to set as primary keys, when not specified in the type.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#REMOTE_QUERY" className="member-name-link">REMOTE\_QUERY</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Remote SQL query from which data will be sourced.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#REMOTE_QUERY_FILTER_COLUMN" className="member-name-link">REMOTE\_QUERY\_FILTER\_COLUMN</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Name of column to be used for splitting the query into multiple sub-queries using the data distribution of given column.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#REMOTE_QUERY_INCREASING_COLUMN" className="member-name-link">REMOTE\_QUERY\_INCREASING\_COLUMN</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Column on subscribed remote query result that will increase for new records (e.g., TIMESTAMP).</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#REMOTE_QUERY_ORDER_BY" className="member-name-link">REMOTE\_QUERY\_ORDER\_BY</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Name of column to be used for splitting the query into multiple sub-queries using ordering of given column.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#REMOTE_QUERY_PARTITION_COLUMN" className="member-name-link">REMOTE\_QUERY\_PARTITION\_COLUMN</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Alias name for <a href="#REMOTE_QUERY_FILTER_COLUMN"><code>REMOTE\_QUERY\_FILTER\_COLUMN</code></a>.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#SHARD_KEYS" className="member-name-link">SHARD\_KEYS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma separated list of column names, to set as shard keys, when not specified in the type.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#SUBSCRIBE" className="member-name-link">SUBSCRIBE</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Continuously poll the data source to check for new data and load it into the table.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TRUE" className="member-name-link">TRUE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Upsert new records when primary keys match existing records.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#TRUNCATE_STRINGS" className="member-name-link">TRUNCATE\_STRINGS</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, truncate string values that are longer than the column's type size.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#TRUNCATE_TABLE" className="member-name-link">TRUNCATE\_TABLE</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, truncates the table specified by <a href="/content/api/java/com/gpudb/protocol/InsertRecordsFromQueryRequest#getTableName()"><code>tableName</code></a> prior to loading the data.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second odd-row-color"><code><a href="#TYPE_INFERENCE_ONLY" className="member-name-link">TYPE\_INFERENCE\_ONLY</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Infer the type of the source data and return, without ingesting any data.</div>
            </div>

            <div className="col-first even-row-color"><code>static final <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></code></div>
            <div className="col-second even-row-color"><code><a href="#UPDATE_ON_EXISTING_PK" className="member-name-link">UPDATE\_ON\_EXISTING\_PK</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>.</div>
            </div>
          </div>
        </div>
      </li>

      <li>
        <div className="section method-summary" id="method-summary">
          <h2>Method Summary</h2>

          <div className="inherited-list">
            <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" className="external-link">Object</a></h3>
            <code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" className="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" className="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" className="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" className="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" className="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" className="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" className="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" className="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" className="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" className="external-link">wait</a></code>
          </div>
        </div>
      </li>
    </ul>
  </div>

  <div className="section details">
    <ul className="details-list">
      <li>
        <div className="section field-details" id="field-detail">
          <h2>Field Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="BAD_RECORD_TABLE_NAME">
                <h3>BAD\_RECORD\_TABLE\_NAME</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">BAD\_RECORD\_TABLE\_NAME</span></div>
                <div className="block">Name of a table to which records that were rejected are written. 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.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.BAD_RECORD_TABLE_NAME">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="BAD_RECORD_TABLE_LIMIT">
                <h3>BAD\_RECORD\_TABLE\_LIMIT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">BAD\_RECORD\_TABLE\_LIMIT</span></div>
                <div className="block">A positive integer indicating the maximum number of records that can be written to the bad-record-table. Default value is 10000.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.BAD_RECORD_TABLE_LIMIT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="BATCH_SIZE">
                <h3>BATCH\_SIZE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">BATCH\_SIZE</span></div>
                <div className="block">Number of records per batch when inserting data.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.BATCH_SIZE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DATASOURCE_NAME">
                <h3>DATASOURCE\_NAME</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">DATASOURCE\_NAME</span></div>
                <div className="block">Name of an existing external data source from which table will be loaded.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.DATASOURCE_NAME">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ERROR_HANDLING">
                <h3>ERROR\_HANDLING</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">ERROR\_HANDLING</span></div>

                <div className="block">
                  Specifies how errors should be handled upon insertion. Supported values:

                  <ul>
                    <li><a href="#PERMISSIVE"><code>PERMISSIVE</code></a>: Records with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped. </li>
                    <li><a href="#IGNORE_BAD_RECORDS"><code>IGNORE\_BAD\_RECORDS</code></a>: Malformed records are skipped. </li>
                    <li><a href="#ABORT"><code>ABORT</code></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>

                  The default value is <a href="#ABORT"><code>ABORT</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.ERROR_HANDLING">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PERMISSIVE">
                <h3>PERMISSIVE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PERMISSIVE</span></div>
                <div className="block">Records with missing columns are populated with nulls if possible; otherwise, the malformed records are skipped.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.PERMISSIVE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="IGNORE_BAD_RECORDS">
                <h3>IGNORE\_BAD\_RECORDS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">IGNORE\_BAD\_RECORDS</span></div>
                <div className="block">Malformed records are skipped.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.IGNORE_BAD_RECORDS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ABORT">
                <h3>ABORT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">ABORT</span></div>
                <div className="block">Stops current insertion and aborts entire operation when an error is encountered. Primary key collisions are considered abortable errors in this mode.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.ABORT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="IGNORE_EXISTING_PK">
                <h3>IGNORE\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">IGNORE\_EXISTING\_PK</span></div>

                <div className="block">
                  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 href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#FALSE"><code>FALSE</code></a>). If set to <a href="#TRUE"><code>TRUE</code></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 href="#FALSE"><code>FALSE</code></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 href="#ERROR_HANDLING"><code>ERROR\_HANDLING</code></a>. If the specified table does not have a primary key or if upsert mode is in effect (<a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>), then this option has no effect. Supported values:

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

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.IGNORE_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUE">
                <h3>TRUE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUE</span></div>
                <div className="block">Upsert new records when primary keys match existing records.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.TRUE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FALSE">
                <h3>FALSE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FALSE</span></div>
                <div className="block">Reject new records when primary keys match existing records.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.FALSE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="INGESTION_MODE">
                <h3>INGESTION\_MODE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">INGESTION\_MODE</span></div>

                <div className="block">
                  Whether to do a full load, dry run, or perform a type inference on the source data. Supported values:

                  <ul>
                    <li><a href="#FULL"><code>FULL</code></a>: Run a type inference on the source data (if needed) and ingest. </li>
                    <li><a href="#DRY_RUN"><code>DRY\_RUN</code></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 href="#ERROR_HANDLING"><code>ERROR\_HANDLING</code></a>. </li>
                    <li><a href="#TYPE_INFERENCE_ONLY"><code>TYPE\_INFERENCE\_ONLY</code></a>: Infer the type of the source data and return, without ingesting any data. The inferred type is returned in the response. </li>
                  </ul>

                  The default value is <a href="#FULL"><code>FULL</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.INGESTION_MODE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="FULL">
                <h3>FULL</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">FULL</span></div>
                <div className="block">Run a type inference on the source data (if needed) and ingest.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.FULL">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="DRY_RUN">
                <h3>DRY\_RUN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">DRY\_RUN</span></div>
                <div className="block">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 href="#ERROR_HANDLING"><code>ERROR\_HANDLING</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.DRY_RUN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TYPE_INFERENCE_ONLY">
                <h3>TYPE\_INFERENCE\_ONLY</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TYPE\_INFERENCE\_ONLY</span></div>
                <div className="block">Infer the type of the source data and return, without ingesting any data. The inferred type is returned in the response.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.TYPE_INFERENCE_ONLY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="JDBC_FETCH_SIZE">
                <h3>JDBC\_FETCH\_SIZE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">JDBC\_FETCH\_SIZE</span></div>
                <div className="block">The JDBC fetch size, which determines how many rows to fetch per round trip.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.JDBC_FETCH_SIZE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="JDBC_SESSION_INIT_STATEMENT">
                <h3>JDBC\_SESSION\_INIT\_STATEMENT</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">JDBC\_SESSION\_INIT\_STATEMENT</span></div>
                <div className="block">Executes the statement per each JDBC session before doing actual load. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.JDBC_SESSION_INIT_STATEMENT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="NUM_SPLITS_PER_RANK">
                <h3>NUM\_SPLITS\_PER\_RANK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">NUM\_SPLITS\_PER\_RANK</span></div>
                <div className="block">Number of splits for reading data per rank. Default will be external\_file\_reader\_num\_tasks. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.NUM_SPLITS_PER_RANK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="NUM_TASKS_PER_RANK">
                <h3>NUM\_TASKS\_PER\_RANK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">NUM\_TASKS\_PER\_RANK</span></div>
                <div className="block">Number of tasks for reading data per rank. Default will be external\_file\_reader\_num\_tasks.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.NUM_TASKS_PER_RANK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PRIMARY_KEYS">
                <h3>PRIMARY\_KEYS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">PRIMARY\_KEYS</span></div>
                <div className="block">Comma separated list of column names, to set as primary keys, when not specified in the type. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.PRIMARY_KEYS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="SHARD_KEYS">
                <h3>SHARD\_KEYS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">SHARD\_KEYS</span></div>
                <div className="block">Comma separated list of column names, to set as shard keys, when not specified in the type. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.SHARD_KEYS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="SUBSCRIBE">
                <h3>SUBSCRIBE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">SUBSCRIBE</span></div>

                <div className="block">
                  Continuously poll the data source to check for new data and load it into the table. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.SUBSCRIBE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUNCATE_TABLE">
                <h3>TRUNCATE\_TABLE</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUNCATE\_TABLE</span></div>

                <div className="block">
                  If set to <a href="#TRUE"><code>TRUE</code></a>, truncates the table specified by <a href="/content/api/java/com/gpudb/protocol/InsertRecordsFromQueryRequest#getTableName()"><code>tableName</code></a> prior to loading the data. Supported values:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.TRUNCATE_TABLE">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REMOTE_QUERY">
                <h3>REMOTE\_QUERY</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REMOTE\_QUERY</span></div>
                <div className="block">Remote SQL query from which data will be sourced.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.REMOTE_QUERY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REMOTE_QUERY_ORDER_BY">
                <h3>REMOTE\_QUERY\_ORDER\_BY</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REMOTE\_QUERY\_ORDER\_BY</span></div>
                <div className="block">Name of column to be used for splitting the query into multiple sub-queries using ordering of given column. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.REMOTE_QUERY_ORDER_BY">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REMOTE_QUERY_FILTER_COLUMN">
                <h3>REMOTE\_QUERY\_FILTER\_COLUMN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REMOTE\_QUERY\_FILTER\_COLUMN</span></div>
                <div className="block">Name of column to be used for splitting the query into multiple sub-queries using the data distribution of given column. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.REMOTE_QUERY_FILTER_COLUMN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REMOTE_QUERY_INCREASING_COLUMN">
                <h3>REMOTE\_QUERY\_INCREASING\_COLUMN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REMOTE\_QUERY\_INCREASING\_COLUMN</span></div>
                <div className="block">Column on subscribed remote query result that will increase for new records (e.g., TIMESTAMP). The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.REMOTE_QUERY_INCREASING_COLUMN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="REMOTE_QUERY_PARTITION_COLUMN">
                <h3>REMOTE\_QUERY\_PARTITION\_COLUMN</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">REMOTE\_QUERY\_PARTITION\_COLUMN</span></div>
                <div className="block">Alias name for <a href="#REMOTE_QUERY_FILTER_COLUMN"><code>REMOTE\_QUERY\_FILTER\_COLUMN</code></a>. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.REMOTE_QUERY_PARTITION_COLUMN">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="TRUNCATE_STRINGS">
                <h3>TRUNCATE\_STRINGS</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">TRUNCATE\_STRINGS</span></div>

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

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.TRUNCATE_STRINGS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ENABLE_INPLACE_UPDATES">
                <h3>ENABLE\_INPLACE\_UPDATES</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">ENABLE\_INPLACE\_UPDATES</span></div>

                <div className="block">
                  Applies only when upserting (when update\_on\_existing\_pk is true). 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:

                  <ul>
                    <li><a href="#TRUE"><code>TRUE</code></a> </li>
                    <li><a href="#FALSE"><code>FALSE</code></a> </li>
                  </ul>

                  The default value is <a href="#TRUE"><code>TRUE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.ENABLE_INPLACE_UPDATES">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="UPDATE_ON_EXISTING_PK">
                <h3>UPDATE\_ON\_EXISTING\_PK</h3>
                <div className="member-signature"><span className="modifiers">public static final</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a></span> <span className="element-name">UPDATE\_ON\_EXISTING\_PK</span></div>

                <div className="block">
                  Specifies the record collision policy for inserting into a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="#TRUE"><code>TRUE</code></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 href="#FALSE"><code>FALSE</code></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 href="#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a> and <a href="#ERROR_HANDLING"><code>ERROR\_HANDLING</code></a>. If the specified table does not have a primary key, then this option has no effect. Supported values:

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

                  The default value is <a href="#FALSE"><code>FALSE</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">See Also:</div>

                  <div className="dd">
                    <ul className="tag-list">
                      <li><a href="/content/api/java/constant-values#com.gpudb.protocol.InsertRecordsFromQueryRequest.Options.UPDATE_ON_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>