kettle6.0使用手册(14)

, PRIMARY KEY (ID_STEP_ATTRIBUTE) ) ;

CREATE UNIQUE INDEX IDX_RSAT ON R_STEP_ATTRIBUTE(ID_STEP, CODE, NR) ;

CREATE TABLE R_STEP_DATABASE (

ID_TRANSFORMATION INTEGER , ID_STEP INTEGER , ID_DATABASE INTEGER ) ;

CREATE INDEX IDX_RSD1 ON R_STEP_DATABASE(ID_TRANSFORMATION) ;

CREATE INDEX IDX_RSD2 ON R_STEP_DATABASE(ID_DATABASE) ;

CREATE TABLE R_TRANS_NOTE (

ID_TRANSFORMATION INTEGER , ID_NOTE INTEGER ) ;

CREATE TABLE R_LOGLEVEL (

ID_LOGLEVEL INTEGER , CODE VARCHAR2(255)

, DESCRIPTION VARCHAR2(255) , PRIMARY KEY (ID_LOGLEVEL) ) ;

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (1,'Error','错误日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (2,'Minimal','最小日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (3,'Basic','基本

日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (4,'Detailed','详细日志');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (5,'Debug','调试');

INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (6,'Rowlevel','行级日志(非常详细)');

CREATE TABLE R_LOG (

ID_LOG INTEGER , NAME VARCHAR2(255) , ID_LOGLEVEL INTEGER , LOGTYPE VARCHAR2(255) , FILENAME VARCHAR2(255) , FILEEXTENTION VARCHAR2(255) , ADD_DATE CHAR(1) , ADD_TIME CHAR(1)

, ID_DATABASE_LOG INTEGER , TABLE_NAME_LOG VARCHAR2(255) , PRIMARY KEY (ID_LOG) ) ;

CREATE TABLE R_JOB (

ID_JOB INTEGER , ID_DIRECTORY INTEGER , NAME VARCHAR2(255) , DESCRIPTION CLOB

, EXTENDED_DESCRIPTION CLOB , JOB_VERSION VARCHAR2(255) , JOB_STATUS INTEGER , ID_DATABASE_LOG INTEGER , TABLE_NAME_LOG VARCHAR2(255) , CREATED_USER VARCHAR2(255) , CREATED_DATE DATE

, MODIFIED_USER VARCHAR2(255) , MODIFIED_DATE DATE , USE_BATCH_ID CHAR(1) , PASS_BATCH_ID CHAR(1)

, USE_LOGFIELD CHAR(1) , SHARED_FILE VARCHAR2(255) , PRIMARY KEY (ID_JOB) ) ;

CREATE TABLE R_JOBENTRY_DATABASE (

ID_JOB INTEGER , ID_JOBENTRY INTEGER , ID_DATABASE INTEGER ) ;

CREATE INDEX IDX_RJD1 ON R_JOBENTRY_DATABASE(ID_JOB) ;

CREATE INDEX IDX_RJD2 ON R_JOBENTRY_DATABASE(ID_DATABASE) ;

CREATE TABLE R_JOBENTRY_TYPE (

ID_JOBENTRY_TYPE INTEGER , CODE VARCHAR2(255)

, DESCRIPTION VARCHAR2(255) , PRIMARY KEY (ID_JOBENTRY_TYPE) ) ;

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (1,'DELAY','等待');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (2,'HTTP','HTTP');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (3,'UNZIP','解压缩文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (4,'FILES_EXIST','检查多个文件是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (5,'HL7MLLPInput','HL7 MLLP Input');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (6,'GET_POP','POP 收信');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (7,'MAIL','发送邮件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (8,'EMRJobExecutorPlugin','Amazon EMR Job Executor');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (9,'HadoopCopyFilesPlugin','Hadoop Copy Files');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (10,'WRITE_TO_FILE','写入文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (11,'EVAL_FILES_METRICS','计算文件大小或个数');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (12,'FILE_EXISTS','检查一个文件是否存在');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (13,'WAIT_FOR_SQL','等待SQL');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (14,'SFTP','SFTP 下载');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (15,'SET_VARIABLES','设置变量');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (16,'MS_ACCESS_BULK_LOAD','MS Access Bulk Load');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (17,'TRANS','转换');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (18,'XML_WELL_FORMED','检查 XML 文件格式');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (19,'SEND_NAGIOS_PASSIVE_CHECK','发送Nagios 被动检查');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (20,'SUCCESS','成功');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (21,'FTP_DELETE','FTP 删除');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (22,'SQL','SQL');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (23,'HiveJobExecutorPlugin','Amazon Hive Job Executor');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (24,'EVAL_TABLE_CONTENT','计算表中的记录数');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (25,'PALO_CUBE_CREATE','Palo Cube Create');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (26,'COPY_FILES','复制文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (27,'DELETE_FILE','删除一个文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (28,'MOVE_FILES','移动文件');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (29,'CONNECTED_TO_REPOSITORY','检查是否连接到资源库');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (30,'MSGBOX_INFO','显示消息对话框');

INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DES …… 此处隐藏：3830字，全部文档内容请下载后查看。喜欢就下载吧 ……