Ryan,
Thanks. Yep, I've read the Bigtable paper (now and in 2006) and
understand that HBase and Bigtable are essentially large maps and do
not use the relational model.
Still interested in hearing if others have successfully done this.
(I'm mostly looking for ways to speed up the implementation of a one-
way replication: from a relational DB to HBase.)
Thanks,
Brian
On Apr 17, 2009, at 5:45 PM, Ryan Rawson wrote:
HBase is not a relational database, so many things that are in a SQL
database dont exist.
eg:
- sequences
- secondary declarative keys
- joins
- advance query features such as order by, group by
- operators of any kind
Given conventions (eg: naming of index tables), it might be possible
to
semi-automatedly convert data, but it might not efficiently take
advantage
of HBase's unique schema-less design.
I suggest you have a look at the Google's bigtable paper, as it has
the same
underlying model that HBase does.
Good luck!
On Fri, Apr 17, 2009 at 3:30 PM, Brian Forney
<[email protected]> wrote:
Hi all,
I'd like to replicate a large dataset from a relational database
into HBase
for better throughput of MapReduce jobs. Has anyone had success
replicating
from a relational database (in my case SQL Server) to HBase?
Thanks,
Brian
