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

# ExecuteSqlRequest

> ExecuteSqlRequest — 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 ExecuteSqlRequest" className="title">Class ExecuteSqlRequest</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.ExecuteSqlRequest</div>
  </div>

  <div className="section class-description" id="class-description">
    <div className="dl notes">
      <div className="dt">All Implemented Interfaces:</div>
      <div className="dd"><code>org.apache.avro.generic.GenericContainer</code>, <code>org.apache.avro.generic.IndexedRecord</code></div>
    </div>

    <hr />

    <div className="type-signature"><span className="modifiers">public class </span><span className="element-name type-name-label">ExecuteSqlRequest</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> implements org.apache.avro.generic.IndexedRecord</span></div>

    <div className="block">
      A set of parameters for <a href="/content/api/java/com/gpudb/GPUdb#executeSql(com.gpudb.protocol.ExecuteSqlRequest)"><code>GPUdb.executeSql</code></a>.
      <p> Execute a SQL statement (query, DML, or DDL). </p>
      <p> See <a href="/content/sql/" target="_top">SQL Support</a> for the complete set of supported SQL commands. </p>
      <p> When a caller wants all the results from a large query (e.g., more than <a href="/content/config/#config-main-general" target="_top">max\_get\_records\_size</a> records), they can make multiple calls to this endpoint using the <a href="#getOffset()"><code>offset</code></a> and <a href="#getLimit()"><code>limit</code></a> parameters to page through the results. Normally, this will execute the <a href="#getStatement()"><code>statement</code></a> query each time. To avoid re-executing the query each time and to keep the results in the same order, the caller should specify a <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a> name to hold the results of the query between calls and specify the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a> on subsequent calls. When this is done, the caller should clear the paging table and any other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done paging through the results. <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> (and <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a>) will be empty if no paging table was created (e.g., when all the query results were returned in the first call).</p>
    </div>
  </div>

  <div className="section summary">
    <ul className="summary-list">
      <li>
        <div className="section nested-class-summary" id="nested-class-summary">
          <h2>Nested Class Summary</h2>
          <div className="caption"><span>Nested Classes</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">Class</div>
            <div className="table-header col-last">Description</div>
            <div className="col-first even-row-color"><code>static final class </code></div>
            <div className="col-second even-row-color"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding" className="type-name-link" title="class in com.gpudb.protocol">ExecuteSqlRequest.Encoding</a></code></div>

            <div className="col-last even-row-color">
              <div className="block">A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol"><code>ExecuteSqlRequest</code></a> parameter <a href="#getEncoding()"><code>encoding</code></a>.</div>
            </div>

            <div className="col-first odd-row-color"><code>static final class </code></div>
            <div className="col-second odd-row-color"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options" className="type-name-link" title="class in com.gpudb.protocol">ExecuteSqlRequest.Options</a></code></div>

            <div className="col-last odd-row-color">
              <div className="block">A set of string constants for the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol"><code>ExecuteSqlRequest</code></a> parameter <a href="#getOptions()"><code>options</code></a>.</div>
            </div>
          </div>
        </div>
      </li>

      <li>
        <div className="section constructor-summary" id="constructor-summary">
          <h2>Constructor Summary</h2>
          <div className="caption"><span>Constructors</span></div>

          <div className="summary-table two-column-summary">
            <div className="table-header col-first">Constructor</div>
            <div className="table-header col-last">Description</div>
            <div className="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E()" className="member-name-link">ExecuteSqlRequest</a>()</code></div>

            <div className="col-last even-row-color">
              <div className="block">Constructs an ExecuteSqlRequest object with default parameters.</div>
            </div>

            <div className="col-constructor-name odd-row-color"><code><a href="#%3Cinit%3E(java.lang.String,long,long,java.lang.String,java.lang.String,java.util.List,java.util.Map)" className="member-name-link">ExecuteSqlRequest</a><wbr />(<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> statement, long offset, long limit, <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> encoding, <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> requestSchemaStr, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</code></div>

            <div className="col-last odd-row-color">
              <div className="block">Constructs an ExecuteSqlRequest object with the specified parameters.</div>
            </div>

            <div className="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E(java.lang.String,long,long,java.lang.String,java.util.List,java.util.Map)" className="member-name-link">ExecuteSqlRequest</a><wbr />(<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> statement, long offset, long limit, <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> requestSchemaStr, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</code></div>

            <div className="col-last even-row-color">
              <div className="block">Constructs an ExecuteSqlRequest object with the specified parameters.</div>
            </div>
          </div>
        </div>
      </li>

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

          <div id="method-summary-table">
            <div className="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabIndex="0" className="active-table-tab">All Methods</button><button id="method-summary-table-tab1" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabIndex="-1" className="table-tab">Static Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabIndex="-1" className="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabIndex="-1" className="table-tab">Concrete Methods</button></div>

            <div id="method-summary-table.tabpanel" role="tabpanel" aria-labelledby="method-summary-table-tab0">
              <div className="summary-table three-column-summary">
                <div className="table-header col-first">Modifier and Type</div>
                <div className="table-header col-second">Method</div>
                <div className="table-header col-last">Description</div>
                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>boolean</code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#equals(java.lang.Object)" className="member-name-link">equals</a><wbr />(<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> obj)</code></div>
                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> </div>
                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><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></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#get(int)" className="member-name-link">get</a><wbr />(int index)</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code>static org.apache.avro.Schema</code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4"><code><a href="#getClassSchema()" className="member-name-link">getClassSchema</a>()</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab1 method-summary-table-tab4">
                  <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a><wbr />\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getData()" className="member-name-link">getData</a>()</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">An array of binary-encoded data for the records to be binded to the SQL query.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><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 method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getEncoding()" className="member-name-link">getEncoding</a>()</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Specifies the encoding for returned records; either 'binary' or 'json'.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>long</code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getLimit()" className="member-name-link">getLimit</a>()</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>long</code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getOffset()" className="member-name-link">getOffset</a>()</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">A positive integer indicating the number of initial results to skip (this can be useful for paging through the results).</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a><wbr />\<<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>,<wbr /><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 method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getOptions()" className="member-name-link">getOptions</a>()</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Optional parameters.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><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 method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getRequestSchemaStr()" className="member-name-link">getRequestSchemaStr</a>()</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Avro schema of <a href="#getData()"><code>data</code></a>.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>org.apache.avro.Schema</code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getSchema()" className="member-name-link">getSchema</a>()</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><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 method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#getStatement()" className="member-name-link">getStatement</a>()</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">SQL statement (query, DML, or DDL) to be executed.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>int</code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#hashCode()" className="member-name-link">hashCode</a>()</code></div>
                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> </div>
                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code>void</code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#put(int,java.lang.Object)" className="member-name-link">put</a><wbr />(int index, <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> value)</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setData(java.util.List)" className="member-name-link">setData</a><wbr />(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data)</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">An array of binary-encoded data for the records to be binded to the SQL query.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setEncoding(java.lang.String)" className="member-name-link">setEncoding</a><wbr />(<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> encoding)</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Specifies the encoding for returned records; either 'binary' or 'json'.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setLimit(long)" className="member-name-link">setLimit</a><wbr />(long limit)</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setOffset(long)" className="member-name-link">setOffset</a><wbr />(long offset)</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">A positive integer indicating the number of initial results to skip (this can be useful for paging through the results).</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setOptions(java.util.Map)" className="member-name-link">setOptions</a><wbr />(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Optional parameters.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setRequestSchemaStr(java.lang.String)" className="member-name-link">setRequestSchemaStr</a><wbr />(<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> requestSchemaStr)</code></div>

                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">Avro schema of <a href="#getData()"><code>data</code></a>.</div>
                </div>

                <div className="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></code></div>
                <div className="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#setStatement(java.lang.String)" className="member-name-link">setStatement</a><wbr />(<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> statement)</code></div>

                <div className="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">
                  <div className="block">SQL statement (query, DML, or DDL) to be executed.</div>
                </div>

                <div className="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><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 method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#toString()" className="member-name-link">toString</a>()</code></div>
                <div className="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> </div>
              </div>
            </div>
          </div>

          <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#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#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#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 constructor-details" id="constructor-detail">
          <h2>Constructor Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="<init>()">
                <h3>ExecuteSqlRequest</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="element-name">ExecuteSqlRequest</span>()</div>
                <div className="block">Constructs an ExecuteSqlRequest object with default parameters.</div>
              </div>
            </li>

            <li>
              <div className="section detail" id="<init>(java.lang.String,long,long,java.lang.String,java.util.List,java.util.Map)">
                <h3>ExecuteSqlRequest</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="element-name">ExecuteSqlRequest</span><wbr /><span className="parameters">(<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> statement, long offset, long limit, <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> requestSchemaStr, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</span></div>
                <div className="block">Constructs an ExecuteSqlRequest object with the specified parameters.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>statement</code> - SQL statement (query, DML, or DDL) to be executed.</div>
                  <div className="dd"><code>offset</code> - A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0. The minimum allowed value is 0. The maximum allowed value is MAX\_INT.</div>
                  <div className="dd"><code>limit</code> - A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the <a href="/content/config/#config-main-general" target="_top">max\_get\_records\_size</a> parameter in the server configuration. Use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> to see if more records exist in the result to be fetched, and <code>offset</code> and <code>limit</code> to request subsequent pages of results. The default value is -9999.</div>
                  <div className="dd"><code>requestSchemaStr</code> - Avro schema of <code>data</code>. The default value is ''.</div>
                  <div className="dd"><code>data</code> - An array of binary-encoded data for the records to be binded to the SQL query. Or use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a> to pass the data in JSON format. The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link"><code>List</code></a>.</div>

                  <div className="dd">
                    <code>options</code> - Optional parameters.

                    <ul>
                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#COST_BASED_OPTIMIZATION"><code>COST\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_JOINS"><code>DISTRIBUTED\_JOINS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_OPERATIONS"><code>DISTRIBUTED\_OPERATIONS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>: Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>). If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any record insert/update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, the rejection of any insert/update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then this option has no effect. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Ignore inserts/updates that result in primary key collisions with existing records. </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Treat as errors any inserts/updates that result in primary key collisions with existing records. </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#LATE_MATERIALIZATION"><code>LATE\_MATERIALIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format). Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a>: When specified (or <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>). If the specified paging table exists, the records from the paging table are returned without re-evaluating the query. It is the caller's responsibility to clear the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done with this query. </li>
                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. -1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) will be automatically cleared after the TTL expires, if set to a positive number. However, it is still recommended that the caller clear these tables when they are done with this query. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PARALLEL_EXECUTION"><code>PARALLEL\_EXECUTION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PLAN_CACHE"><code>PLAN\_CACHE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables plan caching for the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PREPARE_MODE"><code>PREPARE\_MODE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PRESERVE_DICT_ENCODING"><code>PRESERVE\_DICT\_ENCODING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a>: Query parameters in JSON array or arrays (for inserting multiple rows). This can be used instead of <code>data</code> and <code>requestSchemaStr</code>. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RESULTS_CACHING"><code>RESULTS\_CACHING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RULE_BASED_OPTIMIZATION"><code>RULE\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#SSQ_OPTIMIZATION"><code>SSQ\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TTL"><code>TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a>: Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted or updated will be replaced by that record. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#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="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Replace the collided-into record with the record inserted or updated when a new/modified record causes a primary key collision with an existing record. </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#VALIDATE_CHANGE_COLUMN"><code>VALIDATE\_CHANGE\_COLUMN</code></a>: When changing a column using alter table, validate the change before applying it. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then validate all values. A value too large (or too long) for the new type will prevent any change. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, then when a value is too large or long, it will be truncated. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#CURRENT_SCHEMA"><code>CURRENT\_SCHEMA</code></a>: Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. </li>
                    </ul>

                    The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.
                  </div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="<init>(java.lang.String,long,long,java.lang.String,java.lang.String,java.util.List,java.util.Map)">
                <h3>ExecuteSqlRequest</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="element-name">ExecuteSqlRequest</span><wbr /><span className="parameters">(<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> statement, long offset, long limit, <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> encoding, <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> requestSchemaStr, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</span></div>
                <div className="block">Constructs an ExecuteSqlRequest object with the specified parameters.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>statement</code> - SQL statement (query, DML, or DDL) to be executed.</div>
                  <div className="dd"><code>offset</code> - A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0. The minimum allowed value is 0. The maximum allowed value is MAX\_INT.</div>
                  <div className="dd"><code>limit</code> - A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the <a href="/content/config/#config-main-general" target="_top">max\_get\_records\_size</a> parameter in the server configuration. Use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> to see if more records exist in the result to be fetched, and <code>offset</code> and <code>limit</code> to request subsequent pages of results. The default value is -9999.</div>

                  <div className="dd">
                    <code>encoding</code> - Specifies the encoding for returned records; either 'binary' or 'json'. Supported values:

                    <ul>
                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a> </li>
                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#JSON"><code>JSON</code></a> </li>
                    </ul>

                    The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a>.
                  </div>

                  <div className="dd"><code>requestSchemaStr</code> - Avro schema of <code>data</code>. The default value is ''.</div>
                  <div className="dd"><code>data</code> - An array of binary-encoded data for the records to be binded to the SQL query. Or use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a> to pass the data in JSON format. The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link"><code>List</code></a>.</div>

                  <div className="dd">
                    <code>options</code> - Optional parameters.

                    <ul>
                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#COST_BASED_OPTIMIZATION"><code>COST\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_JOINS"><code>DISTRIBUTED\_JOINS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_OPERATIONS"><code>DISTRIBUTED\_OPERATIONS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>: Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>). If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any record insert/update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, the rejection of any insert/update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then this option has no effect. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Ignore inserts/updates that result in primary key collisions with existing records. </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Treat as errors any inserts/updates that result in primary key collisions with existing records. </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#LATE_MATERIALIZATION"><code>LATE\_MATERIALIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format). Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a>: When specified (or <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>). If the specified paging table exists, the records from the paging table are returned without re-evaluating the query. It is the caller's responsibility to clear the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done with this query. </li>
                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. -1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) will be automatically cleared after the TTL expires, if set to a positive number. However, it is still recommended that the caller clear these tables when they are done with this query. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PARALLEL_EXECUTION"><code>PARALLEL\_EXECUTION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PLAN_CACHE"><code>PLAN\_CACHE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables plan caching for the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PREPARE_MODE"><code>PREPARE\_MODE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PRESERVE_DICT_ENCODING"><code>PRESERVE\_DICT\_ENCODING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a>: Query parameters in JSON array or arrays (for inserting multiple rows). This can be used instead of <code>data</code> and <code>requestSchemaStr</code>. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RESULTS_CACHING"><code>RESULTS\_CACHING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RULE_BASED_OPTIMIZATION"><code>RULE\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#SSQ_OPTIMIZATION"><code>SSQ\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TTL"><code>TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a>: Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted or updated will be replaced by that record. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#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="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Replace the collided-into record with the record inserted or updated when a new/modified record causes a primary key collision with an existing record. </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                      </li>

                      <li>
                        <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#VALIDATE_CHANGE_COLUMN"><code>VALIDATE\_CHANGE\_COLUMN</code></a>: When changing a column using alter table, validate the change before applying it. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then validate all values. A value too large (or too long) for the new type will prevent any change. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, then when a value is too large or long, it will be truncated. Supported values:

                        <ul>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                          <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                        </ul>

                        The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                      </li>

                      <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#CURRENT_SCHEMA"><code>CURRENT\_SCHEMA</code></a>: Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. </li>
                    </ul>

                    The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.
                  </div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>

      <li>
        <div className="section method-details" id="method-detail">
          <h2>Method Details</h2>

          <ul className="member-list">
            <li>
              <div className="section detail" id="getClassSchema()">
                <h3>getClassSchema</h3>
                <div className="member-signature"><span className="modifiers">public static</span> <span className="return-type">org.apache.avro.Schema</span> <span className="element-name">getClassSchema</span>()</div>
                <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The schema for the class.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getStatement()">
                <h3>getStatement</h3>
                <div className="member-signature"><span className="modifiers">public</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">getStatement</span>()</div>
                <div className="block">SQL statement (query, DML, or DDL) to be executed.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>statement</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setStatement(java.lang.String)">
                <h3>setStatement</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setStatement</span><wbr /><span className="parameters">(<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> statement)</span></div>
                <div className="block">SQL statement (query, DML, or DDL) to be executed.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>statement</code> - The new value for <code>statement</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getOffset()">
                <h3>getOffset</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">long</span> <span className="element-name">getOffset</span>()</div>
                <div className="block">A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0. The minimum allowed value is 0. The maximum allowed value is MAX\_INT.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>offset</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setOffset(long)">
                <h3>setOffset</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setOffset</span><wbr /><span className="parameters">(long offset)</span></div>
                <div className="block">A positive integer indicating the number of initial results to skip (this can be useful for paging through the results). The default value is 0. The minimum allowed value is 0. The maximum allowed value is MAX\_INT.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>offset</code> - The new value for <code>offset</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getLimit()">
                <h3>getLimit</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">long</span> <span className="element-name">getLimit</span>()</div>
                <div className="block">A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the <a href="/content/config/#config-main-general" target="_top">max\_get\_records\_size</a> parameter in the server configuration. Use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> to see if more records exist in the result to be fetched, and <a href="#getOffset()"><code>offset</code></a> and <a href="#getLimit()"><code>limit</code></a> to request subsequent pages of results. The default value is -9999.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>limit</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setLimit(long)">
                <h3>setLimit</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setLimit</span><wbr /><span className="parameters">(long limit)</span></div>
                <div className="block">A positive integer indicating the maximum number of results to be returned, or END\_OF\_SET (-9999) to indicate that the maximum number of results allowed by the server should be returned. The number of records returned will never exceed the server's own limit, defined by the <a href="/content/config/#config-main-general" target="_top">max\_get\_records\_size</a> parameter in the server configuration. Use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> to see if more records exist in the result to be fetched, and <a href="#getOffset()"><code>offset</code></a> and <a href="#getLimit()"><code>limit</code></a> to request subsequent pages of results. The default value is -9999.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>limit</code> - The new value for <code>limit</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getEncoding()">
                <h3>getEncoding</h3>
                <div className="member-signature"><span className="modifiers">public</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">getEncoding</span>()</div>

                <div className="block">
                  Specifies the encoding for returned records; either 'binary' or 'json'. Supported values:

                  <ul>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a> </li>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#JSON"><code>JSON</code></a> </li>
                  </ul>

                  The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>encoding</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setEncoding(java.lang.String)">
                <h3>setEncoding</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setEncoding</span><wbr /><span className="parameters">(<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> encoding)</span></div>

                <div className="block">
                  Specifies the encoding for returned records; either 'binary' or 'json'. Supported values:

                  <ul>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a> </li>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#JSON"><code>JSON</code></a> </li>
                  </ul>

                  The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Encoding#BINARY"><code>BINARY</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>encoding</code> - The new value for <code>encoding</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getRequestSchemaStr()">
                <h3>getRequestSchemaStr</h3>
                <div className="member-signature"><span className="modifiers">public</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">getRequestSchemaStr</span>()</div>
                <div className="block">Avro schema of <a href="#getData()"><code>data</code></a>. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>requestSchemaStr</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setRequestSchemaStr(java.lang.String)">
                <h3>setRequestSchemaStr</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setRequestSchemaStr</span><wbr /><span className="parameters">(<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> requestSchemaStr)</span></div>
                <div className="block">Avro schema of <a href="#getData()"><code>data</code></a>. The default value is ''.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>requestSchemaStr</code> - The new value for <code>requestSchemaStr</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getData()">
                <h3>getData</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>></span> <span className="element-name">getData</span>()</div>
                <div className="block">An array of binary-encoded data for the records to be binded to the SQL query. Or use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a> to pass the data in JSON format. The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link"><code>List</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>data</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setData(java.util.List)">
                <h3>setData</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setData</span><wbr /><span className="parameters">(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link">List</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/nio/ByteBuffer.html" title="class or interface in java.nio" className="external-link">ByteBuffer</a>> data)</span></div>
                <div className="block">An array of binary-encoded data for the records to be binded to the SQL query. Or use <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a> to pass the data in JSON format. The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/List.html" title="class or interface in java.util" className="external-link"><code>List</code></a>.</div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>data</code> - The new value for <code>data</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getOptions()">
                <h3>getOptions</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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">getOptions</span>()</div>

                <div className="block">
                  Optional parameters.

                  <ul>
                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#COST_BASED_OPTIMIZATION"><code>COST\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_JOINS"><code>DISTRIBUTED\_JOINS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_OPERATIONS"><code>DISTRIBUTED\_OPERATIONS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>: Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>). If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any record insert/update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, the rejection of any insert/update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then this option has no effect. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Ignore inserts/updates that result in primary key collisions with existing records. </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Treat as errors any inserts/updates that result in primary key collisions with existing records. </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#LATE_MATERIALIZATION"><code>LATE\_MATERIALIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format). Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a>: When specified (or <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>). If the specified paging table exists, the records from the paging table are returned without re-evaluating the query. It is the caller's responsibility to clear the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done with this query. </li>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. -1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) will be automatically cleared after the TTL expires, if set to a positive number. However, it is still recommended that the caller clear these tables when they are done with this query. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PARALLEL_EXECUTION"><code>PARALLEL\_EXECUTION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PLAN_CACHE"><code>PLAN\_CACHE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables plan caching for the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PREPARE_MODE"><code>PREPARE\_MODE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PRESERVE_DICT_ENCODING"><code>PRESERVE\_DICT\_ENCODING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a>: Query parameters in JSON array or arrays (for inserting multiple rows). This can be used instead of <a href="#getData()"><code>data</code></a> and <a href="#getRequestSchemaStr()"><code>requestSchemaStr</code></a>. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RESULTS_CACHING"><code>RESULTS\_CACHING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RULE_BASED_OPTIMIZATION"><code>RULE\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#SSQ_OPTIMIZATION"><code>SSQ\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TTL"><code>TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a>: Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted or updated will be replaced by that record. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#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="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Replace the collided-into record with the record inserted or updated when a new/modified record causes a primary key collision with an existing record. </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#VALIDATE_CHANGE_COLUMN"><code>VALIDATE\_CHANGE\_COLUMN</code></a>: When changing a column using alter table, validate the change before applying it. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then validate all values. A value too large (or too long) for the new type will prevent any change. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, then when a value is too large or long, it will be truncated. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#CURRENT_SCHEMA"><code>CURRENT\_SCHEMA</code></a>: Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. </li>
                  </ul>

                  The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">Returns:</div>
                  <div className="dd">The current value of <code>options</code>.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="setOptions(java.util.Map)">
                <h3>setOptions</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest" title="class in com.gpudb.protocol">ExecuteSqlRequest</a></span> <span className="element-name">setOptions</span><wbr /><span className="parameters">(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<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>,<wbr /><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>> options)</span></div>

                <div className="block">
                  Optional parameters.

                  <ul>
                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#COST_BASED_OPTIMIZATION"><code>COST\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the cost-based optimization of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_JOINS"><code>DISTRIBUTED\_JOINS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed joins in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#DISTRIBUTED_OPERATIONS"><code>DISTRIBUTED\_OPERATIONS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, enables the use of distributed operations in servicing the given query. Any query requiring a distributed join will succeed, though hints can be used in the query to change the distribution of the source data to allow the query to succeed. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#IGNORE_EXISTING_PK"><code>IGNORE\_EXISTING\_PK</code></a>: Specifies the record collision error-suppression policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>, only used when primary key record collisions are rejected (<a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>). If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any record insert/update that is rejected for resulting in a primary key collision with an existing table record will be ignored with no error generated. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, the rejection of any insert/update for resulting in a primary key collision will cause an error to be reported. If the specified table does not have a primary key or if <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then this option has no effect. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Ignore inserts/updates that result in primary key collisions with existing records. </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Treat as errors any inserts/updates that result in primary key collisions with existing records. </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#LATE_MATERIALIZATION"><code>LATE\_MATERIALIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, Joins/Filters results will always be materialized ( saved to result tables format). Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE"><code>PAGING\_TABLE</code></a>: When specified (or <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a> is set), the system will create a paging table to hold the results of the query, when the output has more records than are in the response (i.e., when <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getHasMoreRecords()"><code>hasMoreRecords</code></a> is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.HasMoreRecords#TRUE"><code>TRUE</code></a>). If the specified paging table exists, the records from the paging table are returned without re-evaluating the query. It is the caller's responsibility to clear the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) when they are done with this query. </li>
                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PAGING_TABLE_TTL"><code>PAGING\_TABLE\_TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the paging table. -1 indicates no timeout. Setting this option will cause a paging table to be generated when needed. The <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse#getPagingTable()"><code>pagingTable</code></a> and other tables in the <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlResponse.Info#RESULT_TABLE_LIST"><code>RESULT\_TABLE\_LIST</code></a> (both returned in the response) will be automatically cleared after the TTL expires, if set to a positive number. However, it is still recommended that the caller clear these tables when they are done with this query. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PARALLEL_EXECUTION"><code>PARALLEL\_EXECUTION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables the parallel step execution of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PLAN_CACHE"><code>PLAN\_CACHE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables plan caching for the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PREPARE_MODE"><code>PREPARE\_MODE</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, compiles a query into an execution plan and saves it in query cache. Query execution is not performed and an empty response will be returned to user. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#PRESERVE_DICT_ENCODING"><code>PRESERVE\_DICT\_ENCODING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then columns that were dict encoded in the source table will be dict encoded in the projection table. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#QUERY_PARAMETERS"><code>QUERY\_PARAMETERS</code></a>: Query parameters in JSON array or arrays (for inserting multiple rows). This can be used instead of <a href="#getData()"><code>data</code></a> and <a href="#getRequestSchemaStr()"><code>requestSchemaStr</code></a>. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RESULTS_CACHING"><code>RESULTS\_CACHING</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables caching of the results of the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#RULE_BASED_OPTIMIZATION"><code>RULE\_BASED\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, disables rule-based rewrite optimizations for the given query. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#SSQ_OPTIMIZATION"><code>SSQ\_OPTIMIZATION</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, scalar subqueries will be translated into joins. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TTL"><code>TTL</code></a>: Sets the <a href="/content/concepts/ttl/" target="_top">TTL</a> of the intermediate result tables used in query execution. </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#UPDATE_ON_EXISTING_PK"><code>UPDATE\_ON\_EXISTING\_PK</code></a>: Specifies the record collision policy for inserting into or updating a table with a <a href="/content/concepts/tables/#primary-keys" target="_top">primary key</a>. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, any existing table record with primary key values that match those of a record being inserted or updated will be replaced by that record. If set to <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, any such primary key collision will result in the insert/update being rejected and the error handled as determined by <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#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="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>: Replace the collided-into record with the record inserted or updated when a new/modified record causes a primary key collision with an existing record. </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>: Reject the insert or update when it results in a primary key collision with an existing record. </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>.
                    </li>

                    <li>
                      <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#VALIDATE_CHANGE_COLUMN"><code>VALIDATE\_CHANGE\_COLUMN</code></a>: When changing a column using alter table, validate the change before applying it. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>, then validate all values. A value too large (or too long) for the new type will prevent any change. If <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a>, then when a value is too large or long, it will be truncated. Supported values:

                      <ul>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a> </li>
                        <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#FALSE"><code>FALSE</code></a> </li>
                      </ul>

                      The default value is <a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#TRUE"><code>TRUE</code></a>.
                    </li>

                    <li><a href="/content/api/java/com/gpudb/protocol/ExecuteSqlRequest.Options#CURRENT_SCHEMA"><code>CURRENT\_SCHEMA</code></a>: Use the supplied value as the <a href="/content/concepts/schemas/#default-schema" target="_top">default schema</a> when processing this SQL command. </li>
                  </ul>

                  The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.
                </div>

                <div className="dl notes">
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>options</code> - The new value for <code>options</code>.</div>
                  <div className="dt">Returns:</div>
                  <div className="dd"><code>this</code> to mimic the builder pattern.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="getSchema()">
                <h3>getSchema</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">org.apache.avro.Schema</span> <span className="element-name">getSchema</span>()</div>
                <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>

                <div className="dl notes">
                  <div className="dt">Specified by:</div>
                  <div className="dd"><code>getSchema</code> in interface <code>org.apache.avro.generic.GenericContainer</code></div>
                  <div className="dt">Returns:</div>
                  <div className="dd">The schema object describing this class.</div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="get(int)">
                <h3>get</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><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> <span className="element-name">get</span><wbr /><span className="parameters">(int index)</span></div>
                <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>

                <div className="dl notes">
                  <div className="dt">Specified by:</div>
                  <div className="dd"><code>get</code> in interface <code>org.apache.avro.generic.IndexedRecord</code></div>
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>index</code> - the position of the field to get</div>
                  <div className="dt">Returns:</div>
                  <div className="dd">value of the field with the given index.</div>
                  <div className="dt">Throws:</div>
                  <div className="dd"><code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/IndexOutOfBoundsException.html" title="class or interface in java.lang" className="external-link">IndexOutOfBoundsException</a></code></div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="put(int,java.lang.Object)">
                <h3>put</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">void</span> <span className="element-name">put</span><wbr /><span className="parameters">(int index, <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> value)</span></div>
                <div className="block">This method supports the Avro framework and is not intended to be called directly by the user.</div>

                <div className="dl notes">
                  <div className="dt">Specified by:</div>
                  <div className="dd"><code>put</code> in interface <code>org.apache.avro.generic.IndexedRecord</code></div>
                  <div className="dt">Parameters:</div>
                  <div className="dd"><code>index</code> - the position of the field to set</div>
                  <div className="dd"><code>value</code> - the value to set</div>
                  <div className="dt">Throws:</div>
                  <div className="dd"><code><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/IndexOutOfBoundsException.html" title="class or interface in java.lang" className="external-link">IndexOutOfBoundsException</a></code></div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="equals(java.lang.Object)">
                <h3>equals</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">boolean</span> <span className="element-name">equals</span><wbr /><span className="parameters">(<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> obj)</span></div>

                <div className="dl notes">
                  <div className="dt">Overrides:</div>
                  <div className="dd"><code><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></code> in class <code><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></code></div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="toString()">
                <h3>toString</h3>
                <div className="member-signature"><span className="modifiers">public</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">toString</span>()</div>

                <div className="dl notes">
                  <div className="dt">Overrides:</div>
                  <div className="dd"><code><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></code> in class <code><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></code></div>
                </div>
              </div>
            </li>

            <li>
              <div className="section detail" id="hashCode()">
                <h3>hashCode</h3>
                <div className="member-signature"><span className="modifiers">public</span> <span className="return-type">int</span> <span className="element-name">hashCode</span>()</div>

                <div className="dl notes">
                  <div className="dt">Overrides:</div>
                  <div className="dd"><code><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></code> in class <code><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></code></div>
                </div>
              </div>
            </li>
          </ul>
        </div>
      </li>
    </ul>
  </div>
</div>