CODEWITHSUNDEEP
oracle-databaseapache-sparkdataframeapache-spark-sqlhbase
fadaytak
fadaytak

Reputation: 83

spark dataframe and design Hbase : one table multiple-columns vs multiple tables one column family

i have multiples tables on an oracle database. i would like to copy this tables on Hbase, what is the best design, one table with multiple-columns family and each column family represent an oracle table? or multiple tables on Hbase with one column family containing all fields or multiples tables withe multiple columns family (each column family contain one column qualifier)?

i would after that using spark dataframe to run some job and querying like Oracle!!

wich strategy you use?

cordially

Upvotes: 0

Views: 294

Answers (1)

Ram Ghadiyaram
Ram Ghadiyaram

Reputation: 29227

Multiple column family (more than 3 column family) for one table is discouraged.

Please see hbase manual

So you have other option[s] which you have mentioned which are more suited for your requirements and your kind of design.

Upvotes: 2

Related Questions