View Code? Open in Web Editor
NEW
基于Java Rest High Level Client的Elasticsearch-Sql组件【stalled】
elasticsearch-sql2's Introduction
🌱 I’m currently learning database (need help).
📚 I'm reading database internal & ddia
🥝 I'm doing the labs of 6.830/6.814
🐼 I'm also learning c/c++ for the labs of cmu-15445
🍉 I want to build my own object storage named helyim written by rust
🏸 I'm an amateur badminton player
☕️ Feel free to reach me to talk about anything.
elasticsearch-sql2's People
elasticsearch-sql2's Issues
String sql="select * from novel";
ElasticSql2DslParser elasticSql2DslParser=new ElasticSql2DslParser();
ElasticSqlParseResult elasticSqlParseResult = elasticSql2DslParser.parse(sql);
String sqldsl = elasticSqlParseResult.toPrettyDsl(elasticSqlParseResult.toRequest());
// WrapperQueryBuilder wrapperQueryBuilder = QueryBuilders.wrapperQuery("{\"term\": {\"words\":\"2355421\"}}");
WrapperQueryBuilder wrapperQueryBuilder = QueryBuilders.wrapperQuery(sqldsl);
// 设置查询字段
SearchResponse response = elasticsearchTemplate.getClient().prepareSearch()
.setQuery(wrapperQueryBuilder)
.setFrom((pageNo-1) * pageSize)
.setSize(pageNo * pageSize) // 设置一次返回的文档数量,最大值:10000
.get();
这是我的测试,不过会报错org.elasticsearch.common.ParsingException: [from] query malformed, no start_object after query name
可以帮忙解决一下吗
kibana 执行
POST /_isql
{
"sql": "select ecs.version from filebeat-service-2019-06-01 "
}
会报错
{
"error": "[syntax error] From table should like [index].[type]"
}
官方提供的带下划线的索引是前后加上"就可以正常使用了,这个需要怎么处理下
插件安装失败
都不知道支持
和不支持
哪些功能,用es不可能只是简单的select * from xxx
吧。