使用JDBC连接到Apache Drill

1下载Apache Drill

*1）Apache Drill需要安装并配置JDK1.8

*2）到Apache Drill官网地址下载并解压Apache Drill
http://drill.apache.org/ 当前版本apache-drill-1.13.0

2在Windows下启动Apache Drill

*1）可参考官网文档http://drill.apache.org/docs/drill-in-10-minutes/

*2）使用命令行工具进入bin目录运行命令sqlline.bat -u “jdbc:drill:zk=local”

*3）运行后可在命令行工具进行查询
select * from cp.employee.json limit 10;

也可在Web端控制台进行查询

3使用JDBC连接到Apache Drill

*1）在Eclipse下新建Maven Project

*2）在pom.xml添加对Apache Drill JDBC Driver的jar引用

    <dependency>
        <groupId>org.apache.drill.exec</groupId>
        <artifactId>drill-jdbc-all</artifactId>
        <version>1.13.0</version>
    </dependency>

*2）添加测试代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class App {

    public static void main( String[] args ) throws Exception {
        Class.forName("org.apache.drill.jdbc.Driver");
        Connection connection = DriverManager.getConnection("jdbc:drill:drillbit=127.0.0.1");
        Statement st = connection.createStatement();
        ResultSet rs = st.executeQuery("SELECT * from cp.`employee.json` LIMIT 1");
        while(rs.next()){
            System.out.println(rs.getString(1));
        }
    }
}

*3）测试运行代码

4其它相关文章

*1）JDBC使用Apache Drill进行跨库查询

https://blog.csdn.net/u010520912/article/details/80419558