Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Important Question


Copy link to this message
-
Re: Important Question
Dalia
 your requirements appear to be transaction oriented and thus OLTP systems
- i.e. regular relational databases - are more likely to be suitable than a
hive (/hadoop) based solution.  Hive is more for business intelligence and
certainly includes latencies - which by saying 'realtime'  - would likely
not be acceptable for your application.

stephenb

2012/1/25 Dalia Sobhy <[EMAIL PROTECTED]>

>  I will explain to u more Mike.
>
> I am building a Software Oriented Architecture, I want my API to provide
> some services such as Add/Delete Patients, Search for a patient by name/ID,
> count the number of people who are suffering from measles in Alexandria
> Egypt.
>
> Something like that so I am wondering which best suits my API ??
>
> > To: [EMAIL PROTECTED]
> > CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> > Subject: Re: Important Question
> > From: [EMAIL PROTECTED]
> > Date: Wed, 25 Jan 2012 12:05:39 -0500
>
> >
> > BTW, what do you mean by "realtime"? Do you mean you want to run some
> > non-trivial query quickly enough for some sort of interactive use? Can
> > you give us a feel for the sort of queries that interest you?
> >
> > Thanks,
> > Mike
> >
> >
> >
> > From: Dalia Sobhy <dalia.mohsobhy@hotm ail.com>
> > To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>,
> > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> > Date: 01/25/2012 11:34 AM
> > Subject: Re: Important Question
> >
> >
> >
> > So what about HBQL??
> > And if i had complex queries would i get stuck with HBase?
> >
> > Also can anyone provide me with examples of a table in RDBMS transformed
> > into hbase, realtime query and analytical processing..
> >
> > Sent from my iPhone
> >
> > On 2012-01-25, at 6:15 PM, [EMAIL PROTECTED] wrote:
> >
> > > Real Time.. Definitely not hive. Go in for HBase, but don't expect
> Hbase
> > to be as flexible as RDBMS. You need to choose your Row Key and Column
> > Families wisely as per your requirements.
> > > For data mining and analytics you can mount Hive table over
> > corresponding Hbase table and play on with SQL like queries.
> > >
> > >
> > >
> > > Regards
> > > Bejoy K S
> > >
> > > -----Original Message-----
> > > From: Dalia Sobhy <[EMAIL PROTECTED]>
> > > Date: Wed, 25 Jan 2012 17:01:08
> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> > > Reply-To: [EMAIL PROTECTED]
> > > Subject: Important Question
> > >
> > >
> > > Dear all,
> > > I am developing an API for medical use i.e Hospital admissions and all
> > about patients, thus transactions and queries and realtime data is
> > important here...
> > > Therefore both real-time and analytical processing is a must..
> > > Therefore which best suits my application Hbase or Hive or another
> > method ??
> > > Please reply quickly bec this is critical thxxx a million ;)
> >
> >
> **
>