Kettle experiment

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