Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 429359276 for ; Wed, 25 Jan 2012 20:56:53 +0000 (UTC) Received: (qmail 44611 invoked by uid 500); 25 Jan 2012 20:56:52 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 44531 invoked by uid 500); 25 Jan 2012 20:56:51 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 44515 invoked by uid 99); 25 Jan 2012 20:56:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2012 20:56:51 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dalia.mohsobhy@hotmail.com designates 65.54.190.82 as permitted sender) Received: from [65.54.190.82] (HELO bay0-omc2-s7.bay0.hotmail.com) (65.54.190.82) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2012 20:56:40 +0000 Received: from BAY156-W33 ([65.54.190.125]) by bay0-omc2-s7.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 25 Jan 2012 12:56:19 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_a24b0371-d63f-4c81-b6f4-b96cc2f003e0_" X-Originating-IP: [41.35.212.122] From: Dalia Sobhy To: CC: Subject: RE: Important Question Date: Wed, 25 Jan 2012 22:56:19 +0200 Importance: Normal In-Reply-To: References: <831587242-1327507463-cardhu_decombobulator_blackberry.rim.net-1866588710-@b18.c2.bise7.blackberry> , MIME-Version: 1.0 X-OriginalArrivalTime: 25 Jan 2012 20:56:19.0611 (UTC) FILETIME=[C9A556B0:01CCDBA3] X-Virus-Checked: Checked by ClamAV on apache.org --_a24b0371-d63f-4c81-b6f4-b96cc2f003e0_ Content-Type: text/plain; charset="windows-1256" Content-Transfer-Encoding: 8bit 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.mohsobhy@hotmail.com > CC: user@hbase.apache.org; user@hive.apache.org > Subject: Re: Important Question > From: mspreitz@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 > To: "user@hbase.apache.org" > Cc: "user@hive.apache.org" , > "user@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_ks@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 > > Date: Wed, 25 Jan 2012 17:01:08 > > To: ; > > 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 ;) > > --_a24b0371-d63f-4c81-b6f4-b96cc2f003e0_ Content-Type: text/html; charset="windows-1256" Content-Transfer-Encoding: 8bit
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.mohsobhy@hotmail.com
> CC: user@hbase.apache.org; user@hive.apache.org
> Subject: Re: Important Question
> From: mspreitz@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.mohsobhy@hotm ail.com>
> To: "user@hbase.apache.org" <user@hbase.apache.org>
> Cc: "user@hive.apache.org" <user@hive.apache.org>,
> "user@hbase.apache.org" <user@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_ks@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.mohsobhy@hotmail.com>
> > Date: Wed, 25 Jan 2012 17:01:08
> > To: <user@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 ;)
>
>
--_a24b0371-d63f-4c81-b6f4-b96cc2f003e0_--