当前位置:网站首页>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
边栏推荐
- LGB, XGB, cat, k-fold cross validation
- Summary of common concepts and problems of linear algebra in postgraduate entrance examination
- RSA 加密解密签名验签
- Non duplicate data values of two MySQL query tables
- Strength comparison vulnerability of PHP based on hash algorithm
- LeetCode_ DFS_ Medium_ 1254. Count the number of closed islands
- Principle of synchronized implementation
- Production practice elk
- ALV树(LL LR RL RR)插入删除
- Number theory to find the sum of factors of a ^ B (A and B are 1e12 levels)
猜你喜欢
653. Sum of two IV - input BST
I don't understand time, timestamp and time zone. Look at this article
Matlab draw five-star red flag
NPM reports an error: operation not allowed, MKDIR 'C: \ program files \ node JS \ node_ cache _ cacache’
Non duplicate data values of two MySQL query tables
Cadence process angle simulation, Monte Carlo simulation, PSRR
Strength comparison vulnerability of PHP based on hash algorithm
npm报错 :operation not permitted, mkdir ‘C: \Program Files \node js \node_ cache _ cacache’
调包求得每个样本的k个邻居
Failed to download esp32 program, prompting timeout
随机推荐
Find the sum of simple types of matrices
PCTP考试经验分享
Taxable income
考研线性代数常见概念、问题总结
The K neighbors of each sample are obtained by packet switching
A must see wechat applet development guide 1 - basic knowledge
[in-depth good article] detailed explanation of Flink SQL streaming batch integration technology (I)
Flink同时读取mysql与pgsql程序会卡住且没有日志
Common errors of VMware building es8
[SQL Server fast track] view and cursor of database
Failed to prepare device for development
Single chip microcomputer nixie tube stopwatch
Four pictures to understand some basic usage of Matplotlib
MySQL small exercise (only suitable for beginners, non beginners are not allowed to enter)
What is augmented reality technology? Where can it be used?
小程序报错:Cannot read property 'currentTarget' of undefined
[Luke V0] verification environment 2 - Verification Environment components
机器学习(六)——贝叶斯分类器
Multi view depth estimation by fusing single view depth probability with multi view geometry
Colorui solves the problem of blocking content in bottom navigation