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: dalia.mohso...@hotmail.com > CC: u...@hbase.apache.org; user@hive.apache.org > Subject: Re: Important Question > From: mspre...@us.ibm.com > 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.mohso...@hotmail.com> > To: "u...@hbase.apache.org" <u...@hbase.apache.org> > Cc: "user@hive.apache.org" <user@hive.apache.org>, > "u...@hbase.apache.org" <u...@hbase.apache.org> > 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, bejoy...@yahoo.com 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 <dalia.mohso...@hotmail.com> > > Date: Wed, 25 Jan 2012 17:01:08 > > To: <u...@hbase.apache.org>; <user@hive.apache.org> > > Reply-To: user@hive.apache.org > > 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 ;) > >