hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mich Talebzadeh" <m...@peridale.co.uk>
Subject Configuring Hive metastore service to use SAP ASE as container for metastore
Date Mon, 09 Mar 2015 22:29:14 GMT
Hi,

 

As you may be aware hive metastore stores hive metadata in a relational
database. The recommendation is to have this database in a remote container.
Currently this database can be created "remotely" on MySQL and PostgresSQL
plus Oracle and I believe MSSQL.

 

I have now adapted the relevant schema for metadata for SAP Adaptive Server
Enterprise ( ASE) as well.  You need to create the schema (database) in ASE.
Create a login called say hiveuser in ASE and make its default database the
one just created for hive. Make the new login "dbo" in hive database. Pretty
easy. You will need to download the ASE driver called jconn4.jar and place
it in $HIVE_HOME/lib directory.

 

You then need to modify the file $HIVE_HOME/conf/hive-core.xml and add the
following lines

 

<property>

  <name>javax.jdo.option.ConnectionURL</name>

  <value>jdbc:sybase:Tds:<HOSTNAME>:<PORT>/<DATABASE></value>

</property>

<property>

  <name>javax.jdo.option.ConnectionDriverName</name>

  <value>com.sybase.jdbc4.jdbc.SybDriver</value>

</property>

<property>

  <name>javax.jdo.option.ConnectionUserName</name>

  <value>hiveuser</value>

</property>

 

<property>

  <name>javax.jdo.option.ConnectionPassword</name>

  <value>hiveuser</value>

</property>

 

I just recycled metastore and hiveserver2 connections and it all works fine.


 

Once I finished my testings, I will try to release the code and how to. As I
am very new to this forum, I may need some help on how to proceed.

 

Thanks,

 

Mich

 

 

NOTE: The information in this email is proprietary and confidential. This
message is for the designated recipient only, if you are not the intended
recipient, you should destroy it immediately. Any information in this
message shall not be understood as given or endorsed by Peridale Ltd, its
subsidiaries or their employees, unless expressly so stated. It is the
responsibility of the recipient to ensure that this email is virus free,
therefore neither Peridale Ltd, its subsidiaries nor their employees accept
any responsibility.

 


Mime
View raw message