flume存储到mysql_Flume将MySQL表数据存入到HDFS

Flume将MySQL表数据存入到HDFS

一、创建MySQL表

-- ----------------------------

-- Table structure for t_name

-- ----------------------------

DROP TABLE IF EXISTS `t_name`;

CREATE TABLE `t_name` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`sip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

`dip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

`sport` int(11) NULL DEFAULT NULL,

`dport` int(11) NULL DEFAULT NULL,

`protocol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,

`flowvalue` int(11) NULL DEFAULT NULL,

`createtime` datetime(0) NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET =