Page History

...

• sql - required. string. The text of sql statement.
• offset - optional. int. Query offset. If offset is set in sql, curIndex will be ignored.
• limit - optional. int. Query limit. If limit is set in sql, perPage will be ignored.
• acceptPartial - optional. bool. Whether accept a partial result or not, default be “false”. Set to “false” for production use.
• project - optional. string. Project to perform query. Default value is ‘DEFAULT’.

Request Sample

...

{
  "sql":"select count(*) from kylin_sales",

...

  "offset":0,

...

  "limit":50000,

...

  "acceptPartial":false,

...

  "project": "learn_kylin"

...

}

...

Curl Example

curl -X POST -H "Authorization: Basic XXXXXXXXX" -H "Content-Type: application/json" 
-d '{ "sql":"select count(*) from kylin_sales", "project":"learn_kylin" }' http://localhost:7070/kylin/api/query

...