基于hive+sqoop+hbase的数据迁移

所涉及的工具版本：

1. hadoop2.7.3
2. hbase1.2.4
3. hive2.1.1
4. zookeeper3.4.10
5. mysql5.7.24

hdfs迁移到mysql

开启hadoop进程

start-dfs.sh
start-yarn.sh

导入hdfs中

hdfs dfs -mkdir /bicycle_datas
hdfs dfs -put /hour.csv /bicycle_datas

建立mysql表

create database bicycle; 
use bicycle;
create table hour(
	id int primary key,
	dteday varchar(255),
	season int,
	mnth int,
	hr int,
    temp double