sql icon indicating copy to clipboard operation
sql copied to clipboard

An error occurs when executing the PPL query.

Open GamjaPower opened this issue 4 years ago • 4 comments

query { "query": "source=heartbeat* " }

result { "error": { "reason": "There was internal problem at backend", "details": "Unsupported type: UNKNOWN for field: monitor.timespan, value: {"gte":"2021-01-08T23:28:43.280Z","lt":"2021-01-08T23:28:53.280Z"}.", "type": "IllegalStateException" }, "status": 503 }

GamjaPower avatar Jan 09 '21 11:01 GamjaPower

Hi @GamjaPower Thanks for reporting the issue! Could you share your index and our PPL plugin version?

dai-chen avatar Jan 11 '21 23:01 dai-chen

Looks like the data type indicated in the error message is range type, but it is not supported in the core engine yet.

chloe-zh avatar Jan 12 '21 05:01 chloe-zh

Hi @chloe-zh Yes, I understand. So when will the core engine support it?

@dai-chen PPL plugin version : opendistro_sql 1.12.0.0 index document { "@timestamp": "2021-01-05T13:12:00", "message": "GET /search HTTP/1.1 200 1070000", "user": { "id": "gamjapower" } }

GamjaPower avatar Jan 12 '21 05:01 GamjaPower

@chloe-zh I am very interested in the PPL project. I have experience with both Elasticsearch and Splunk products. So when the PPL project stabilizes, I predict that Opendistro will be used in key industry areas. So I hope this project goes well.

GamjaPower avatar Jan 12 '21 05:01 GamjaPower