Hi all,
I have run into some trouble while trying to port SQL DB to Hbase.
The problem is my SQL DB has around 500 tables (approx) and it is very badly
designed. Around 45-50 tables could be denormalised into a single table and
the remaining tables are static tables. My doubts are
1) Is it possible to port this DB (Tables) to Hbase? If possible how?
2) How many tables can Hbase support with tolerance towards failure?
3) When so many tables are inserted, how is the performance going to be
effected? Will it remain same or degrade?
One possible solution I think is using column family for each table. But as
per my knowledge and previous experiments, I found Hbase isn't stable when
column families are more than 5.
Since every day large quantities of data is ported into the DataBase,
stability and fail proof system is highest priority.
Hoping for a positive response.
Thank you,
kranthi
