hello:
我们启动spark start-thriftserver.sh on yarn ,通过JDBC 连接,从而可以查询hive 里面的所有表信息。
如果想同样通过tiSpark +jdbc 的方式操作,tidb 里面的表数据,有办法做到吗?
1. 目前spark-shell on yarn 是连接成功了,jar 肯定已经引入了
2. 但是thriftserver 的方式,jdbc 就找不到tidb 数据库了
3.有什么办法能完成这一步吗?
Class.forName("org.apache.hive.jdbc.HiveDriver");
Connection connection = DriverManager.getConnection("jdbc:hive2://10.1.1.1:10000/dbName","userName","pwd");
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery(" select count(1) from TableName ");
<?xml version="1.0" encoding="utf-8"?>
<configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://127.0.0.1:4000/metastore?createDatabaseIfNotExist=true</value> <description>metadata is stored in a MySQL server</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> <description>MySQL JDBC driver class</description> </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive</value> <description>user name for connecting to mysql server</description> </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>hive</value> <description>password for connecting to mysql server</description> </property> </configuration>