从 JDO 映射指南开始 JDO 的使用需要 PersistenceManagerFactory 来访问数据存储。 datanucleus-api-jdo.jar :这是 DataNucleus 对 JDO API 的实现。 它实现了 javax.jdo.jar 中定义的接口。 datanucleus-jdo-query.jar :它提供了一个注释处理器,JDO 类型查询机制使用它来生成运行时使用的 Q 类。 JDO教程 基本介绍 根据相关项目的开发过程,应用程序可以通过多种途径启用 JDO。 例如,该项目可以使用 Eclipse 作为开发类的 IDE。 驱动程序等) javax.jdo.jar(定义 JDO API 接口) datanucleus-core.jar、datanucleus-api-jdo.jar 和 datanucleus-{datastore
JDO 是Java 对象持久化的新的规范,为java data object 的简称,也是一个用于存取某种数据仓库中的对象的标准化API。 JDO 提供了透明的对象存储,因此对开发人员来说,存储数据对象完全不需要额外的代码(如JDBC API 的使用)。 这些繁琐的例行工作已经转移到JDO 产品提供商身上,使开发人员解脱出来,从而集中时间和精力在业务逻辑上。另外,JDO 很灵活,因为它可以在任何数据底层上运行。 JDBC 只是面向关系数据库(RDBMS)JDO 更通用,提供到任何数据底层的存储功能,比如关系数据库、文件、XML 以及对象数据库(ODBMS)等等,使得应用可移植性更强。
修改 hive-site.xml:<property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:derby:;databaseName =metastore_db;create=true</value></property><property> <name>javax.jdo.option.ConnectionDriverName</ </name> <value>hive</value></property><property> <name>javax.jdo.option.ConnectionPassword</name> 修改 hive-site.xml: 在 Metastore 服务器上:<property> <name>javax.jdo.option.ConnectionURL</name> <value </name> <value>hive</value></property><property> <name>javax.jdo.option.ConnectionPassword</name>
mysql-connector-java-5.1.21-bin.jar插件换成mysql-connector-java-5.1.12.jar FAILED: Error in metadata: javax.jdo.JDOFatalInternalException under the License. --> <configuration> <property> <name>javax.jdo.option.ConnectionURL JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName description> </property> </configuration> FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException
5.5.35-1.rhel5.i386.rpm 四、配置文件 修改Hive配置文件Hive-site.xml,修改后的结果如下所示: 1 <property> 2 <name>javax.jdo.option.ConnectionURL connect string for a JDBC metastore</description> 5 </property> 6 7 <property> 8 <name>javax.jdo.option.ConnectionDriverName </name> 15 <value>org.datanucleus.jdo.JDOPersistenceManagerFactory</value> 16 <description>class implementing the jdo persistence</description> 17 </property> 18 19 <property> 20 <name>javax.jdo.option.DetachAllOnCommit used after transaction is committed</description> 23 </property> 24 25 <property> 26 <name>javax.jdo.option.NonTransactionalRead
createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName </name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName </name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword </name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword
javax.jdo.option.ConnectionURL 元数据存储的 JDBC 连接 URL javax.jdo.option.ConnectionDriverName 元数据存储的 JDBC 驱动类 javax.jdo.option.ConnectionUserName 元数据存储数据库用户名 javax.jdo.option.ConnectionPassword 元数据存储数据库密码 hive.metastore.warehouse.dir </name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword MetaStore 服务通过 JDBC 与 MetaStore 数据库进行通信(使用 javax.jdo.option.ConnectionURL 属性配置): ? Hive MetaStore 服务端配置: <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql:
> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc :postgresql://<ip>:5432/<db></value> </property> <property> <name>javax.jdo.option.ConnectionDriverName name> <value>org.postgresql.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName </name> <value><username></value> </property> <property> <name>javax.jdo.option.ConnectionPassword
master:9000/user/hive/warehouse</value> </property> <property> <name>javax.jdo.option.ConnectionURL createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName </name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword
HADOOP_HOME/hadoop-2.7.1 4.修改hive-site.xml文件,指定MySQL数据库驱动、数据库名、用户名及密码,修改的内容如下所示 <property> <name>javax.jdo.option.ConnectionURL description>Driver class name for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName description>password to use against metastore database</description> </property> <property> 其中:javax.jdo.option.ConnectionURL 参数指定的是Hive连接数据库的连接字符串; javax.jdo.option.ConnectionDriverName参数指定的是驱动的类入口名称; javax.jdo.option.ConnectionUserName 参数指定了数据库的用户名;javax.jdo.option.ConnectionPassword参数指定了数据库的密码。
指定metastore_db的存储位置即可 具体修改如下: <property> <name>javax.jdo.option.ConnectionURL</name> <value> 数据库驱动 javax.jdo.option.ConnectionUserName hiveuser 用户名(之前创建的) javax.jdo.option.ConnectionPassword 123456 用户名密码 具体如下: <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:postgresql useSSL=true 指定连接的数据库(之前创建的) javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver 数据库驱动 javax.jdo.option.ConnectionUserName hiveuser 用户名(之前创建的) javax.jdo.option.ConnectionPassword 123456 用户名密码 具体如下: <property> <name>javax.jdo.option.ConnectionURL
> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc :mysql://Carlota1:3306/hive</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName </name> <value>root</value> </property> <property> <name>javax.jdo.option.ConnectionPassword
--mysql远程存储metastore配置--> <property> <name>javax.jdo.option.ConnectionURL</name> <value createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName </name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName </name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword hive.metastore.schema.verification</name> <value>false</value> </property> hive命令行下,set javax.jdo.option.ConnectionURL
配置Hive Metastore存储到MySQL 需要在hive-site.xml配置如下的参数 Config Param Config Value Comment javax.jdo.option.ConnectionURL createDatabaseIfNotExist=true metadata is stored in a MySQL server javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver MySQL JDBC driver class javax.jdo.option.ConnectionUserName <user name> user name for connecting to MySQL server javax.jdo.option.ConnectionPassword <password> password for connecting
hive_metadata; 配置hive-site.xml mv hive-default.xml.template hive-site.xml <property> <name>javax.jdo.option.ConnectionURL createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName </name> <value>com.mysql.jdbc.Driver</value> </property> <property> <name>javax.jdo.option.ConnectionUserName </name> <value>hive</value> </property> <property> <name>javax.jdo.option.ConnectionPassword</name
> <configuration> <property> <name>javax.jdo.option.ConnectionURL</name> a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionDriverName JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName metastore database</description> </property> <property> <name>javax.jdo.option.ConnectionPassword
cdh5.14.0/conf vim hive-site.xml 提醒下:下面的 node03.hadoop.com 改成你自己的节点名 javax.jdo.option.ConnectionURL createDatabaseIfNotExist=true javax.jdo.option.ConnectionDriverName com.mysql.jdbc.Driver javax.jdo.option.ConnectionUserName root javax.jdo.option.ConnectionPassword 123456 hive.cli.print.current.db
</description> </property> <property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql:/ characterEncoding=UTF-8&createDatabaseIfNotExist=true</value> </property> <property> <name>javax.jdo.option.ConnectionDriverName description>Driver class name for a JDBC metastore</description> </property> <property> <name>javax.jdo.option.ConnectionUserName description>username to use against metastore database</description> </property> <property> <name>javax.jdo.option.ConnectionPassword
(NucleusJDOHelper.java:671) ~[datanucleus-api-jdo-4.2.4.jar:?] :830) ~[datanucleus-api-jdo-4.2.4.jar:?] :334) ~[datanucleus-api-jdo-4.2.4.jar:?] :213) ~[datanucleus-api-jdo-4.2.4.jar:?] :1.8.0_191] at javax.jdo.JDOHelper$16.run(JDOHelper.java:1965) ~[hive-exec-3.1.0.3.0.1.0-187.
指定hive的数据临时文件目录 连接数据库的配置 : Hive需要将元数据存储在RDBMS中,配置mysql存储Hive元数据 javax.jdo.option.ConnectionURL createDatabaseIfNotExist=true JDBC connect string for a JDBC metastore javax.jdo.option.ConnectionDriverName javax.jdo.option.ConnectionUserName root username to use against metastore database javax.jdo.option.ConnectionPassword 111111 password to use against metastore database