mysql mapreduce_通过mapreduce把mysql的一张表的数据导到另外一张表中

怎么安装hadoop集群我在这里就不多说了，我这里安装的是三节点的集群

先在主节点安装mysql

启动mysql

登录mysql

创建数据库，创建表格，先把数据加载到表格 t ,表格t2是空的

mysql>create database mrtest;

Query OK,1 row affected (0.05sec)

mysql>use mrtest;

Database changed

mysql>CREATE TABLE `t` (-> `id` intDEFAULT NULL,-> `name` varchar(10) DEFAULT NULL-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query OK,0 rows affected (0.07sec)

mysql>CREATE TABLE `t2` (-> `id` intDEFAULT NULL,-> `name` varchar(10) DEFAULT NULL-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query OK,0 rows affected (0.01sec)

mysql> insert into t values (1,"june"),(2,"decli"),(3,"hello"),-> (4,"june"),(5,"decli"),(6,"hello"),(7,"june"),-> (8,"decli"),(9,"hello"),(10,"june"),-> (11,"june"),(12,"decli"),(13,"hello");

Query OK,13 rows affected (0.01sec)

Records:13 Duplicates: 0 Warnings: 0

配置一下mysql数据库

mysql>select user,host,password from mysql.user;+------+------------+-------------------------------------------+

| user | host | password |

+------+------------+-------------------------------------------+

| root | localhost | *6865AFFB6CE8FA9ED6A74985497DDD53FF3B8BAA |

| root | cdh-master | |

| root | 127.0.0.1 | |

| | localhost | |

| | cdh-master | |

| hive | % | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |

| hive | cdh-master | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |

| hive | localhost | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |

+------+------------+-------------------------------------------+

8 rows in set (0.04sec)

mysql> delete from user where user=' ';

ERROR1146 (42S02): Table 'mrtest.user' doesn't exist

mysql>use mysql;

Reading table informationforcompletion of table and column names

You can turn offthis feature to get a quicker startup with -A

Database changed

mysql> delete