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

# AppendRecordsRequest.Options

> AppendRecordsRequest.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 AppendRecordsRequest.Options" className="title">Class AppendRecordsRequest.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.AppendRecordsRequest.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/AppendRecordsRequest" title="class in com.gpudb.protocol">AppendRecordsRequest</a></code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public static final class </span><span className="element-name type-name-label">AppendRecordsRequest.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/AppendRecordsRequest" title="class in com.gpudb.protocol"><code>AppendRecordsRequest</code></a> parameter <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#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="#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 <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>).</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="#EXPRESSION" className="member-name-link">EXPRESSION</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Filter expression to apply to the <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</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="#FALSE" className="member-name-link">FALSE</a></code></div>
            <div className="col-last even-row-color"> </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 source table records (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>) into a target table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getTableName()"><code>tableName</code></a>) 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="#LIMIT" className="member-name-link">LIMIT</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">A positive integer indicating the maximum number of results to be returned from <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>.</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="#OFFSET" className="member-name-link">OFFSET</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">A positive integer indicating the number of initial results to skip from <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</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="#ORDER_BY" className="member-name-link">ORDER\_BY</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">Comma-separated list of the columns to be sorted by from source table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>), e.g., 'timestamp asc, x desc'.</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="#PK_CONFLICT_PREDICATE_HIGHER" className="member-name-link">PK\_CONFLICT\_PREDICATE\_HIGHER</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">The record with higher value for the column resolves the primary-key insert conflict.</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="#PK_CONFLICT_PREDICATE_LOWER" className="member-name-link">PK\_CONFLICT\_PREDICATE\_LOWER</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">The record with lower value for the column resolves the primary-key insert conflict.</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="#TRUE" className="member-name-link">TRUE</a></code></div>
            <div className="col-last odd-row-color"> </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_STRINGS" className="member-name-link">TRUNCATE\_STRINGS</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">If set to <a href="#TRUE"><code>TRUE</code></a>, it allows inserting longer strings into smaller charN string columns by truncating the longer strings to fit.</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="#UPDATE_ON_EXISTING_PK" className="member-name-link">UPDATE\_ON\_EXISTING\_PK</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">Specifies the record collision policy for inserting source table records (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>) into a target table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getTableName()"><code>tableName</code></a>) 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="OFFSET">
                <h3>OFFSET</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">OFFSET</span></div>
                <div className="block">A positive integer indicating the number of initial results to skip from <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>. Default is 0. The minimum allowed value is 0. The maximum allowed value is MAX\_INT. The default value is '0'.</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.AppendRecordsRequest.Options.OFFSET">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="LIMIT">
                <h3>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">LIMIT</span></div>
                <div className="block">A positive integer indicating the maximum number of results to be returned from <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>. Or END\_OF\_SET (-9999) to indicate that the max number of results should be returned. The default value is '-9999'.</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.AppendRecordsRequest.Options.LIMIT">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="EXPRESSION">
                <h3>EXPRESSION</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">EXPRESSION</span></div>
                <div className="block">Filter expression to apply to the <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</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.AppendRecordsRequest.Options.EXPRESSION">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="ORDER_BY">
                <h3>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">ORDER\_BY</span></div>
                <div className="block">Comma-separated list of the columns to be sorted by from source table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>), e.g., 'timestamp asc, x desc'. The <a href="#ORDER_BY"><code>ORDER\_BY</code></a> columns do not have to be present in <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getFieldMap()"><code>fieldMap</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.AppendRecordsRequest.Options.ORDER_BY">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 source table records (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>) into a target table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getTableName()"><code>tableName</code></a>) 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 source table 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 source table record being inserted will remain unchanged, while the source record will be rejected and an error handled as determined by <a href="#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</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.AppendRecordsRequest.Options.UPDATE_ON_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="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.AppendRecordsRequest.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="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.AppendRecordsRequest.Options.FALSE">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 <a href="#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="#TRUE"><code>TRUE</code></a>). If set to <a href="#TRUE"><code>TRUE</code></a>, an existing record matched by primary key is modified in place. If set to <a href="#FALSE"><code>FALSE</code></a>, it is updated by deleting the existing record 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.AppendRecordsRequest.Options.ENABLE_INPLACE_UPDATES">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 source table records (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getSourceTableName()"><code>sourceTableName</code></a>) into a target table (specified by <a href="/content/api/java/com/gpudb/protocol/AppendRecordsRequest#getTableName()"><code>tableName</code></a>) 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 source table record being inserted that is rejected for having primary key values that match those of an existing target table record will be ignored with no error generated. If <a href="#FALSE"><code>FALSE</code></a>, the rejection of any source table record for having primary key values matching an existing target table record will result in an error being raised. 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 source table records whose primary key values collide with those of target table records. </li>
                    <li><a href="#FALSE"><code>FALSE</code></a>: Raise an error for any source table record whose primary key values collide with those of a target table record. </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.AppendRecordsRequest.Options.IGNORE_EXISTING_PK">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PK_CONFLICT_PREDICATE_HIGHER">
                <h3>PK\_CONFLICT\_PREDICATE\_HIGHER</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">PK\_CONFLICT\_PREDICATE\_HIGHER</span></div>
                <div className="block">The record with higher value for the column resolves the primary-key insert conflict. 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.AppendRecordsRequest.Options.PK_CONFLICT_PREDICATE_HIGHER">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="PK_CONFLICT_PREDICATE_LOWER">
                <h3>PK\_CONFLICT\_PREDICATE\_LOWER</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">PK\_CONFLICT\_PREDICATE\_LOWER</span></div>
                <div className="block">The record with lower value for the column resolves the primary-key insert conflict. 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.AppendRecordsRequest.Options.PK_CONFLICT_PREDICATE_LOWER">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>, it allows inserting longer strings into smaller charN string columns by truncating the longer strings to fit. 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.AppendRecordsRequest.Options.TRUNCATE_STRINGS">Constant Field Values</a></li>
                    </ul>
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>