Batch Update (For Standalone Hippo Service Only)

This chapter introduces how to update data in batch mode in Hippo for Standalone mode only. With batch update, users can perform update operations on target data per specified filter conditions synchronously or asynchronously.

curl -u shiva:shiva -XPOST 'localhost:8902/hippo/v1/_standalone_update_by_query?pretty' -H 'Content-Type: application/json' -d'{
  "database_name" : "default",
  "table_name" : "table",
  "fields": [
    {
      "field_name": "word_count",
      "field_value" : "0"
    }
  ],
  "expr" : "word_count > 9000",
  "wait_for_completion" : true,
  "timeout" : "2m"
}';

Result:

{
  "job_type" : "update_by_query",
  "table" : "default#table",
  "success_number" : 91
}

Parameter description:

ParametersDescriptionRequired
database_nameDatabase where the destination table is locatedNo, defaults to "default" database
table_nameDestination table nameYes
exprFilter conditionNo, defaults to full table scan
fieldsField to be updatedYes
field_name (fields)Name of field to be updatedYes
field_value (fields)Value of field to be updatedNo, null if the cell is blank
wait_for_completionWhether to wait until the job is doneNo, defaults to true
timeoutOperation timeoutNo, defaults to 5 mins

Table 29 Batch Update -- Standalone Mode (Restful API)