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 <[email protected]>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" <[email protected]> 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, <[email protected]> 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 > > > > >
