elasticsearch-sql
来源:互联网 发布:浙江网络作协 编辑:程序博客网 时间:2024/05/29 14:57
利用sql查询es
import org.junit.Assert;
import org.junit.Test;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.text.SimpleDateFormat;
public class JDBCTests {
@Test
public void testJDBC() throws Exception {
Properties properties = new Properties();
properties.put(“url”, “jdbc:elasticsearch://127.0.0.1:9300/test” );
DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory.createDataSource(properties);
Connection connection = dds.getConnection();
PreparedStatement ps = connection.prepareStatement(“SELECT province,count(*)as count from crawler/log where method=’getPhone’and status=4 and sellId=’chinaunicom’and methondType=’response’ and timeStamp.keyword between ‘2017-06-08 00:00:00’ and ‘2017-06-08 24:00:00’ group by province “);
ResultSet resultSet = ps.executeQuery();
while (resultSet.next()) { //result.add(resultSet.getString("sillId") + "," + resultSet.getInt("province") + "," + resultSet.getString("account")); System.out.println(resultSet.getString("province")); sucReqNum=(int)(resultSet.getDouble("count")); System.out.println(sucReqNum); } ps.close();
“`
- elasticSearch/elasticSearch-sql初探
- Elasticsearch-SQL
- elasticsearch-sql
- Elasticsearch-sql 用SQL查询Elasticsearch语句
- elasticsearch-sql插件
- elasticsearch sql的安装
- elasticsearch sql的使用
- elasticsearch sql插件安装
- 使用SQL查询Elasticsearch
- ElasticSearch使用SQL
- 使用SQL语法来查询Elasticsearch:Elasticsearch-SQL
- 使用SQL语法来查询Elasticsearch:Elasticsearch-SQL
- 用SQL语句查询elasticsearch
- spark-sql与elasticsearch整合&测试
- spark-sql与elasticsearch整合&测试
- Spark SQL 集成ElasticSearch的案例实战
- spark-sql与elasticsearch整合&测试
- elasticsearch head和sql插件离线安装
- Lua源码Lua编译库及解释器、编译器编译
- 1187: 棒棒糖(结构体专题)
- 软件定时器
- Matlab中的基本绘图方法
- JS&jQuery初级07
- elasticsearch-sql
- 欢迎使用CSDN-markdown编辑器
- linux 目录结构
- VM虚拟机 ubuntu16.04配置CPU版本的caffe
- java基础部分总结2
- linux学习之旅(十五(上))&磁盘
- 笨办法学 Python · 续 第二部分:简单的黑魔法
- linux 安装svn
- How Many Maos Does the Guanxi Worth --HDU