DMER站长博客分析师资源站

DMER数据分析

 找回密码
 立即注册

扫一扫,访问微社区

QQ登录

只需一步,快速开始

查看: 2588|回复: 1

[kettle] Incorrect integer value: 'Y' for column 'IS_UPGRADE' at row 1

[复制链接]

1033

主题

1330

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36809
QQ
发表于 2015-8-22 10:21:02 | 显示全部楼层 |阅读模式

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
问题是  sql语句里边使用 'Y' 'N'  给boolean类型的赋值产生sql失败  
我用的mysql版本是5.6
kettle版本是pdi-ce-5.0.1.A-stable
难道是我用的kettle版本太高了 大家有遇到这种问题的吗?
解决方法是将sql语句copy出来  修改一下 然后覆盖回去 或者是通过mysql的cli执行
sql语句如下:

  1. -- Repository creation/upgrade DDL:
  2. --
  3. -- Nothing was created nor modified in the target repository database.
  4. -- Hit the OK button to execute the generated SQL or Close to reject the changes.
  5. -- Please note that it is possible to change/edit the generated SQL before execution.
  6. --
  7. CREATE TABLE R_REPOSITORY_LOG
  8. (
  9.   ID_REPOSITORY_LOG BIGINT NOT NULL PRIMARY KEY
  10. , REP_VERSION VARCHAR(255)
  11. , LOG_DATE DATETIME
  12. , LOG_USER VARCHAR(255)
  13. , OPERATION_DESC MEDIUMTEXT
  14. )
  15. ;

  16. CREATE TABLE R_VERSION
  17. (
  18.   ID_VERSION BIGINT NOT NULL PRIMARY KEY
  19. , MAJOR_VERSION INT
  20. , MINOR_VERSION INT
  21. , UPGRADE_DATE DATETIME
  22. , IS_UPGRADE BOOLEAN
  23. )
  24. ;
  25. INSERT INTO R_VERSION(ID_VERSION, MAJOR_VERSION, MINOR_VERSION, UPGRADE_DATE, IS_UPGRADE) VALUES (1,5,0,'2014/11/23 13:27:43.013',false);
  26. CREATE TABLE R_DATABASE_TYPE
  27. (
  28.   ID_DATABASE_TYPE BIGINT NOT NULL PRIMARY KEY
  29. , CODE VARCHAR(255)
  30. , DESCRIPTION VARCHAR(255)
  31. )
  32. ;
  33. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (1,'DERBY','Apache Derby');
  34. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (2,'AS/400','AS/400');
  35. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (3,'INTERBASE','Borland Interbase');
  36. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (4,'INFINIDB','Calpont InfiniDB');
  37. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (5,'DBASE','dBase III, IV or 5');
  38. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (6,'EXASOL4','Exasol 4');
  39. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (7,'EXTENDB','ExtenDB');
  40. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (8,'FIREBIRD','Firebird SQL');
  41. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (9,'GENERIC','Generic database');
  42. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (10,'GREENPLUM','Greenplum');
  43. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (11,'SQLBASE','Gupta SQL Base');
  44. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (12,'H2','H2');
  45. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (13,'HIVE','Hadoop Hive');
  46. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (14,'HIVE2','Hadoop Hive 2');
  47. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (15,'HYPERSONIC','Hypersonic');
  48. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (16,'DB2','IBM DB2');
  49. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (17,'IMPALA','Impala');
  50. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (18,'INFOBRIGHT','Infobright');
  51. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (19,'INFORMIX','Informix');
  52. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (20,'INGRES','Ingres');
  53. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (21,'VECTORWISE','Ingres VectorWise');
  54. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (22,'CACHE','Intersystems Cache');
  55. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (23,'KettleThin','Kettle thin JDBC driver');
  56. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (24,'KINGBASEES','KingbaseES');
  57. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (25,'LucidDB','LucidDB');
  58. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (26,'SAPDB','MaxDB (SAP DB)');
  59. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (27,'MONETDB','MonetDB');
  60. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (28,'MSACCESS','MS Access');
  61. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (29,'MSSQL','MS SQL Server');
  62. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (30,'MSSQLNATIVE','MS SQL Server (Native)');
  63. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (31,'MYSQL','MySQL');
  64. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (32,'MONDRIAN','Native Mondrian');
  65. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (33,'NEOVIEW','Neoview');
  66. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (34,'NETEZZA','Netezza');
  67. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (35,'OpenERPDatabaseMeta','OpenERP Server');
  68. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (36,'ORACLE','Oracle');
  69. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (37,'ORACLERDB','Oracle RDB');
  70. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (38,'PALO','Palo MOLAP Server');
  71. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (39,'POSTGRESQL','PostgreSQL');
  72. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (40,'REMEDY-AR-SYSTEM','Remedy Action Request System');
  73. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (41,'SAPR3','SAP ERP System');
  74. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (42,'SQLITE','SQLite');
  75. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (43,'SYBASE','Sybase');
  76. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (44,'SYBASEIQ','SybaseIQ');
  77. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (45,'TERADATA','Teradata');
  78. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (46,'UNIVERSE','UniVerse database');
  79. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (47,'VERTICA','Vertica');
  80. INSERT INTO R_DATABASE_TYPE(ID_DATABASE_TYPE, CODE, DESCRIPTION) VALUES (48,'VERTICA5','Vertica 5+');
  81. CREATE TABLE R_DATABASE_CONTYPE
  82. (
  83.   ID_DATABASE_CONTYPE BIGINT NOT NULL PRIMARY KEY
  84. , CODE VARCHAR(255)
  85. , DESCRIPTION VARCHAR(255)
  86. )
  87. ;
  88. INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (1,'Native','Native (JDBC)');
  89. INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (2,'ODBC','ODBC');
  90. INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (3,'OCI','OCI');
  91. INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (4,'Plugin','Plugin specific access method');
  92. INSERT INTO R_DATABASE_CONTYPE(ID_DATABASE_CONTYPE, CODE, DESCRIPTION) VALUES (5,', ','JNDI');
  93. CREATE TABLE R_NOTE
  94. (
  95.   ID_NOTE BIGINT NOT NULL PRIMARY KEY
  96. , VALUE_STR MEDIUMTEXT
  97. , GUI_LOCATION_X INT
  98. , GUI_LOCATION_Y INT
  99. , GUI_LOCATION_WIDTH INT
  100. , GUI_LOCATION_HEIGHT INT
  101. , FONT_NAME MEDIUMTEXT
  102. , FONT_SIZE INT
  103. , FONT_BOLD BOOLEAN
  104. , FONT_ITALIC BOOLEAN
  105. , FONT_COLOR_RED INT
  106. , FONT_COLOR_GREEN INT
  107. , FONT_COLOR_BLUE INT
  108. , FONT_BACK_GROUND_COLOR_RED INT
  109. , FONT_BACK_GROUND_COLOR_GREEN INT
  110. , FONT_BACK_GROUND_COLOR_BLUE INT
  111. , FONT_BORDER_COLOR_RED INT
  112. , FONT_BORDER_COLOR_GREEN INT
  113. , FONT_BORDER_COLOR_BLUE INT
  114. , DRAW_SHADOW BOOLEAN
  115. )
  116. ;
  117. CREATE TABLE R_DATABASE
  118. (
  119.   ID_DATABASE BIGINT NOT NULL PRIMARY KEY
  120. , NAME VARCHAR(255)
  121. , ID_DATABASE_TYPE INT
  122. , ID_DATABASE_CONTYPE INT
  123. , HOST_NAME VARCHAR(255)
  124. , DATABASE_NAME MEDIUMTEXT
  125. , PORT INT
  126. , USERNAME VARCHAR(255)
  127. , PASSWORD VARCHAR(255)
  128. , SERVERNAME VARCHAR(255)
  129. , DATA_TBS VARCHAR(255)
  130. , INDEX_TBS VARCHAR(255)
  131. )
  132. ;
  133. CREATE TABLE R_DATABASE_ATTRIBUTE
  134. (
  135.   ID_DATABASE_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  136. , ID_DATABASE INT
  137. , CODE VARCHAR(255)
  138. , VALUE_STR MEDIUMTEXT
  139. )
  140. ;
  141. CREATE UNIQUE INDEX IDX_R_DATABASE_ATTRIBUTE_AK ON R_DATABASE_ATTRIBUTE(ID_DATABASE, CODE)
  142. ;
  143. CREATE TABLE R_DIRECTORY
  144. (
  145.   ID_DIRECTORY BIGINT NOT NULL PRIMARY KEY
  146. , ID_DIRECTORY_PARENT INT
  147. , DIRECTORY_NAME VARCHAR(255)
  148. )
  149. ;
  150. CREATE UNIQUE INDEX IDX_R_DIRECTORY_AK ON R_DIRECTORY(ID_DIRECTORY_PARENT, DIRECTORY_NAME)
  151. ;
  152. CREATE TABLE R_TRANSFORMATION
  153. (
  154.   ID_TRANSFORMATION BIGINT NOT NULL PRIMARY KEY
  155. , ID_DIRECTORY INT
  156. , NAME VARCHAR(255)
  157. , DESCRIPTION MEDIUMTEXT
  158. , EXTENDED_DESCRIPTION MEDIUMTEXT
  159. , TRANS_VERSION VARCHAR(255)
  160. , TRANS_STATUS INT
  161. , ID_STEP_READ INT
  162. , ID_STEP_WRITE INT
  163. , ID_STEP_INPUT INT
  164. , ID_STEP_OUTPUT INT
  165. , ID_STEP_UPDATE INT
  166. , ID_DATABASE_LOG INT
  167. , TABLE_NAME_LOG VARCHAR(255)
  168. , USE_BATCHID BOOLEAN
  169. , USE_LOGFIELD BOOLEAN
  170. , ID_DATABASE_MAXDATE INT
  171. , TABLE_NAME_MAXDATE VARCHAR(255)
  172. , FIELD_NAME_MAXDATE VARCHAR(255)
  173. , OFFSET_MAXDATE DOUBLE
  174. , DIFF_MAXDATE DOUBLE
  175. , CREATED_USER VARCHAR(255)
  176. , CREATED_DATE DATETIME
  177. , MODIFIED_USER VARCHAR(255)
  178. , MODIFIED_DATE DATETIME
  179. , SIZE_ROWSET INT
  180. )
  181. ;
  182. CREATE TABLE R_TRANS_ATTRIBUTE
  183. (
  184.   ID_TRANS_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  185. , ID_TRANSFORMATION INT
  186. , NR INT
  187. , CODE VARCHAR(255)
  188. , VALUE_NUM BIGINT
  189. , VALUE_STR MEDIUMTEXT
  190. )
  191. ;
  192. CREATE UNIQUE INDEX IDX_TRANS_ATTRIBUTE_LOOKUP ON R_TRANS_ATTRIBUTE(ID_TRANSFORMATION, CODE, NR)
  193. ;
  194. CREATE TABLE R_JOB_ATTRIBUTE
  195. (
  196.   ID_JOB_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  197. , ID_JOB INT
  198. , NR INT
  199. , CODE VARCHAR(255)
  200. , VALUE_NUM BIGINT
  201. , VALUE_STR MEDIUMTEXT
  202. )
  203. ;
  204. CREATE UNIQUE INDEX IDX_JOB_ATTRIBUTE_LOOKUP ON R_JOB_ATTRIBUTE(ID_JOB, CODE, NR)
  205. ;
  206. CREATE TABLE R_DEPENDENCY
  207. (
  208.   ID_DEPENDENCY BIGINT NOT NULL PRIMARY KEY
  209. , ID_TRANSFORMATION INT
  210. , ID_DATABASE INT
  211. , TABLE_NAME VARCHAR(255)
  212. , FIELD_NAME VARCHAR(255)
  213. )
  214. ;
  215. CREATE TABLE R_PARTITION_SCHEMA
  216. (
  217.   ID_PARTITION_SCHEMA BIGINT NOT NULL PRIMARY KEY
  218. , NAME VARCHAR(255)
  219. , DYNAMIC_DEFINITION BOOLEAN
  220. , PARTITIONS_PER_SLAVE VARCHAR(255)
  221. )
  222. ;
  223. CREATE TABLE R_PARTITION
  224. (
  225.   ID_PARTITION BIGINT NOT NULL PRIMARY KEY
  226. , ID_PARTITION_SCHEMA INT
  227. , PARTITION_ID VARCHAR(255)
  228. )
  229. ;
  230. CREATE TABLE R_TRANS_PARTITION_SCHEMA
  231. (
  232.   ID_TRANS_PARTITION_SCHEMA BIGINT NOT NULL PRIMARY KEY
  233. , ID_TRANSFORMATION INT
  234. , ID_PARTITION_SCHEMA INT
  235. )
  236. ;
  237. CREATE TABLE R_CLUSTER
  238. (
  239.   ID_CLUSTER BIGINT NOT NULL PRIMARY KEY
  240. , NAME VARCHAR(255)
  241. , BASE_PORT VARCHAR(255)
  242. , SOCKETS_BUFFER_SIZE VARCHAR(255)
  243. , SOCKETS_FLUSH_INTERVAL VARCHAR(255)
  244. , SOCKETS_COMPRESSED BOOLEAN
  245. , DYNAMIC_CLUSTER BOOLEAN
  246. )
  247. ;
  248. CREATE TABLE R_SLAVE
  249. (
  250.   ID_SLAVE BIGINT NOT NULL PRIMARY KEY
  251. , NAME VARCHAR(255)
  252. , HOST_NAME VARCHAR(255)
  253. , PORT VARCHAR(255)
  254. , WEB_APP_NAME VARCHAR(255)
  255. , USERNAME VARCHAR(255)
  256. , PASSWORD VARCHAR(255)
  257. , PROXY_HOST_NAME VARCHAR(255)
  258. , PROXY_PORT VARCHAR(255)
  259. , NON_PROXY_HOSTS VARCHAR(255)
  260. , MASTER BOOLEAN
  261. )
  262. ;
  263. CREATE TABLE R_CLUSTER_SLAVE
  264. (
  265.   ID_CLUSTER_SLAVE BIGINT NOT NULL PRIMARY KEY
  266. , ID_CLUSTER INT
  267. , ID_SLAVE INT
  268. )
  269. ;
  270. CREATE TABLE R_TRANS_SLAVE
  271. (
  272.   ID_TRANS_SLAVE BIGINT NOT NULL PRIMARY KEY
  273. , ID_TRANSFORMATION INT
  274. , ID_SLAVE INT
  275. )
  276. ;
  277. CREATE TABLE R_TRANS_CLUSTER
  278. (
  279.   ID_TRANS_CLUSTER BIGINT NOT NULL PRIMARY KEY
  280. , ID_TRANSFORMATION INT
  281. , ID_CLUSTER INT
  282. )
  283. ;
  284. CREATE TABLE R_TRANS_HOP
  285. (
  286.   ID_TRANS_HOP BIGINT NOT NULL PRIMARY KEY
  287. , ID_TRANSFORMATION INT
  288. , ID_STEP_FROM INT
  289. , ID_STEP_TO INT
  290. , ENABLED BOOLEAN
  291. )
  292. ;
  293. CREATE TABLE R_TRANS_STEP_CONDITION
  294. (
  295.   ID_TRANSFORMATION INT
  296. , ID_STEP INT
  297. , ID_CONDITION INT
  298. )
  299. ;
  300. CREATE TABLE R_CONDITION
  301. (
  302.   ID_CONDITION BIGINT NOT NULL PRIMARY KEY
  303. , ID_CONDITION_PARENT INT
  304. , NEGATED BOOLEAN
  305. , OPERATOR VARCHAR(255)
  306. , LEFT_NAME VARCHAR(255)
  307. , CONDITION_FUNCTION VARCHAR(255)
  308. , RIGHT_NAME VARCHAR(255)
  309. , ID_VALUE_RIGHT INT
  310. )
  311. ;
  312. CREATE TABLE R_VALUE
  313. (
  314.   ID_VALUE BIGINT NOT NULL PRIMARY KEY
  315. , NAME VARCHAR(255)
  316. , VALUE_TYPE VARCHAR(255)
  317. , VALUE_STR VARCHAR(255)
  318. , IS_NULL BOOLEAN
  319. )
  320. ;
  321. CREATE TABLE R_STEP_TYPE
  322. (
  323.   ID_STEP_TYPE BIGINT NOT NULL PRIMARY KEY
  324. , CODE VARCHAR(255)
  325. , DESCRIPTION VARCHAR(255)
  326. , HELPTEXT VARCHAR(255)
  327. )
  328. ;
  329. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (1,'AccessInput','Access 输入','Read data from a Microsoft Access file');
  330. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (2,'AccessOutput','Access 输出','Stores records into an MS-Access database table.');
  331. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (3,'AvroInput','Avro Input','Reads data from an Avro file');
  332. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (4,'CassandraInput','Cassandra Input','Reads data from a Cassandra table');
  333. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (5,'CassandraOutput','Cassandra Output','Writes to a Cassandra table');
  334. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (6,'ClosureGenerator','Closure Generator','This step allows you to generates a closure table using parent-child relationships.');
  335. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (7,'ConcatFields','Concat Fields','Concat fields together into a new field (similar to the Text File Output step)');
  336. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (8,'CouchDbInput','CouchDb Input','Reads from a Couch DB view');
  337. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (9,'CsvInput','CSV文件输入','Simple CSV file input');
  338. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (10,'CubeInput','Cube 文件输入','从一个cube读取记录.');
  339. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (11,'CubeOutput','Cube输出','把数据写入一个cube');
  340. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (12,'TypeExitEdi2XmlStep','Edi to XML','Converts Edi text to generic XML');
  341. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (13,'ElasticSearchBulk','ElasticSearch 批量加载','Performs bulk inserts into ElasticSearch');
  342. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (14,'ShapeFileReader','ESRI Shapefile Reader','Reads shape file data from an ESRI shape file and linked DBF file');
  343. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (15,'MetaInject','ETL元数据注入','This step allows you to inject metadata into an existing transformation prior to execution.  This allows for the creation of dynamic and highly flexible data integration solutions.');
  344. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (16,'DummyPlugin','Example plugin','This is an example for a plugin test step');
  345. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (17,'ExcelInput','Excel输入','从一个微软的Excel文件里读取数据. 兼容Excel 95, 97 and 2000.');
  346. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (18,'ExcelOutput','Excel输出','Stores records into an Excel (XLS) document with formatting information.');
  347. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (19,'GetSlaveSequence','Get ID from slave server','Retrieves unique IDs in blocks from a slave server.  The referenced sequence needs to be configured on the slave server in the XML configuration file.');
  348. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (20,'TypeExitGoogleAnalyticsInputStep','Google Analytics 输入','Fetches data from google analytics account');
  349. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (21,'GPLoad','Greenplum Load','Greenplum Load');
  350. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (22,'GPBulkLoader','Greenplum 批量加载','Greenplum Bulk Loader');
  351. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (23,'ParallelGzipCsvInput','GZIP CSV Input','Parallel GZIP CSV file input reader');
  352. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (24,'HadoopFileInputPlugin','Hadoop File Input','Process files from an HDFS location');
  353. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (25,'HadoopFileOutputPlugin','Hadoop File Output','Create files in an HDFS location');
  354. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (26,'HBaseInput','HBase Input','Reads data from a HBase table according to a mapping');
  355. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (27,'HBaseOutput','HBase Output','Writes data to an HBase table according to a mapping');
  356. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (28,'HBaseRowDecoder','HBase Row Decoder','Decodes an incoming key and HBase result object according to a mapping');
  357. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (29,'HL7Input','HL7 Input','Reads and parses HL7 messages and outputs a series of values from the messages');
  358. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (30,'HTTP','HTTP client','Call a web service over HTTP by supplying a base URL by allowing parameters to be set dynamically');
  359. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (31,'HTTPPOST','HTTP Post','Call a web service request over HTTP by supplying a base URL by allowing parameters to be set dynamically');
  360. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (32,'InfobrightOutput','Infobright 批量加载','Load data to an Infobright database table');
  361. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (33,'VectorWiseBulkLoader','Ingres VectorWise 批量加载','This step interfaces with the Ingres VectorWise Bulk Loader "COPY TABLE" command.');
  362. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (34,'UserDefinedJavaClass','Java 代码','This step allows you to program a step using Java code');
  363. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (35,'ScriptValueMod','JavaScript代码','This is a modified plugin for the Scripting Values with improved interface and performance.\nWritten & donated to open source by Martin Lange, Proconis : http://www.proconis.de');
  364. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (36,'JsonInput','Json 输入','Extract relevant portions out of JSON structures (file or incoming field) and output rows');
  365. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (37,'JsonOutput','Json 输出','Create Json bloc and output it in a field ou a file.');
  366. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (38,'LDAPInput','LDAP 输入','Read data from LDAP host');
  367. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (39,'LDAPOutput','LDAP 输出','Perform Insert, upsert, update, add or delete operations on records based on their DN (Distinguished  Name).');
  368. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (40,'LDIFInput','LDIF 输入','Read data from LDIF files');
  369. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (41,'LucidDBBulkLoader','LucidDB 批量加载','Load data into LucidDB by using their bulk load command in streaming mode. (Doesnt work on Windows!)');
  370. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (42,'LucidDBStreamingLoader','LucidDB 流加载','Load data into LucidDB by using Remote Rows UDX.');
  371. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (43,'HadoopEnterPlugin','MapReduce Input','Enter a Hadoop Mapper or Reducer transformation');
  372. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (44,'HadoopExitPlugin','MapReduce Output','Exit a Hadoop Mapper or Reducer transformation');
  373. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (45,'TypeExitExcelWriterStep','Microsoft Excel 输出','Writes or appends data to an Excel file');
  374. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (46,'MondrianInput','Mondrian 输入','Execute and retrieve data using an MDX query against a Pentaho Analyses OLAP server (Mondrian)');
  375. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (47,'MonetDBAgileMart','MonetDB Agile Mart','Load data into MonetDB for Agile BI use cases');
  376. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (48,'MonetDBBulkLoader','MonetDB 批量加载','Load data into MonetDB by using their bulk load command in streaming mode.');
  377. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (49,'MongoDbInput','MongoDB Input','Reads from a Mongo DB collection');
  378. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (50,'MongoDbOutput','MongoDB Output','Writes to a Mongo DB collection');
  379. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (51,'MultiwayMergeJoin','Multiway Merge Join','Multiway Merge Join');
  380. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (52,'MySQLBulkLoader','MySQL 批量加载','MySQL bulk loader step, loading data over a named pipe (not available on MS Windows)');
  381. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (53,'OlapInput','OLAP 输入','Execute and retrieve data using an MDX query against any XML/A OLAP datasource using olap4j');
  382. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (54,'OpenERPObjectDelete','OpenERP Object Delete','Deletes OpenERP objects');
  383. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (55,'OpenERPObjectInput','OpenERP Object Input','Reads data from OpenERP objects');
  384. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (56,'OpenERPObjectOutputImport','OpenERP Object Output','Writes data into OpenERP objects using the object import procedure');
  385. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (57,'OraBulkLoader','Oracle 批量加载','Use Oracle Bulk Loader to load data');
  386. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (58,'PaloCellInput','Palo Cell Input','Reads data from a defined Palo Cube ');
  387. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (59,'PaloCellOutput','Palo Cell Output','Writes data to a defined Palo Cube');
  388. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (60,'PaloDimInput','Palo Dim Input','Reads data from a defined Palo Dimension');
  389. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (61,'PaloDimOutput','Palo Dim Output','Writes data to defined Palo Dimension');
  390. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (62,'PentahoReportingOutput','Pentaho 报表输出','Executes an existing report (PRPT)');
  391. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (63,'PGPDecryptStream','PGP Decrypt stream','Decrypt data stream with PGP');
  392. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (64,'PGPEncryptStream','PGP Encrypt stream','Encrypt data stream with PGP');
  393. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (65,'PGBulkLoader','PostgreSQL 批量加载','PostgreSQL Bulk Loader');
  394. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (66,'Rest','REST Client','Consume RESTfull services.\nREpresentational State Transfer (REST) is a key design idiom that embraces a stateless client-server\narchitecture in which the web services are viewed as resources and can be identified by their URLs');
  395. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (67,'RssInput','RSS 输入','Read RSS feeds');
  396. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (68,'RssOutput','RSS 输出','Read RSS stream.');
  397. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (69,'RuleAccumulator','Rule Accumulator','Execute a rule against a set of all incoming rows');
  398. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (70,'RuleExecutor','Rule Executor','Execute a rule against each row or a set of rows');
  399. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (71,'S3CSVINPUT','S3 CSV 输入','S3 CSV 输入');
  400. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (72,'S3FileOutputPlugin','S3 File Output','Create files in an S3 location');
  401. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (73,'SalesforceUpsert','Salesforce Upsert','Insert or update records in Salesforce module.');
  402. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (74,'SalesforceDelete','Salesforce 删除','Delete records in Salesforce module.');
  403. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (75,'SalesforceInsert','Salesforce 插入','Insert records in Salesforce module.');
  404. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (76,'SalesforceUpdate','Salesforce 更新','Update records in Salesforce module.');
  405. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (77,'SalesforceInput','Salesforce 输入','!BaseStep.TypeTooltipDesc.SalesforceInput!');
  406. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (78,'SapInput','SAP 输入','Read data from SAP ERP, optionally with parameters');
  407. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (79,'SASInput','SAS 输入','This step reads files in sas7bdat (SAS) native format');
  408. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (80,'Script','Script','Calculate values by scripting in Ruby, Python, Groovy, JavaScript, ... (JSR-223)');
  409. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (81,'SFTPPut','SFTP Put','Upload a file or a stream file to remote host via SFTP');
  410. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (82,'SimpleMapping','Simple Mapping (sub-transformation)','Run a mapping (sub-transformation), use MappingInput and MappingOutput to specify the fields interface.  This is the simplified version only allowing one input and one output data set.');
  411. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (83,'SingleThreader','Single Threader','Executes a transformation snippet in a single thread.  You need a standard mapping or a transformation with an Injector step where data from the parent transformation will arive in blocks.');
  412. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (84,'SocketWriter','Socket 写','Socket writer.  A socket server that can send rows of data to a socket reader.');
  413. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (85,'SocketReader','Socket 读','Socket reader.  A socket client that connects to a server (Socket Writer step).');
  414. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (86,'SQLFileOutput','SQL 文件输出','Output SQL INSERT statements to file');
  415. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (87,'SSTableOutput','SSTable Output','Writes to a filesystem directory as a Cassandra SSTable');
  416. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (88,'SwitchCase','Switch / Case','Switch a row to a certain target step based on the case value in a field.');
  417. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (89,'TableAgileMart','Table Agile Mart','Load data into a table for Agile BI use cases');
  418. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (90,'TeraFast','Teradata Fastload 批量加载','The Teradata Fastload Bulk loader');
  419. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (91,'TransExecutor','Transformation Executor','This step executes a Pentaho Data Integration transformation, sets parameters and passes rows.');
  420. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (92,'WebServiceLookup','Web 服务查询','使用 Web 服务查询信息');
  421. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (93,'XBaseInput','XBase输入','从一个XBase类型的文件(DBF)读取记录');
  422. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (94,'getXMLData','XML 文件输入','Get data from XML file by using XPath.\n This step also allows you to parse XML defined in a previous field.');
  423. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (95,'XMLInputStream','XML 文件输入 (StAX解析)','This step is capable of processing very large and complex XML files very fast.');
  424. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (96,'XMLInputSax','XML 流输入','Read data from an XML file in a streaming fashing, working faster and consuming less memory');
  425. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (97,'XMLJoin','XML 连接','Joins a stream of XML-Tags into a target XML string');
  426. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (98,'XMLInput','XML输入','从一个XML读取数据');
  427. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (99,'XMLOutput','XML输出','写数据到一个XML文件');
  428. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (100,'XSLT','XSL 转换','Transform XML stream using XSL (eXtensible Stylesheet Language).');
  429. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (101,'YamlInput','Yaml 输入','Read YAML source (file or stream) parse them and convert them to rows and writes these to one or more output. ');
  430. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (102,'ZipFile','Zip 文件','Zip a file.\nFilename will be extracted from incoming stream.');
  431. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (103,'Abort','中止','Abort a transformation');
  432. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (104,'FilesFromResult','从结果获取文件','This step allows you to read filenames used or generated in a previous entry in a job.');
  433. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (105,'RowsFromResult','从结果获取记录','这个允许你从同一个任务的前一个条目里读取记录.');
  434. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (106,'XSDValidator','使用 XSD 检验 XML 文件','Validate XML source (files or streams) against XML Schema Definition.');
  435. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (107,'ValueMapper','值映射','Maps values of a certain field from one value to another');
  436. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (108,'CloneRow','克隆行','Clone a row as many times as needed');
  437. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (109,'Formula','公式','使用 Pentaho 的公式库来计算公式');
  438. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (110,'WriteToLog','写日志','Write data to log');
  439. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (111,'AnalyticQuery','分析查询','Execute analytic queries over a sorted dataset (LEAD/LAG/FIRST/LAST)');
  440. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (112,'GroupBy','分组','以分组的形式创建聚合.{0}这个仅仅在一个已经排好序的输入有效.{1}如果输入没有排序, 仅仅两个连续的记录行被正确处理.');
  441. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (113,'SplitFieldToRows3','列拆分为多行','Splits a single string field by delimiter and creates a new row for each split term');
  442. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (114,'Denormaliser','列转行','Denormalises rows by looking up key-value pairs and by assigning them to new fields in the输出 rows.{0}This method aggregates and needs the输入 rows to be sorted on the grouping fields');
  443. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (115,'Delete','删除','基于关键字删除记录');
  444. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (116,'Janino','利用Janino计算Java表达式','Calculate the result of a Java Expression using Janino');
  445. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (117,'StringCut','剪切字符串','Strings cut (substring).');
  446. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (118,'UnivariateStats','单变量统计','This step computes some simple stats based on a single input field');
  447. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (119,'Unique','去除重复记录','去除重复的记录行,保持记录唯一{0}这个仅仅基于一个已经排好序的输入.{1}如果输入没有排序, 仅仅两个连续的记录行被正确处理.');
  448. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (120,'SyslogMessage','发送信息至Syslog','Send message to Syslog server');
  449. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (121,'Mail','发送邮件','Send eMail.');
  450. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (122,'MergeRows','合并记录','合并两个数据流, 并根据某个关键字排序.  这两个数据流被比较,以标识相等的、变更的、删除的和新建的记录.');
  451. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (123,'ExecProcess','启动一个进程','Execute a process and return the result');
  452. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (124,'UniqueRowsByHashSet','唯一行 (哈希值)','Remove double rows and leave only unique occurrences by using a HashSet.');
  453. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (125,'FixedInput','固定宽度文件输入','Fixed file input');
  454. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (126,'MemoryGroupBy','在内存中分组','Builds aggregates in a group by fashion.\nThis step doesn\'t require sorted input.');
  455. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (127,'AddXML','增加XML列','Encode several fields into an XML fragment');
  456. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (128,'Constant','增加常量','给记录增加一到多个常量');
  457. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (129,'Sequence','增加序列','从序列获取下一个值');
  458. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (130,'CheckSum','增加校验列','Add a checksum column for each input row');
  459. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (131,'ProcessFiles','处理文件','Process one file per row (copy or move or delete).\nThis step only accept filename in input.');
  460. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (132,'FilesToResult','复制文件到结果','This step allows you to set filenames in the result of this transformation.\nSubsequent job entries can then use this information.');
  461. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (133,'RowsToResult','复制记录到结果','使用这个步骤把记录写到正在执行的任务.{0}信息将会被传递给同一个任务里的下一个条目.');
  462. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (134,'SelectValues','字段选择','选择或移除记录里的字。{0}此外,可以设置字段的元数据: 类型, 长度和精度.');
  463. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (135,'StringOperations','字符串操作','Apply certain operations like trimming, padding and others to string value.');
  464. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (136,'ReplaceString','字符串替换','Replace all occurences a word in a string with another word.');
  465. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (137,'SymmetricCryptoTrans','对称加密','Encrypt or decrypt a string using symmetric encryption.\nAvailable algorithms are DES, AEC, TripleDES.');
  466. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (138,'SetValueConstant','将字段值设置为常量','Set value of a field to a constant');
  467. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (139,'Delay','延迟行','Output each input row after a delay');
  468. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (140,'DynamicSQLRow','执行Dynamic SQL','Execute dynamic SQL statement build in a previous field');
  469. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (141,'ExecSQL','执行SQL脚本','执行一个SQL脚本, 另外,可以使用输入的记录作为参数');
  470. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (142,'ExecSQLRow','执行SQL脚本(字段流替换)','Execute SQL script extracted from a field\ncreated in a previous step.');
  471. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (143,'JobExecutor','执行作业','This step executes a Pentaho Data Integration job, sets parameters and passes rows.');
  472. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (144,'FieldSplitter','拆分字段','当你想把一个字段拆分成多个时,使用这个类型.');
  473. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (145,'SortedMerge','排序合并','Sorted Merge');
  474. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (146,'SortRows','排序记录','基于字段值把记录排序(升序或降序)');
  475. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (147,'InsertUpdate','插入 / 更新','基于关键字更新或插入记录到数据库.');
  476. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (148,'ChangeFileEncoding','改变文件编码','Change file encoding and create a new file');
  477. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (149,'NumberRange','数值范围','Create ranges based on numeric field');
  478. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (150,'SynchronizeAfterMerge','数据同步','This step perform insert/update/delete in one go based on the value of a field. ');
  479. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (151,'DBLookup','数据库查询','使用字段值在数据库里查询值');
  480. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (152,'DBJoin','数据库连接','使用数据流里的值作为参数执行一个数据库查询');
  481. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (153,'Validator','数据检验','Validates passing data based on a set of rules');
  482. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (154,'PrioritizeStreams','数据流优先级排序','Prioritize streams in an order way.');
  483. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (155,'ReservoirSampling','数据采样','[Transform] Samples a fixed number of rows from the incoming stream');
  484. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (156,'LoadFileInput','文件内容加载至内存','Load file content in memory');
  485. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (157,'TextFileInput','文本文件输入','从一个文本文件(几种格式)里读取数据{0}这些数据可以被传递到下一个步骤里...');
  486. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (158,'TextFileOutput','文本文件输出','写记录到一个文本文件.');
  487. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (159,'Mapping','映射 (子转换)','运行一个映射 (子转换), 使用MappingInput和MappingOutput来指定接口的字段');
  488. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (160,'MappingInput','映射输入规范','指定一个映射的字段输入');
  489. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (161,'MappingOutput','映射输出规范','指定一个映射的字段输出');
  490. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (162,'Update','更新','基于关键字更新记录到数据库');
  491. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (163,'IfNull','替换NULL值','Sets a field value to a constant if it is null.');
  492. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (164,'SampleRows','样本行','Filter rows based on the line number.');
  493. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (165,'JavaFilter','根据Java代码过滤记录','Filter rows using java code');
  494. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (166,'FieldsChangeSequence','根据字段值来改变序列','Add sequence depending of fields value change.\nEach time value of at least one field change, PDI will reset sequence. ');
  495. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (167,'WebServiceAvailable','检查web服务是否可用','Check if a webservice is available');
  496. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (168,'FileExists','检查文件是否存在','Check if a file exists');
  497. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (169,'FileLocked','检查文件是否已被锁定','Check if a file is locked by another process');
  498. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (170,'TableExists','检查表是否存在','Check if a table exists on a specified connection');
  499. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (171,'ColumnExists','检查表里的列是否存在','Check if a column exists in a table on a specified connection.');
  500. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (172,'DetectEmptyStream','检测空流','This step will output one empty row if input stream is empty\n(ie when input stream does not contain any row)');
  501. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (173,'CreditCardValidator','检验信用卡号码是否有效','The Credit card validator step will help you tell:\n(1) if a credit card number is valid (uses LUHN10 (MOD-10) algorithm)\n(2) which credit card vendor handles that number\n(VISA, MasterCard, Diners Club, EnRoute, American Express (AMEX),...)');
  502. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (174,'MailValidator','检验邮件地址','Check if an email address is valid.');
  503. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (175,'FuzzyMatch','模糊匹配','Finding approximate matches to a string using matching algorithms.\nRead a field from a main stream and output approximative value from lookup stream.');
  504. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (176,'RegexEval','正则表达式','Regular expression Evaluation\nThis step uses a regular expression to evaluate a field. It can also extract new fields out of an existing field with capturing groups.');
  505. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (177,'TableCompare','比较表','Compares 2 tables and gives back a list of differences');
  506. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (178,'StreamLookup','流查询','从转换中的其它流里查询值.');
  507. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (179,'StepMetastructure','流的元数据','This is a step to read the metadata of the incoming stream.');
  508. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (180,'SecretKeyGenerator','生成密钥','Generate secrete key for algorithms such as DES, AEC, TripleDES.');
  509. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (181,'RowGenerator','生成记录','产生一些空记录或相等的行.');
  510. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (182,'RandomValue','生成随机数','Generate random value');
  511. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (183,'RandomCCNumberGenerator','生成随机的信用卡号','Generate random valide (luhn check) credit card numbers');
  512. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (184,'Dummy','空操作 (什么也不做)','这个步骤类型什么都不作.{0} 当你想测试或拆分数据流的时候有用.');
  513. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (185,'DimensionLookup','维度查询/更新','在一个数据仓库里更新一个渐变维 {0} 或者在这个维里查询信息.');
  514. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (186,'CombinationLookup','联合查询/更新','更新数据仓库里的一个junk维 {0} 可选的, 科研查询维里的信息.{1}junk维的主键是所有的字段.');
  515. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (187,'AggregateRows','聚合记录','这个步骤类型允许你聚合记录.{0}它不能使用在分组的情况.');
  516. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (188,'AutoDoc','自动文档输出','This step automatically generates documentation based on input in the form of a list of transformations and jobs');
  517. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (189,'DataGrid','自定义常量数据','Enter rows of static data in a grid, usually for testing, reference or demo purpose');
  518. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (190,'GetPreviousRowField','获取上一次的记录','Get fields value of previous row.');
  519. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (191,'GetVariable','获取变量','Determine the values of certain (environment or Kettle) variables and put them in field values.');
  520. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (192,'GetSubFolders','获取子目录名','Read a parent folder and return all subfolders');
  521. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (193,'GetFileNames','获取文件名','Get file names from the operating system and send them to the next step.');
  522. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (194,'GetFilesRowsCount','获取文件行数','Returns rows count for text files.');
  523. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (195,'SystemInfo','获取系统信息','获取系统信息,例如时间、日期.');
  524. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (196,'GetTableNames','获取表名','Get table names from database connection and send them to the next step');
  525. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (197,'GetRepositoryNames','获取资源库配置','Lists detailed information about transformations and/or jobs in a repository');
  526. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (198,'Flattener','行扁平化','Flattens consequetive rows based on the order in which they appear in the输入 stream');
  527. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (199,'Normaliser','行转列','De-normalised information can be normalised using this step type.');
  528. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (200,'TableInput','表输入','从数据库表里读取信息.');
  529. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (201,'TableOutput','表输出','写信息到一个数据库表');
  530. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (202,'Calculator','计算器','通过执行简单的计算创建一个新字段');
  531. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (203,'JoinRows','记录关联 (笛卡尔输出)','这个步骤的输出是输入流的笛卡尔的结果.{0} 输出结果的记录数是输入流记录之间的乘积.');
  532. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (204,'Injector','记录注射','Injector step to allow to inject rows into the transformation through the java API');
  533. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (205,'MergeJoin','记录集连接','Joins two streams on a given key and outputs a joined set. The input streams must be sorted on the join key');
  534. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (206,'NullIf','设置值为NULL','如果一个字段值等于某个固定值,那么把这个字段值设置成null');
  535. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (207,'SetVariable','设置变量','Set environment variables based on a single input row.');
  536. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (208,'SetValueField','设置字段值','Set value of a field with another value field');
  537. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (209,'DetectLastRow','识别流的最后一行','Last row will be marked');
  538. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (210,'DBProc','调用DB存储过程','通过调用数据库存储过程获得返回值.');
  539. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (211,'StepsMetrics','转换步骤信息统计','Return metrics for one or several steps');
  540. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (212,'FilterRows','过滤记录','使用简单的相等来过滤记录');
  541. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (213,'SSH','运行SSH命令','Run SSH commands and returns result.');
  542. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (214,'Append','追加流','Append 2 streams in an ordered way');
  543. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (215,'MailInput','邮件信息输入','Read POP3/IMAP server and retrieve messages');
  544. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (216,'PropertyInput','配置文件输入','Read data (key, value) from properties files.');
  545. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (217,'PropertyOutput','配置文件输出','Write data to properties file');
  546. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (218,'BlockingStep','阻塞数据','This step blocks until all incoming rows have been processed.  Subsequent steps only recieve the last input row to this step.');
  547. INSERT INTO R_STEP_TYPE(ID_STEP_TYPE, CODE, DESCRIPTION, HELPTEXT) VALUES (219,'BlockUntilStepsFinish','阻塞数据直到步骤都完成','Block this step until selected steps finish.');
  548. CREATE TABLE R_STEP
  549. (
  550.   ID_STEP BIGINT NOT NULL PRIMARY KEY
  551. , ID_TRANSFORMATION INT
  552. , NAME VARCHAR(255)
  553. , DESCRIPTION MEDIUMTEXT
  554. , ID_STEP_TYPE INT
  555. , DISTRIBUTE BOOLEAN
  556. , COPIES INT
  557. , GUI_LOCATION_X INT
  558. , GUI_LOCATION_Y INT
  559. , GUI_DRAW BOOLEAN
  560. , COPIES_STRING VARCHAR(255)
  561. )
  562. ;
  563. CREATE TABLE R_STEP_ATTRIBUTE
  564. (
  565.   ID_STEP_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  566. , ID_TRANSFORMATION INT
  567. , ID_STEP INT
  568. , NR INT
  569. , CODE VARCHAR(255)
  570. , VALUE_NUM BIGINT
  571. , VALUE_STR MEDIUMTEXT
  572. )
  573. ;
  574. CREATE UNIQUE INDEX IDX_R_STEP_ATTRIBUTE_LOOKUP ON R_STEP_ATTRIBUTE(ID_STEP, CODE, NR)
  575. ;
  576. CREATE TABLE R_STEP_DATABASE
  577. (
  578.   ID_TRANSFORMATION INT
  579. , ID_STEP INT
  580. , ID_DATABASE INT
  581. )
  582. ;
  583. CREATE INDEX IDX_R_STEP_DATABASE_LU1 ON R_STEP_DATABASE(ID_TRANSFORMATION)
  584. ;
  585. CREATE INDEX IDX_R_STEP_DATABASE_LU2 ON R_STEP_DATABASE(ID_DATABASE)
  586. ;
  587. CREATE TABLE R_TRANS_NOTE
  588. (
  589.   ID_TRANSFORMATION INT
  590. , ID_NOTE INT
  591. )
  592. ;
  593. CREATE TABLE R_LOGLEVEL
  594. (
  595.   ID_LOGLEVEL BIGINT NOT NULL PRIMARY KEY
  596. , CODE VARCHAR(255)
  597. , DESCRIPTION VARCHAR(255)
  598. )
  599. ;
  600. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (1,'Error','错误日志');
  601. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (2,'Minimal','最小日志');
  602. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (3,'Basic','基本日志');
  603. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (4,'Detailed','详细日志');
  604. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (5,'Debug','调试');
  605. INSERT INTO R_LOGLEVEL(ID_LOGLEVEL, CODE, DESCRIPTION) VALUES (6,'Rowlevel','行级日志(非常详细)');
  606. CREATE TABLE R_LOG
  607. (
  608.   ID_LOG BIGINT NOT NULL PRIMARY KEY
  609. , NAME VARCHAR(255)
  610. , ID_LOGLEVEL INT
  611. , LOGTYPE VARCHAR(255)
  612. , FILENAME VARCHAR(255)
  613. , FILEEXTENTION VARCHAR(255)
  614. , ADD_DATE BOOLEAN
  615. , ADD_TIME BOOLEAN
  616. , ID_DATABASE_LOG INT
  617. , TABLE_NAME_LOG VARCHAR(255)
  618. )
  619. ;
  620. CREATE TABLE R_JOB
  621. (
  622.   ID_JOB BIGINT NOT NULL PRIMARY KEY
  623. , ID_DIRECTORY INT
  624. , NAME VARCHAR(255)
  625. , DESCRIPTION MEDIUMTEXT
  626. , EXTENDED_DESCRIPTION MEDIUMTEXT
  627. , JOB_VERSION VARCHAR(255)
  628. , JOB_STATUS INT
  629. , ID_DATABASE_LOG INT
  630. , TABLE_NAME_LOG VARCHAR(255)
  631. , CREATED_USER VARCHAR(255)
  632. , CREATED_DATE DATETIME
  633. , MODIFIED_USER VARCHAR(255)
  634. , MODIFIED_DATE DATETIME
  635. , USE_BATCH_ID BOOLEAN
  636. , PASS_BATCH_ID BOOLEAN
  637. , USE_LOGFIELD BOOLEAN
  638. , SHARED_FILE VARCHAR(255)
  639. )
  640. ;
  641. CREATE TABLE R_JOBENTRY_DATABASE
  642. (
  643.   ID_JOB INT
  644. , ID_JOBENTRY INT
  645. , ID_DATABASE INT
  646. )
  647. ;
  648. CREATE INDEX IDX_R_JOBENTRY_DATABASE_LU1 ON R_JOBENTRY_DATABASE(ID_JOB)
  649. ;
  650. CREATE INDEX IDX_R_JOBENTRY_DATABASE_LU2 ON R_JOBENTRY_DATABASE(ID_DATABASE)
  651. ;
  652. CREATE TABLE R_JOBENTRY_TYPE
  653. (
  654.   ID_JOBENTRY_TYPE BIGINT NOT NULL PRIMARY KEY
  655. , CODE VARCHAR(255)
  656. , DESCRIPTION VARCHAR(255)
  657. )
  658. ;
  659. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (1,'EMRJobExecutorPlugin','Amazon EMR Job Executor');
  660. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (2,'HiveJobExecutorPlugin','Amazon Hive Job Executor');
  661. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (3,'DOS_UNIX_CONVERTER','DOS和UNIX之间的文本转换');
  662. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (4,'DTD_VALIDATOR','DTD 验证');
  663. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (5,'DummyJob','Example plugin');
  664. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (6,'FTP_PUT','FTP 上传');
  665. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (7,'FTP','FTP 下载');
  666. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (8,'FTP_DELETE','FTP 删除');
  667. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (9,'FTPS_PUT','FTPS 上传');
  668. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (10,'FTPS_GET','FTPS 下载');
  669. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (11,'HadoopCopyFilesPlugin','Hadoop Copy Files');
  670. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (12,'HadoopJobExecutorPlugin','Hadoop Job Executor');
  671. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (13,'HL7MLLPAcknowledge','HL7 MLLP Acknowledge');
  672. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (14,'HL7MLLPInput','HL7 MLLP Input');
  673. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (15,'HTTP','HTTP');
  674. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (16,'MS_ACCESS_BULK_LOAD','MS Access 批量加载');
  675. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (17,'MYSQL_BULK_LOAD','Mysql 批量加载');
  676. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (18,'OozieJobExecutor','Oozie Job Executor');
  677. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (19,'PALO_CUBE_CREATE','Palo Cube Create');
  678. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (20,'PALO_CUBE_DELETE','Palo Cube Delete');
  679. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (21,'HadoopTransJobExecutorPlugin','Pentaho MapReduce');
  680. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (22,'HadoopPigScriptExecutorPlugin','Pig Script Executor');
  681. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (23,'PING','Ping 一台主机');
  682. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (24,'GET_POP','POP 收信');
  683. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (25,'SFTPPUT','SFTP 上传');
  684. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (26,'SFTP','SFTP 下载');
  685. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (27,'SHELL','Shell');
  686. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (28,'SQL','SQL');
  687. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (29,'MSSQL_BULK_LOAD','SQLServer 批量加载');
  688. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (30,'SqoopExport','Sqoop Export');
  689. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (31,'SqoopImport','Sqoop Import');
  690. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (32,'SSH2_PUT','SSH2 上传');
  691. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (33,'SSH2_GET','SSH2 下载');
  692. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (34,'TALEND_JOB_EXEC','Talend 作业执行');
  693. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (35,'XSD_VALIDATOR','XSD 验证器');
  694. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (36,'XSLT','XSL 转换');
  695. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (37,'ZIP_FILE','Zip 压缩文件');
  696. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (38,'ABORT','中止作业');
  697. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (39,'MYSQL_BULK_FILE','从 Mysql 批量导出到文件');
  698. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (40,'DELETE_RESULT_FILENAMES','从结果文件中删除文件');
  699. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (41,'JOB','作业');
  700. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (42,'EVAL','使用 JavaScript 脚本验证');
  701. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (43,'WRITE_TO_FILE','写入文件');
  702. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (44,'WRITE_TO_LOG','写日志');
  703. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (45,'CREATE_FOLDER','创建一个目录');
  704. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (46,'CREATE_FILE','创建文件');
  705. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (47,'DELETE_FILE','删除一个文件');
  706. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (48,'DELETE_FILES','删除多个文件');
  707. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (49,'DELETE_FOLDERS','删除目录');
  708. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (50,'SNMP_TRAP','发送 SNMP 自陷');
  709. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (51,'SEND_NAGIOS_PASSIVE_CHECK','发送Nagios 被动检查');
  710. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (52,'MAIL','发送邮件');
  711. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (53,'COPY_MOVE_RESULT_FILENAMES','复制/移动结果文件');
  712. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (54,'COPY_FILES','复制文件');
  713. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (55,'EXPORT_REPOSITORY','导出资源库到XML文件');
  714. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (56,'SUCCESS','成功');
  715. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (57,'MSGBOX_INFO','显示消息对话框');
  716. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (58,'XML_WELL_FORMED','检查 XML 文件格式');
  717. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (59,'WEBSERVICE_AVAILABLE','检查web服务是否可用');
  718. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (60,'FILE_EXISTS','检查一个文件是否存在');
  719. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (61,'COLUMNS_EXIST','检查列是否存在');
  720. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (62,'FILES_EXIST','检查多个文件是否存在');
  721. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (63,'CHECK_DB_CONNECTIONS','检查数据库连接');
  722. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (64,'CHECK_FILES_LOCKED','检查文件是否被锁');
  723. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (65,'CONNECTED_TO_REPOSITORY','检查是否连接到资源库');
  724. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (66,'FOLDER_IS_EMPTY','检查目录是否为空');
  725. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (67,'TABLE_EXISTS','检查表是否存在');
  726. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (68,'SIMPLE_EVAL','检验字段的值');
  727. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (69,'FILE_COMPARE','比较文件');
  728. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (70,'FOLDERS_COMPARE','比较目录');
  729. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (71,'ADD_RESULT_FILENAMES','添加文件到结果文件中');
  730. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (72,'TRUNCATE_TABLES','清空表');
  731. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (73,'SPECIAL','特殊作业项');
  732. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (74,'SYSLOG','用 Syslog 发送信息');
  733. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (75,'PGP_ENCRYPT_FILES','用PGP加密文件');
  734. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (76,'PGP_DECRYPT_FILES','用PGP解密文件');
  735. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (77,'PGP_VERIFY_FILES','用PGP验证文件签名');
  736. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (78,'MOVE_FILES','移动文件');
  737. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (79,'DELAY','等待');
  738. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (80,'WAIT_FOR_SQL','等待SQL');
  739. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (81,'WAIT_FOR_FILE','等待文件');
  740. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (82,'UNZIP','解压缩文件');
  741. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (83,'EVAL_FILES_METRICS','计算文件大小或个数');
  742. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (84,'EVAL_TABLE_CONTENT','计算表中的记录数');
  743. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (85,'SET_VARIABLES','设置变量');
  744. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (86,'TRANS','转换');
  745. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (87,'TELNET','远程登录一台主机');
  746. INSERT INTO R_JOBENTRY_TYPE(ID_JOBENTRY_TYPE, CODE, DESCRIPTION) VALUES (88,'MAIL_VALIDATOR','邮件验证');
  747. CREATE TABLE R_JOBENTRY
  748. (
  749.   ID_JOBENTRY BIGINT NOT NULL PRIMARY KEY
  750. , ID_JOB INT
  751. , ID_JOBENTRY_TYPE INT
  752. , NAME VARCHAR(255)
  753. , DESCRIPTION MEDIUMTEXT
  754. )
  755. ;
  756. CREATE TABLE R_JOBENTRY_COPY
  757. (
  758.   ID_JOBENTRY_COPY BIGINT NOT NULL PRIMARY KEY
  759. , ID_JOBENTRY INT
  760. , ID_JOB INT
  761. , ID_JOBENTRY_TYPE INT
  762. , NR INT
  763. , GUI_LOCATION_X INT
  764. , GUI_LOCATION_Y INT
  765. , GUI_DRAW BOOLEAN
  766. , PARALLEL BOOLEAN
  767. )
  768. ;
  769. CREATE TABLE R_JOBENTRY_ATTRIBUTE
  770. (
  771.   ID_JOBENTRY_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  772. , ID_JOB INT
  773. , ID_JOBENTRY INT
  774. , NR INT
  775. , CODE VARCHAR(255)
  776. , VALUE_NUM DOUBLE
  777. , VALUE_STR MEDIUMTEXT
  778. )
  779. ;
  780. CREATE UNIQUE INDEX IDX_R_JOBENTRY_ATTRIBUTE_LOOKUP ON R_JOBENTRY_ATTRIBUTE(ID_JOBENTRY_ATTRIBUTE, CODE, NR)
  781. ;
  782. CREATE TABLE R_JOB_HOP
  783. (
  784.   ID_JOB_HOP BIGINT NOT NULL PRIMARY KEY
  785. , ID_JOB INT
  786. , ID_JOBENTRY_COPY_FROM INT
  787. , ID_JOBENTRY_COPY_TO INT
  788. , ENABLED BOOLEAN
  789. , EVALUATION BOOLEAN
  790. , UNCONDITIONAL BOOLEAN
  791. )
  792. ;
  793. CREATE TABLE R_JOB_NOTE
  794. (
  795.   ID_JOB INT
  796. , ID_NOTE INT
  797. )
  798. ;
  799. CREATE TABLE R_TRANS_LOCK
  800. (
  801.   ID_TRANS_LOCK BIGINT NOT NULL PRIMARY KEY
  802. , ID_TRANSFORMATION INT
  803. , ID_USER INT
  804. , LOCK_MESSAGE MEDIUMTEXT
  805. , LOCK_DATE DATETIME
  806. )
  807. ;
  808. CREATE TABLE R_JOB_LOCK
  809. (
  810.   ID_JOB_LOCK BIGINT NOT NULL PRIMARY KEY
  811. , ID_JOB INT
  812. , ID_USER INT
  813. , LOCK_MESSAGE MEDIUMTEXT
  814. , LOCK_DATE DATETIME
  815. )
  816. ;
  817. CREATE TABLE R_NAMESPACE
  818. (
  819.   ID_NAMESPACE BIGINT NOT NULL PRIMARY KEY
  820. , NAME MEDIUMTEXT
  821. )
  822. ;
  823. CREATE TABLE R_ELEMENT_TYPE
  824. (
  825.   ID_ELEMENT_TYPE BIGINT NOT NULL PRIMARY KEY
  826. , ID_NAMESPACE INT
  827. , NAME MEDIUMTEXT
  828. , DESCRIPTION MEDIUMTEXT
  829. )
  830. ;
  831. CREATE TABLE R_ELEMENT
  832. (
  833.   ID_ELEMENT BIGINT NOT NULL PRIMARY KEY
  834. , ID_ELEMENT_TYPE INT
  835. , NAME MEDIUMTEXT
  836. )
  837. ;
  838. CREATE TABLE R_ELEMENT_ATTRIBUTE
  839. (
  840.   ID_ELEMENT_ATTRIBUTE BIGINT NOT NULL PRIMARY KEY
  841. , ID_ELEMENT INT
  842. , ID_ELEMENT_ATTRIBUTE_PARENT INT
  843. , ATTR_KEY VARCHAR(255)
  844. , ATTR_VALUE MEDIUMTEXT
  845. )
  846. ;
  847. CREATE TABLE R_USER
  848. (
  849.   ID_USER BIGINT NOT NULL PRIMARY KEY
  850. , LOGIN VARCHAR(255)
  851. , PASSWORD VARCHAR(255)
  852. , NAME VARCHAR(255)
  853. , DESCRIPTION VARCHAR(255)
  854. , ENABLED BOOLEAN
  855. )
  856. ;
  857. INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (1,'admin','2be98afc86aa7f2e4cb79ce71da9fa6d4','Administrator','User manager',true);
  858. INSERT INTO R_USER(ID_USER, LOGIN, PASSWORD, NAME, DESCRIPTION, ENABLED) VALUES (2,'guest','2be98afc86aa7f2e4cb79ce77cb97bcce','Guest account','Read-only guest account',true);
复制代码


http://dmer.cn  数据分析论坛,已经更新全部文章和帖子
回复

使用道具 举报

1033

主题

1330

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36809
QQ
 楼主| 发表于 2015-8-22 10:22:09 | 显示全部楼层
相当于在 mysql中间建立一个表格,和对于数据库做配置。类似生成kettle的一个系统库。首先是你需要安装数据库哈
http://dmer.cn  数据分析论坛,已经更新全部文章和帖子
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|关于我们|小黑屋|手机版|Archiver|帮助|DMER 数据分析 ( 蜀ICP备13007024号-2  

GMT+8, 2018-1-24 03:51 , Processed in 0.333072 second(s), 32 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表