当前位置:网站首页>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
边栏推荐
- Kettle实验 (三)
- Harbor enterprise image management system
- Experimental report on analysis of overflow vulnerability of assembly language and reverse engineering stack
- MySQL小練習(僅適合初學者,非初學者勿進)
- Multi view depth estimation by fusing single view depth probability with multi view geometry
- How to render web pages
- DMP engine work summary (2021, lightsaber)
- 【读书笔记】《Verilog数字系统设计教程》 第5章 条件语句、循环语句和块语句(附思考题答案)
- 小程序报错 :should have url attribute when using navigateTo, redirectTo or switchTab
- 数字政府建设中政务中台中的技术创新点
猜你喜欢
调包求得每个样本的k个邻居
Share the office and improve the settled experience
npm ERR! network
653. Sum of two IV - input BST
valgrind和kcachegrind使用运行分析
PLC point table (register address and point table definition) cracking detection scheme -- convenient for industrial Internet data acquisition
112. 路径总和
MySQL小練習(僅適合初學者,非初學者勿進)
Number of islands
nn. Explanation of module class
随机推荐
Flink SQL realizes the integration of stream and batch
Machine learning (VI) -- Bayesian classifier
I don't understand time, timestamp and time zone. Look at this article
Summary of common concepts and problems of linear algebra in postgraduate entrance examination
653. Sum of two IV - input BST
Applet error: cannot read property'currenttarget'of undefined
错题汇总1
653. 两数之和 IV - 输入 BST
搞不懂时间、时间戳、时区,快来看这篇
資源打包關系依賴樹
GoLand debug go use - white record
Colorui solves the problem of blocking content in bottom navigation
[indexof] [lastIndexOf] [split] [substring] usage details
First principle mind map
kettle实验
Introduction to matlab
[SQL Server fast track] view and cursor of database
2D 01 Backpack
501. 二叉搜索树中的众数
Kettle实验 (三)