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 >
