Comments (3)
elasticsearch官方提供的fetch_size机制类似于elasticsearch的scroll查询,不支持从指定的地方开始翻页的功能,官方的文档可以去看看:
https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-rest-format.html
https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-pagination.html
可以试试第三方提供的Elasticsearch-Sql插件,可以支持指定的地方开始翻页,参考文档:
https://esdoc.bbossgroups.com/#/Elasticsearch-SQL-ORM?id=%e7%ae%80%e5%8d%95%e6%a1%88%e4%be%8b
from bboss-elasticsearch.
elasticsearch官方提供的fetch_size机制类似于elasticsearch的scroll查询,不支持从指定的地方开始翻页的功能,官方的文档可以去看看:
https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-rest-format.html
https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-pagination.html可以试试第三方提供的Elasticsearch-Sql插件,可以支持指定的地方开始翻页,参考文档:
https://esdoc.bbossgroups.com/#/Elasticsearch-SQL-ORM?id=%e7%ae%80%e5%8d%95%e6%a1%88%e4%be%8b
第三方提供的Elasticsearch-Sql插件在ES7.3.2版本,如果配置了x-pack好像会报错。。。。我还是直接用DSL查询分页吧,谢谢了!
from bboss-elasticsearch.
是的,sql也是转换为dsl执行,直接用dsl即可,下面的文档都可以参考:
https://esdoc.bbossgroups.com/#/from-size
https://esdoc.bbossgroups.com/#/Scroll-SliceScroll-api
https://esdoc.bbossgroups.com/#/search-after
from bboss-elasticsearch.
Related Issues (20)
- ES迁移数据量不对 HOT 6
- 考虑下dsl语法高亮支持 HOT 1
- ElasticSearchHelper.getRestClientUtil报错 HOT 1
- 关于All elasticServer [http://es-busi:9200] can't been connected HOT 1
- 【反馈】 HOT 1
- 实体类字段是LocalDateTime或者Date,使用dsl查询返回为null HOT 1
- 编译源码出错,无法下载依赖 HOT 1
- 6.3.0版本 能添加返回es查询语句的功能吗 HOT 11
- 分词带空格会报错 HOT 1
- 你好,请问支持分表的动态同步数据么?可以在conf中设置当前的月份对应的表 HOT 1
- 动态dsl多级循环遍历出错 HOT 1
- 请教大佬,请问支持添加自定义拦截器吗,我想根环境变量添加影子索引
- Connection pool shut down HOT 2
- serialJson=true疑问 HOT 1
- Amazon OpenSearch HOT 6
- 查询结果不支持从stored_fields取数? HOT 3
- 批量操作返回值数据问题 HOT 2
- 如何禁止一个字段不索引 HOT 1
- bboss-elasticsearch-rest-jdbc:6.3.0 错误 HOT 3
- 偶发请求失败 failed to respond HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bboss-elasticsearch.