不管是否在同一台机器上运行drill或hdfs。
为什么需要创建一个jar。
如果您使用maven作为构建工具，请添加drill jdbc驱动程序依赖项：

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

示例代码：

public class TestJDBC {

    // Host name of machine on which drill is running 
    public static final String DRILL_JDBC_LOCAL_URI = "jdbc:drill:drillbit=192.xxx.xxx.xxx";

    public static final String JDBC_DRIVER = "org.apache.drill.jdbc.Driver";

    public static void main(String[] args) throws SQLException {

        try {
            Class.forName(JDBC_DRIVER);

        } catch (ClassNotFoundException ce) {
            ce.printStackTrace();
        }

        try (Connection conn = new Driver().connect(DRILL_JDBC_LOCAL_URI, null);
                Statement stmt = conn.createStatement();) {

            String sql = "select employee_id,first_name,last_name from cp.`employee.json` limit 10";
            ResultSet rs = stmt.executeQuery(sql);

            while (rs.next()) {
                System.out.print(rs.getInt("employee_id") + "\t");
                System.out.print(rs.getString("first_name") + "\t");
                System.out.print(rs.getString("last_name") + "\t");
                System.out.println();
            }
            rs.close();

        } catch (SQLException se) {
            se.printStackTrace();
        }
    }
}