If I developed a system locally, want to have it migrated to the cloud, how can I get to format the data in a relational database (mysql), for example, use Hbase, Bigtable non-relational database storage? For a great god

CodePudding user response:

Additional content: the relational database can be stored in a relational database format data?

CodePudding user response:

A tool sqoop, can turn a mysql data import into hbase
Hbase is a no (database, however, does not support SQL statements, the transaction features, so use it to replace mysql, you have to weigh

CodePudding user response:

Mysql into hbase is easy, but make sure your system can be a very good run or difficult, hbase does not support SQL statements, but can I take a hive to operation data in hbase, hive support operating hbase data through similar to SQL, but speed too slow, because the hive itself is not used to query data, hive is a data warehouse, data analysis, hbase only scan is used to query data, so if you don't use hive needs to scan the SQL statements