2.3. JDBC Driver
1-JDBC jar 或maven
Presto支持JDBC driver访问,下载 presto-jdbc-0.191.jar,添加到应用程序的 class path 中,同时也可以通过Maven中心仓库连接:
<dependency>
<groupId>com.facebook.presto</groupId>
<artifactId>presto-jdbc</artifactId>
<version>0.191</version>
</dependency>
presto 链接代码:fjtax 数据库名
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class PrestoUntil {
public static void main(String[] args) throws SQLException, ClassNotFoundException {
Class.forName("com.facebook.presto.jdbc.PrestoDriver");
Connection connection = DriverManager.getConnection("jdbc:presto://node2:8285/hive/fjtax","root",null); ;