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

希望后续能支持UPDATE、DELETE等sql,最好建表SQL也能支持

Open otary opened this issue 4 years ago • 6 comments

如题,希望后续能支持UPDATE、DELETE等sql,最好建表SQL也能支持

otary avatar Jul 06 '21 01:07 otary

如题,希望后续能支持UPDATE、DELETE等sql,最好建表SQL也能支持

Update, Delete 都有,create 目前没有,有时间我加下。

@otary,如果你愿意,欢迎提pr

iamazy avatar Jul 09 '21 11:07 iamazy

试了下,UPDATE语句解析报错:[syntax error] indices name must be set

otary avatar Jul 11 '21 03:07 otary

试了下,UPDATE语句解析报错:[syntax error] indices name must be set

发下语句

iamazy avatar Jul 11 '21 08:07 iamazy

UPDATE users set age = 10 where id =1 

实际上,任何UPDATE语句都会报错~!

otary avatar Jul 13 '21 00:07 otary

UPDATE users set age = 10 where id =1

@otary 你是这么获取的吗?parseResult.getUpdateByQueryRequest()

iamazy avatar Jul 16 '21 14:07 iamazy

ElasticSql2DslParser elasticSql2DslParser = new ElasticSql2DslParser(); ElasticSqlParseResult result = elasticSql2DslParser.parse("UPDATE users set age = 10 where id =1");

result.getUpdateByQueryRequest(); // 返回内容update-by-query [users] updated with Script{type=inline, lang='painless', idOrCode='ctx._source.age=10;', options={}, params={}} result.getSearchRequest(); // 报错:[syntax error] indices name must be set

我想获取update的dsl,不知道要怎么获取呢?求指教

otary avatar Oct 06 '21 05:10 otary