当前位置：网站首页>Kettle experiment

Kettle experiment

2022-04-23 09:14:00 【Wind combed smoke】

1. recovery MySQL database

（1） open Navicat adopt enron-mysqldum_v5.sql File creation enron database

Or use the command line to restore the database , Notice here that I will sql The file is placed on the desktop

（2） open Navicat view the database , And create a new query :

SELECT DATE(date) AS dataset, COUNT(mid) AS numMSG
FROM message
GROUP BY date
ORDER BY date

2. open kettle Create a new transformation task

（1） newly build DB Connect , Click test after setting .

（2） Find the table input in the core object and configure


SELECT date(date) as datesent, count(mid) as numMsg
from message
where year(date) between 1998 and 2002
group by datesent
order by datesent

（3） To configure excel Output

（4） Run the transformation

版权声明
本文为[Wind combed smoke]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230907157502.html