elasticsearch-sql

elasticsearch-sql copied to clipboard

constant_score 和filter支持吗

1

Cenck

请教下如何使用script

1

看feature中有支持script，有具体的使用说明吗？

jackllvv

排序项设置默认sortMode=avg时，造成非number类型排序字段，查询报错

1

7.9.3 io/github/iamazy/elasticsearch/dsl/sql/parser/QueryOrderByParser.java:36 不应该指定默认sortMode为avg, es sortMode=avg时仅支持number字段，但排序字段 可以是string和date.

Cenck

重新拿插件报后，再次测试的 elasticsearch-7.9.2 是集群并带有密码 使用 elasticsearch-sql-jdbc-7.9.2 连接时有问题

1

elasticsearch-7.9.2 是集群并带有密码 使用 elasticsearch-sql-jdbc-7.9.2 连接时有问题 es是集群，并带有密码 elasticsearch.yml中 xpack.security.enabled: true xpack.security.transport.ssl.enabled: true xpack.security.transport.ssl.verification_mode: certificate xpack.security.transport.ssl.keystore.path: certs/elastic-certificates.p12 xpack.security.transport.ssl.truststore.path: certs/elastic-certificates.p12 elasticsearch版本为7.9.2 elasticsearch-sql插件版本为 elasticsearch-sql-plugin.zip(7.9.2) jdbc版本为： elasticsearch-sql-core-7.9.2.jar、elasticsearch-sql-jdbc-7.9.2.jar 使用样例中conn1()方式 多个地址： private String ES_DB_URL = "jdbc:es://192.168.182.229:9350,192.168.182.230:9350,192.168.182.231:9350/alarm-20211117?useSSL=true&mode=cluster"; 报如下错；...

suixindong

es安装插件后报Cannot replace existing handler for [/_isql/_explain]错误

2

es7.9.2 安装插件 ./bin/elasticsearch-plugin install https://github.com/iamazy/elasticsearch-sql/releases/download/7.9.2/elasticsearch-sql-plugin-v7.9.2.zip 再 plugins目录会生成一个isql文件夹，但是启动时如下报错： [2021-11-26T14:35:11,490][ERROR][o.e.b.Bootstrap ] [elasticsearch-230-t] Exception java.lang.IllegalArgumentException: Cannot replace existing handler for [/_isql/_explain] for method: POST at org.elasticsearch.rest.MethodHandlers.addMethods(MethodHandlers.java:52) ~[elasticsearch-7.9.2.jar:7.9.2]

suixindong

es 7.15.0 使用 isql 7.14.0 有密码时无法连接

5

elasticsearch.yml中 `xpack.security.enabled: true xpack.license.self_generated.type: basic xpack.security.transport.ssl.enabled: true` 使用样例中conn1()，控制台显示 ElasticsearchStatusException[Elasticsearch exception [type=security_exception, reason=missing authentication credentials for REST request [/test/_search?typed_keys=true&max_concurrent_shard_requests=5&ignore_unavailable=false&expand_wildcards=open&allow_no_indices=true&ignore_throttled=true&search_type=query_then_fetch&batched_reduce_size=512]]]21:07:24.331 [main] DEBUG org.apache.http.impl.nio.conn.PoolingNHttpClientConnectionManager - Connection manager is shutting down

miws

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

6

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

otary

啥时候支持下count函数

1


FATCatk

es 深度查询如何支撑，有qq交流群吗

1

Zengweilu

Bumps [jackson-databind](https://github.com/FasterXML/jackson) from 2.13.1 to 2.13.2.1. Commits See full diff in compare view [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter...

dependabot[bot]