{"id":1857,"date":"2019-06-19T17:57:31","date_gmt":"2019-06-19T12:27:31","guid":{"rendered":"http:\/\/blog.tenthplanet.in\/?p=1857"},"modified":"2026-03-03T10:14:15","modified_gmt":"2026-03-03T10:14:15","slug":"mapr-hive-table-meta-export-to-postgres-db","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/blogs\/mapr-hive-table-meta-export-to-postgres-db\/","title":{"rendered":"Table meta export from MapR hive to Postgres DB (Database)"},"content":{"rendered":"

To Install the PostgreSQL JDBC driver, On the Hive Metastore server host, install libpostgresql-jdbc-java and symbolically link the file to the \/usr\/lib\/hive\/lib\/ directory. For example:<\/p>\n

$ sudo apt-get install libpostgresql-jdbc-java\n$ ln -s \/usr\/share\/java\/postgresql-jdbc4.jar \/opt\/mapr\/hive\/\/hive-<version>\/lib\/postgresql-jdbc.jar<\/pre>\n
Create the Metastore database and user accounts.<\/p>\n
$ sudo -u postgres psql\npostgres=# CREATE USER hiveuser WITH PASSWORD 'mypassword';\npostgres=# CREATE DATABASE metastore;<\/pre>\n
Configure the Metastore service to communicate with the PostgreSQL database by setting the necessary properties (shown below) in the \/opt\/mapr\/hive\/\/hive-<version>\/conf\/hive-site.xml file.<\/p>\n
<property> <name>javax.jdo.option.ConnectionURL<\/name> <value>jdbc:postgresql:\/\/myhost\/metastore<\/value> <\/property><\/p>\n
<property>\n<name>javax.jdo.option.ConnectionDriverName<\/name>\n<value>org.postgresql.Driver<\/value>\n<\/property><\/pre>\n
<property>\n<name>javax.jdo.option.ConnectionUserName<\/name>\n<value>hiveuser<\/value>\n<\/property><\/pre>\n
<property>\n<name>javax.jdo.option.ConnectionPassword<\/name>\n<value>mypassword<\/value>\n<\/property><\/pre>\n
<property>\n<name>hive.metastore.uris<\/name>\n<value>thrift:\/\/<n.n.n.n>:9083<\/value>\n<description>IP address (or fully-qualified domain name) and port of the metastore host<\/description>\n<\/property><\/pre>\n
Run schemaTool to create the initial DB structure.<\/p>\n
\/opt\/mapr\/hive\/hive-<version>\/bin\/schematool -dbType postgres -initSchema<\/pre>\n","protected":false},"excerpt":{"rendered":"
Table meta export from MapR hive to Postgres DB<\/p>\n","protected":false},"author":23,"featured_media":1877,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[541,542,27],"class_list":["post-1857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-bigdata-and-pentaho","tag-mapr-hive-table","tag-postgresql"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=1857"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/1857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/1877"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=1857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=1857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=1857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}