elasticsearch-sql icon indicating copy to clipboard operation
elasticsearch-sql copied to clipboard

高版本的sql插件能向低版本的es兼容吗

Open JohnZp opened this issue 5 years ago • 1 comments

我目前使用的是5.6.8版本的,使用case wen语句会报如下错误, 请问有办法规避这个错误吗?或者只能升级es版本,并升级对应插件版本?

select case when v.keyword like '%1%' then 'test1' when v.keyword like '%2%' then 'test2' when v.keyword like '%3%' then 'test3' when v.keyword like '%3%' then 'test4' else 'pass' end as tmp from test_index

{ "error": { "root_cause": [ { "type": "null_pointer_exception", "reason": null } ], "type": "null_pointer_exception", "reason": null }, "status": 500 }

JohnZp avatar Sep 02 '19 10:09 JohnZp

可以试试用高版本的插件做explain,取得dsl后再做request

shi-yuan avatar Sep 08 '19 13:09 shi-yuan