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

# getRecordsByColumnRaw

<div className="kinetica-doxygen">
  <div id="ab27ed9c87017701489bd2e2d8d9bdbc7" />

  <h2 className="memtitle"><span className="permalink"><a href="#ab27ed9c87017701489bd2e2d8d9bdbc7">◆ </a></span>getRecordsByColumnRaw() <span className="overload">\[1/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">RawGetRecordsByColumnResponse</a> gpudb::GPUdb::getRecordsByColumnRaw </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest">GetRecordsByColumnRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
          <td>)</td>
          <td> const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>For a given table, retrieves the values from the requested column(s). </p>
      <p>Maps of column name to the array of values as well as the column data type are returned. This endpoint supports pagination with the <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a18191415826f865ec4f6a0d6dc6855ed">offset</a> and <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a036170d92eb383fc6d7870158671089d">limit</a> parameters.</p>
      <p><a href="/content/concepts/window/" target="_top">Window functions</a>, which can perform operations like moving averages, are available through this endpoint as well as <a className="el" href="#aab22a8ee1b42ec6fa1acfc3b2f70cf4c">createProjection</a>.</p>
      <p>When using pagination, if the table (or the underlying table in the case of a view) is modified (records are inserted, updated, or deleted) during a call to the endpoint, the records or values retrieved may differ between calls based on the type of the update, e.g., the contiguity across pages cannot be relied upon.</p>
      <p>If <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a263821675907f32ae8da306a46c885f5">tableName</a> is empty, selection is performed against a single-row virtual table. This can be useful in executing temporal (<a href="/content/concepts/expressions/#date-time-functions" target="_top">NOW()</a>), identity (<a href="/content/concepts/expressions/#user-security-functions" target="_top">USER()</a>), or constant-based functions (<a href="/content/concepts/expressions/#scalar-functions" target="_top">GEODIST(-77.11, 38.88, -71.06, 42.36)</a>).</p>
      <p>The response is returned as a dynamic schema. For details see: <a href="/content/api/concepts/#dynamic-schemas" target="_top">dynamic schemas documentation</a>.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest">Request</a> object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">Response</a> object containing the result of the operation. </div>
      </div>
    </div>
  </div>

  <div id="ad3f6fcdabf549c813352cae5e37112ca" />

  <h2 className="memtitle"><span className="permalink"><a href="#ad3f6fcdabf549c813352cae5e37112ca">◆ </a></span>getRecordsByColumnRaw() <span className="overload">\[2/2]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">RawGetRecordsByColumnResponse</a> & gpudb::GPUdb::getRecordsByColumnRaw </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest">GetRecordsByColumnRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
        </tr>

        <tr>
          <td className="paramkey" />

          <td />

          <td className="paramtype"><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">RawGetRecordsByColumnResponse</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">response\_</span></span> ) const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>For a given table, retrieves the values from the requested column(s). </p>
      <p>Maps of column name to the array of values as well as the column data type are returned. This endpoint supports pagination with the <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a18191415826f865ec4f6a0d6dc6855ed">offset</a> and <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a036170d92eb383fc6d7870158671089d">limit</a> parameters.</p>
      <p><a href="/content/concepts/window/" target="_top">Window functions</a>, which can perform operations like moving averages, are available through this endpoint as well as <a className="el" href="#aab22a8ee1b42ec6fa1acfc3b2f70cf4c">createProjection</a>.</p>
      <p>When using pagination, if the table (or the underlying table in the case of a view) is modified (records are inserted, updated, or deleted) during a call to the endpoint, the records or values retrieved may differ between calls based on the type of the update, e.g., the contiguity across pages cannot be relied upon.</p>
      <p>If <a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest#a263821675907f32ae8da306a46c885f5">tableName</a> is empty, selection is performed against a single-row virtual table. This can be useful in executing temporal (<a href="/content/concepts/expressions/#date-time-functions" target="_top">NOW()</a>), identity (<a href="/content/concepts/expressions/#user-security-functions" target="_top">USER()</a>), or constant-based functions (<a href="/content/concepts/expressions/#scalar-functions" target="_top">GEODIST(-77.11, 38.88, -71.06, 42.36)</a>).</p>
      <p>The response is returned as a dynamic schema. For details see: <a href="/content/api/concepts/#dynamic-schemas" target="_top">dynamic schemas documentation</a>.</p>

      <div className="dl params">
        <div className="dt">Parameters</div>

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1GetRecordsByColumnRequest">Request</a> object containing the parameters for the operation. </td>
            </tr>

            <tr>
              <td className="paramdir">\[out]</td>
              <td className="paramname">response\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">Response</a> object containing the results of the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1RawGetRecordsByColumnResponse">Response</a> object containing the result of the operation (initially passed in by reference). </div>
      </div>
    </div>
  </div>
</div>