Shulou(Shulou.com)05/31 Report--

This article mainly shows you "how to use sqoop to guide data from Oracle to Hbase", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn how to use sqoop to guide data from Oracle to Hbase "this article.

First, make sure that sqoop can call the oracle jdbc driver.

Sqoop import-D sqoop.hbase.add.row.key=true-- connect "jdbc:oracle:thin:@192.168.0.2:1521:orasid"

Password "password"-- username "system"

Query "SELECT * FROM SCHEMANAME.TABLENAME WHERE\ $CONDITIONS"-- hbase-create-table-- hbase-table "HADP:TABLENAME"

Hbase-row-key "ID"-- column-family "ID"-- split-by "ID"-- verbose

KEY is also written into the HBASE table as a value when sqoop.hbase.add.row.key is imported

The above is all the content of the article "how to use sqoop to guide data from Oracle to Hbase". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.