Elasticsearch SQL函数大全:http://www.open-open.com/lib/view/open1447747736056.html
maven引用:
<dependency> <groupId>org.elasticsearch</groupId> <artifactId>elasticsearch</artifactId> <version>2.4.1</version> </dependency> <dependency> <groupId>org.nlpcn</groupId> <artifactId>elasticsearch-sql</artifactId> <version>2.4.1.0</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.26</version> </dependency>
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> </dependency>
Properties properties = new Properties(); properties.put("url", "jdbc:elasticsearch://192.168.1.101:9300/"); DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory .createDataSource(properties); dds.setInitialSize(1); Connection connection = dds.getConnection(); String sql2 = "select * FROM myindex"; PreparedStatement ps = connection.prepareStatement(sql2); ResultSet resultSet = ps.executeQuery(); while (resultSet.next()) { //sql对应输出 System.out.println(resultSet.getString("字段名") ); } ps.close(); connection.close(); dds.close();