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

# aggregateUniqueRaw

<div className="kinetica-javadoc">
  <ul className="member-list">
    <li>
      <div className="section detail" id="aggregateUniqueRaw(com.gpudb.protocol.AggregateUniqueRequest)">
        <h3>aggregateUniqueRaw</h3>
        <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/RawAggregateUniqueResponse" title="class in com.gpudb.protocol">RawAggregateUniqueResponse</a></span> <span className="element-name">aggregateUniqueRaw</span><wbr /><span className="parameters">(<a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest" title="class in com.gpudb.protocol">AggregateUniqueRequest</a> request)</span> throws <span className="exceptions"><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></span></div>

        <div className="block">
          Returns all the unique values from a particular column (specified by <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a>) of a particular table or view (specified by <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getTableName()"><code>tableName</code></a>). If <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a> is a numeric column, the values will be in <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueResponse#getData()"><code>data</code></a>. Otherwise if <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a> is a string column, the values will be in <code> jsonEncodedResponse</code>. The results can be paged via <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getOffset()"><code>offset</code></a> and <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getLimit()"><code>limit</code></a> parameters.

          <p />

          <p> {"{"}"limit":"10","sort\_order":"descending"{"}"} </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>
          <p> If a <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest.Options#RESULT_TABLE"><code>RESULT\_TABLE</code></a> name is specified in the <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getOptions()"><code>options</code></a>, the results are stored in a new table with that name--no results are returned in the response. Both the table name and resulting column name must adhere to <a href="/content/concepts/tables/#table" target="_top">standard naming conventions</a>; any column expression will need to be aliased. If the source table's <a href="/content/concepts/tables/#shard-keys" target="_top">shard key</a> is used as the <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a>, the result table will be sharded, in all other cases it will be replicated. Sorting will properly function only if the result table is replicated or if there is only one processing node and should not be relied upon in other cases. Not available if the value of <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest#getColumnName()"><code>columnName</code></a> is an unrestricted-length string.</p>
        </div>

        <div className="dl notes">
          <div className="dt">Parameters:</div>
          <div className="dd"><code>request</code> - <a href="/content/api/java/com/gpudb/protocol/AggregateUniqueRequest" title="class in com.gpudb.protocol"><code>Request</code></a> object containing the parameters for the operation.</div>
          <div className="dt">Returns:</div>
          <div className="dd"><a href="/content/api/java/com/gpudb/protocol/RawAggregateUniqueResponse" title="class in com.gpudb.protocol"><code>Response</code></a> object containing the results of the operation.</div>
          <div className="dt">Throws:</div>
          <div className="dd"><code><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></code> - if an error occurs during the operation.</div>
        </div>
      </div>
    </li>
  </ul>
</div>