kineticadb/kinetica-api-javascript

[REST API] order_by does not work

Closed this issue · 1 comments

Using the endpoint /get/records/bycolumn I am unable to use the order_by option. My request looks like this:

{
  "table_name":"my_program_table",
  "offset":50,
  "limit":50,
  "encoding":"json",
  "column_names":[
  "listing_id",
    "listing_starttime",
    "listing_endtime",
    "program_title"
 ],
  "options":{
     "order_by": "listing_starttime asc"
  }
}

Here is the error I receive

400 BAD REQUEST

{
	"status": "ERROR",
	"message": "Error sinking: Unsupported initResponseArray data type:invalid_data_type (TM\/TOMc:9586); code:1 'Error' (S\/Sc:57); code:1 'Error' (S\/Sc:57); code:1 'Error' (HS\/TWGSc:165); code:1 'Error'",
	"data_type": "none",
	"data": "",
	"data_str": ""
}

The issue has been fixed in 6.1-beta.