suixindong

重新拿插件报后，再次测试的 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"; 报如下错；...

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]

日期范围查询sql怎么写

3

select alarmId,alarmTitle,eventTime t_alarm where eventTime>=to_date('2022-01-01 10:00:00','yyyy-MM-dd hh24:mi:ss')and eventTime

elasticsearch-7.9.2 是集群并带有密码 使用 elasticsearch-sql-7.9.2.0.jar 连接时有问题- org.elasticsearch.index.mapper.MappedFieldType: method <init>()V not found

2

elasticsearch-7.9.2 是集群并带有密码 使用 elasticsearch-sql-7.9.2.0.jar 连接时有问题 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-7.9.2.0.jar 使用依赖： org.elasticsearch.client x-pack-transport 7.9.2 参照jdbc方式写的创建链接 Properties properties = new Properties();...