Great news! Please let me know if I can help in any way. (Editing springs to mind.)
-- Lefty On Sun, Mar 22, 2015 at 4:44 PM, Mich Talebzadeh <[email protected]> wrote: > 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 > > > >
