Get the distinct count for a column
get/servers/{serverName}/caslibs/{caslibName}/tables/{tableName}/columns/{columnName}/distinctCount
Returns the distinct and missing counts for a single column in the loaded CAS table
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}
Name | Type | Required | Description |
---|---|---|---|
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. |
Status | Meaning | Description | ||
---|---|---|---|---|
200 | OK | The requested table's distinct and missing count information for a given column was returned. | Schema | |
404 | Not Found | The requested CAS server or Caslib does not exist. | ||
409 | Conflict | The request could not be completed due to a conflict with the current state of the resource. Details are included in the response body. |