Es的jdbc的配置连接

Es不允许免费版的jdbc连接，但可以免费使用30天，社区的政策是

 curl -X POST "localhost:9200/_license/start_trial?acknowledge=true&pretty"

ES的mavn配置

        
            org.elasticsearch.plugin
            x-pack-sql-jdbc
            7.8.0
        
          
            com.fasterxml.jackson.core
            jackson-databind
            2.10.1
        
        
            com.fasterxml.jackson.core
            jackson-core
            2.10.1
        
        
            com.fasterxml.jackson.core
            jackson-annotations
            2.10.1
        

import java.sql.*;


public class Sql_Jdbc {
    public static void main(String[] args) throws Exception {
       
        Connection connection=DriverManager.getConnection("jdbc:es://http://hadoop101:9200?timezone=UTC&page.size=250");
        Statement statement = connection.createStatement();
        ResultSet results = statement.executeQuery("select * from item LIMIT 5");

        while (results.next()) {

            System.out.println(results.getString(2));

        }
    }
}

注意
es的sql的where操作值支持keyword类型，也有可能我的mapping设置的问题