levisLi issues

Repositories
Issues
Comments

Results 2 issues of


                                            levisLi

elasticsearch-7.10.2集群配置x-pack认证后无法执行es-sql查询

Properties properties = new Properties(); properties.put("url", "jdbc:elasticsearch://cqprod03:9300"); properties.put(PROP_CONNECTIONPROPERTIES, "client.transport.ignore_cluster_name=true;xpack.security.user=elastic:admin@123"); DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory.createDataSource(properties); Connection connection = dds.getConnection(); PreparedStatement ps = connection.prepareStatement("SELECT * from test"); ResultSet resultSet = ps.executeQuery(); 报如下错误：...

es-sql带别名过滤条件不支持

SQL1: SELECT s.exposure FROM series_info s WHERE s.study_instance_uid = 'study_instance_uid-1646312263628' 用上述sql查询是查询结果为空；但转化为SQL2: SELECT s.exposure FROM series_info s WHERE study_instance_uid = 'study_instance_uid-1646312263628' SQL2的查询结果可以正常显示