Hi Edward,
That is very interesting. On a recent project I am working with a major enterprise to get real time transactional data into HDFS via replication server and hive. This will allow Oracle, SAP ASE, SAP Hana, MSSQL and others to get real time data into HDFS via replication server. It is still at POC stage. Secondly, as 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. If these are relevant then let me know. Thanks, Mich Talebzadeh http://talebzadehmich.wordpress.com Publications due shortly: Creating in-memory Data Grid for Trading Systems with Oracle TimesTen and Coherence Cache 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. From: Edward Capriolo [mailto:[email protected]] Sent: 22 March 2015 19:22 To: [email protected] Subject: Call for case studies for Programming Hive, 2nd edition Hello all, Work is getting underway for Programming Hive 2nd Edition! One of the parts I enjoyed most is the case studies. They showed hive used in a number of enterprises and for different purposes. Since the 2nd edition is on the way I want to make another call for case studies and use cases of hive. For the last book many of these case studies came in at the buzzer (very close to publishing time) . We will be avoiding this for the second edition so that we have more time to iterate on them so they have a more consistent feel. Some of the existing case studies need to be reworked for the second edition. For example a case studies that address doing RANK queries before Hive had windowing. If you did a case study for the book I will try to track you down individual to see if they can be updated, but it would be easier if you found me. Thank you, Edward
