Issues with openobserve(v0.5.0) API Response Code

Shashank

Hi Team, I using openobserve(v0.5.0). I am getting this response code when I am trying to filter metric data under stream based on time. ```Request URL: Request Method: POST Status Code: 400``` Response: ```{ "code": 400, "message": "invalid type: map, expected a string at line 1 column 16" }``` Payload: ```{"query":{"sql":{"changes":[{"range":{"startLineNumber":1,"startColumn":1,"endLineNumber":1,"endColumn":1},"rangeOffset":0,"rangeLength":0,"text":"SELECT * FROM \"apiserver_longrunning_requests\""}],"eol":"\r\n","versionId":2,"isUndoing":false,"isRedoing":false,"isFlush":true},"start_time":1691660627545000,"end_time":1691661527545000,"from":0,"size":150,"sql_mode":"full"}}``` Can someone pls help me on this !!

Hengfei

Hengfei

your query looks like is not correct.

Hengfei

we don't support `sql:changes`

Hengfei

and can you try v0.5.1?

Shashank

Yah but this what UI is sending.

Shashank

I got the details by inspecting my browser.

Hengfei

Yep, maybe it is a bug of 0.5.0. can you try 0.5.1?

Shashank

Can you pls help me with the MR which fixed this :pray:

Shashank

Currently we can not perform upgrade.

Hengfei

ah, i never got this error before. so i am not sure which pr fixed this problem.

Hengfei

and which page you got this error?

Hengfei

i tested v0.5.0 metrics, there is no this error.

Hengfei

and i suggest upgrade to 0.5.1, The old version doesn't provide great support for metrics

Hengfei

and 0.5.1 has no break changes to 0.5.0

Shashank

Atleast can you pls point me to file where payload constructions happens ?

Shashank

This API call gets triggered by UI when I hit run query under streams.

Shashank

cc: Prabhat

Prabhat

am not sure how you got this query: ```{ "query": { "sql": { "changes": [ { "range": { "startLineNumber": 1, "startColumn": 1, "endLineNumber": 1, "endColumn": 1 }, "rangeOffset": 0, "rangeLength": 0, "text": "SELECT * FROM \"apiserver_longrunning_requests\"" } ], "eol": "\r\n", "versionId": 2, "isUndoing": false, "isRedoing": false, "isFlush": true }, "start_time": 1691660627545000, "end_time": 1691661527545000, "from": 0, "size": 150, "sql_mode": "full" } }```

Prabhat

A typical query from stream page looks like: ```{ "query": { "sql": "SELECT * FROM \"apiserver_request_filter_duration_seconds_sum\"", "start_time": 1691786328940000, "end_time": 1691787228940000, "from": 0, "size": 150, "sql_mode": "full" } }```

Prabhat

or ```{ "query": { "sql": "SELECT * FROM \"apiserver_request_filter_duration_seconds_sum\" where filter='authorization'", "start_time": 1691786328940000, "end_time": 1691787228940000, "from": 0, "size": 150, "sql_mode": "full" } }```

Prabhat

can you share your query...