Call for case studies for Programming Hive, 2nd edition

[Edward Capriolo <ed...@gmail.com>]

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

Re: Call for case studies for Programming Hive, 2nd edition

[Lefty Leverenz <le...@gmail.com>]

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 <mi...@peridale.co.uk>
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:edlinuxguru@gmail.com]
> *Sent:* 22 March 2015 19:22
> *To:* user@hive.apache.org
> *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
>
>
>
>

RE: Call for case studies for Programming Hive, 2nd edition

[Mich Talebzadeh <mi...@peridale.co.uk>]

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:edlinuxguru@gmail.com] 
Sent: 22 March 2015 19:22
To: user@hive.apache.org
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