Get the distinct count for a column

get/servers/{serverName}/caslibs/{caslibName}/tables/{tableName}/columns/{columnName}/distinctCount
Internal-Use Only

Returns the distinct and missing counts for a single column in the loaded CAS table

Request Samples

1

Response Samples

1{
2 "version": 1,
3 "columnName": "2016/17",
4 "distinctCount": 30,
5 "missingCount": 0,
6 "truncated": false,
7 "links": [
8 {
9 "method": "GET",
10 "rel": "up",
11 "href": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17",
12 "uri": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17",
13 "type": "application/vnd.sas.cas.column"
14 },
15 {
16 "method": "GET",
17 "rel": "self",
18 "href": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17/distinctCount",
19 "uri": "/casManagement/servers/cas-shared-default/caslibs/testlib/tables/NBA_2016_TEAMSALARIES/columns/2016/17/distinctCount",
20 "type": "application/vnd.sas.cas.column.distinct.count"
21 }
22 ]
23}

Path Parameters

NameTypeRequiredDescription
caslibName
string
true

The name of the Caslib containing the table.

columnName
string
true

The name of column for which distance and missing info is requested.

serverName
string
true

The name of the server containing the Caslib.

tableName
string
true

The name of table for which column info is requested.

Query Parameters

NameTypeRequiredDescription
sessionId
string
false

The optional ID of the session containing the Caslib. If unspecified, only tables in global caslibs will be accessible.

Responses

StatusMeaningDescription
200OKThe requested table's distinct and missing count information for a given column was returned.Schema
404Not FoundThe requested CAS server or Caslib does not exist.
409ConflictThe request could not be completed due to a conflict with the current state of the resource. Details are included in the response body.