You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by da...@gm.com on 2011/11/04 07:02:34 UTC
new to hbase
hi experts,
I am new to hbase , i am planing to implement HBase in my Development
environment ,can u please tell me habse is suitable or not..., we are
updating our database weekly once from the production database ,
my application was implemented on oracle database , our databse is reached
nearlly 1 TB,now i am planing to implement to Hbase and hadoop in My
Applications
1.Is there any possibility that i can able to use our won Sql Queries in
HBase.
2.Is there any Possiblity of synchronize our oracle Db with Hbase for My
Weekly Update.
Thank
Nothing in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.
Confidentiality Note: This message is intended only for the person or entity to which it is addressed. It may contain confidential and/or privileged material. Any review, transmission, dissemination or other use, or taking of any action in reliance upon this message by persons or entities other than the intended recipient is prohibited and may be unlawful. If you received this message in error, please contact the sender and delete it from your computer.
Re: new to hbase
Posted by Jignesh Patel <ji...@gmail.com>.
Experts already commented. Just want to add one point- even HBase doesn't
support sql queries, companies like FB uses for real time communication via
raw API, something which you can't do with Hive.
-Jignesh
On Fri, Nov 4, 2011 at 8:30 AM, Doug Meil <do...@explorysmedical.com>wrote:
>
> In addition to what Joey said, it's worth taking inventory of your current
> pain points. What are your current challenges? Ad-hoc queries? Creating
> summaries? If it's entirely ad-hoc and your users want SQL, then I think
> Joey pretty much nailed it.
>
> For more info: http://hbase.apache.org/book.html
>
>
>
>
> On 11/4/11 7:55 AM, "Joey Echeverria" <jo...@cloudera.com> wrote:
>
> >My first suggestion would be to not use HBase. 1 TB isn't that large
> >for a beefy database server to handle. If you don't want to keep using
> >Oracle, you could look at MySQL or PostgreSQL.
> >
> >As for your specific questions:
> >
> >1) You can't run SQL queries directly over HBase, it's not a RDMS. You
> >could try using Hive's HBase integration. Hive is a library that
> >translates SQL-ish queries into MapReduce jobs. I say SQL-ish because
> >it's not fully SQL compliant. Also, the integration with HBase is
> >still immature.
> >2) The best option for moving data between HBase and Oracle is Sqoop.
> >Sqoop's an Apache (incubating) project for transferring data between
> >RDBMS and Hadoop. It also includes native support for populating HBase
> >tables with the exported data.
> >
> >-Joey
> >
> >On Fri, Nov 4, 2011 at 2:02 AM, <da...@gm.com> wrote:
> >> hi experts,
> >> I am new to hbase , i am planing to implement HBase in my Development
> >> environment ,can u please tell me habse is suitable or not..., we are
> >> updating our database weekly once from the production database ,
> >> my application was implemented on oracle database , our databse is
> >>reached
> >> nearlly 1 TB,now i am planing to implement to Hbase and hadoop in My
> >> Applications
> >>
> >> 1.Is there any possibility that i can able to use our won Sql Queries in
> >> HBase.
> >> 2.Is there any Possiblity of synchronize our oracle Db with Hbase for
> >>My
> >> Weekly Update.
> >>
> >> Thank
> >>
> >> Nothing in this message is intended to constitute an electronic
> >>signature unless a specific statement to the contrary is included in
> >>this message.
> >>
> >> Confidentiality Note: This message is intended only for the person or
> >>entity to which it is addressed. It may contain confidential and/or
> >>privileged material. Any review, transmission, dissemination or other
> >>use, or taking of any action in reliance upon this message by persons or
> >>entities other than the intended recipient is prohibited and may be
> >>unlawful. If you received this message in error, please contact the
> >>sender and delete it from your computer.
> >>
> >
> >
> >
> >--
> >Joseph Echeverria
> >Cloudera, Inc.
> >443.305.9434
> >
>
>
>
Re: new to hbase
Posted by Doug Meil <do...@explorysmedical.com>.
In addition to what Joey said, it's worth taking inventory of your current
pain points. What are your current challenges? Ad-hoc queries? Creating
summaries? If it's entirely ad-hoc and your users want SQL, then I think
Joey pretty much nailed it.
For more info: http://hbase.apache.org/book.html
On 11/4/11 7:55 AM, "Joey Echeverria" <jo...@cloudera.com> wrote:
>My first suggestion would be to not use HBase. 1 TB isn't that large
>for a beefy database server to handle. If you don't want to keep using
>Oracle, you could look at MySQL or PostgreSQL.
>
>As for your specific questions:
>
>1) You can't run SQL queries directly over HBase, it's not a RDMS. You
>could try using Hive's HBase integration. Hive is a library that
>translates SQL-ish queries into MapReduce jobs. I say SQL-ish because
>it's not fully SQL compliant. Also, the integration with HBase is
>still immature.
>2) The best option for moving data between HBase and Oracle is Sqoop.
>Sqoop's an Apache (incubating) project for transferring data between
>RDBMS and Hadoop. It also includes native support for populating HBase
>tables with the exported data.
>
>-Joey
>
>On Fri, Nov 4, 2011 at 2:02 AM, <da...@gm.com> wrote:
>> hi experts,
>> I am new to hbase , i am planing to implement HBase in my Development
>> environment ,can u please tell me habse is suitable or not..., we are
>> updating our database weekly once from the production database ,
>> my application was implemented on oracle database , our databse is
>>reached
>> nearlly 1 TB,now i am planing to implement to Hbase and hadoop in My
>> Applications
>>
>> 1.Is there any possibility that i can able to use our won Sql Queries in
>> HBase.
>> 2.Is there any Possiblity of synchronize our oracle Db with Hbase for
>>My
>> Weekly Update.
>>
>> Thank
>>
>> Nothing in this message is intended to constitute an electronic
>>signature unless a specific statement to the contrary is included in
>>this message.
>>
>> Confidentiality Note: This message is intended only for the person or
>>entity to which it is addressed. It may contain confidential and/or
>>privileged material. Any review, transmission, dissemination or other
>>use, or taking of any action in reliance upon this message by persons or
>>entities other than the intended recipient is prohibited and may be
>>unlawful. If you received this message in error, please contact the
>>sender and delete it from your computer.
>>
>
>
>
>--
>Joseph Echeverria
>Cloudera, Inc.
>443.305.9434
>
Re: new to hbase
Posted by Joey Echeverria <jo...@cloudera.com>.
My first suggestion would be to not use HBase. 1 TB isn't that large
for a beefy database server to handle. If you don't want to keep using
Oracle, you could look at MySQL or PostgreSQL.
As for your specific questions:
1) You can't run SQL queries directly over HBase, it's not a RDMS. You
could try using Hive's HBase integration. Hive is a library that
translates SQL-ish queries into MapReduce jobs. I say SQL-ish because
it's not fully SQL compliant. Also, the integration with HBase is
still immature.
2) The best option for moving data between HBase and Oracle is Sqoop.
Sqoop's an Apache (incubating) project for transferring data between
RDBMS and Hadoop. It also includes native support for populating HBase
tables with the exported data.
-Joey
On Fri, Nov 4, 2011 at 2:02 AM, <da...@gm.com> wrote:
> hi experts,
> I am new to hbase , i am planing to implement HBase in my Development
> environment ,can u please tell me habse is suitable or not..., we are
> updating our database weekly once from the production database ,
> my application was implemented on oracle database , our databse is reached
> nearlly 1 TB,now i am planing to implement to Hbase and hadoop in My
> Applications
>
> 1.Is there any possibility that i can able to use our won Sql Queries in
> HBase.
> 2.Is there any Possiblity of synchronize our oracle Db with Hbase for My
> Weekly Update.
>
> Thank
>
> Nothing in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.
>
> Confidentiality Note: This message is intended only for the person or entity to which it is addressed. It may contain confidential and/or privileged material. Any review, transmission, dissemination or other use, or taking of any action in reliance upon this message by persons or entities other than the intended recipient is prohibited and may be unlawful. If you received this message in error, please contact the sender and delete it from your computer.
>
--
Joseph Echeverria
Cloudera, Inc.
443.305.9434