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.
