Count

Users can get the number of current data records via COUNT API. If an expression is specified, the number of rows that matches the certain filter condition will be returned.

curl -u shiva:shiva -XGET 'localhost:8902/hippo/v1/{table}/_count?database_name={database_name}&pretty'
curl -u shiva:shiva -XGET 'localhost:8902/hippo/v1/{table}/_count?database_name={database_name}&pretty' -
H 'Content-Type: application/json' -d'{
  "expr" : "word_count >= 11000"
}';

Result:

{
  "total" : 100
}

Parameter description:

ParametersDescriptionRequired
exprFilter conditionNo, defaults to all table records
database_nameDatabase where the table is locatedNo, defaults to "default" database
Table 38 Count (Restful API)