Batch Export

Hippo standalone version supports performing batch export to CSV files.

curl -u shiva:shiva -XPOST 'localhost:8902/hippo/v1/_standalone_export_data?pretty' -H 'Content-Type: application/json' -d'{
  "database_name": "default",
  "table_name" : "book",
  "file" : "/tmp/book-1.csv",
  "csv_options" : {
    "with_header" : true
  "output_fields": ["book_id", "book_intro"],
  "expr" : "word_count >= 11000",
  "limit" : 1000,
  "wait_for_completion" : true


  "job_type" : "export_data",
  "table" : "default#book",
  "file_path" : "/tmp/book-1.csv",
  "expr" : "word_count >= 11000",
  "limit" : 1000,
  "output_fields" : [
  "count" : 90

Parameter description:

database_nameDatabase nameNo, defaults to "default" database
table_nameTable nameYes
filesLocal file pathYes
csv_optionsCSV related parametersNo
array_separator (csv_options)Array separatorNo, defaults to ","
separator (csv_options)Separator to parse CSV fileNo, defaults to ";"
with_headerIf output CSV file contains headerNo, defaults to false
exprFilter condition to export dataNo, defaults to empty
limitMax volume of data to be exportedNo, defaults to all data
wait_for_completionWhether to wait until the job is doneNo, defaults to true; if set to false, job ID will be returned
Table 24 Batch Export (Restful API)