elasticsearch-sql JDBC实例

最新推荐文章于 2024-03-28 09:59:00 发布

原创最新推荐文章于 2024-03-28 09:59:00 发布 · 2.8k 阅读

4 ·

CC 4.0 BY-SA版权

本文介绍了一种使用Java通过Elasticsearch-SQL插件查询数据的方法。示例代码展示了如何配置Druid数据源，建立连接，并执行SQL查询以从Elasticsearch检索数据。此方法适用于那些希望利用SQL语法查询Elasticsearch的开发者。

https://github.com/NLPchina/elasticsearch-sql

java连接elasticsearch-sql 测试代码


import java.sql.*; 
import java.util.Properties;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.ElasticSearchDruidDataSourceFactory;


public class Test {

	public static void main(String[] args) throws Exception {
		Properties properties = new Properties();
		properties.put("url", "jdbc:elasticsearch://192.168.1.181:9300/");
		DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory
		        .createDataSource(properties);
		dds.setInitialSize(1);
		Connection connection = dds.getConnection();
		String sql2 = "select * FROM t_url limit 10";
		PreparedStatement ps = connection.prepareStatement(sql2);
		ResultSet resultSet = ps.executeQuery();
		while (resultSet.next()) {
		    //sql对应输出
		    System.out.println(resultSet.getString("info.url") );

		}
		ps.close();
		connection.close();
		dds.close();
	}
}