This is an automated email from the ASF dual-hosted git repository.
hansva pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hop.git
The following commit(s) were added to refs/heads/master by this push:
new e94d2dd88c updated dynamic sql rows, initial sample version for file
exists and get variables transforms. #2237
new 5a56a13894 Merge pull request #2458 from bamaer/2237
e94d2dd88c is described below
commit e94d2dd88c1bf9839d12ce8a71c82e085f03ae3b
Author: Bart Maertens <[email protected]>
AuthorDate: Wed Feb 22 10:33:34 2023 +0100
updated dynamic sql rows, initial sample version for file exists and get
variables transforms. #2237
---
.../main/samples/transforms/dynamic-sql-row.hpl | 204 ++++++------------
.../main/samples/transforms/file-exists-basic.hpl | 233 +++++++++++++++++++++
.../samples/transforms/get-variables-basic.hpl | 232 ++++++++++++++++++++
3 files changed, 533 insertions(+), 136 deletions(-)
diff --git
a/plugins/transforms/dynamicsqlrow/src/main/samples/transforms/dynamic-sql-row.hpl
b/plugins/transforms/dynamicsqlrow/src/main/samples/transforms/dynamic-sql-row.hpl
index c32f37d4a5..d42f2b253f 100644
---
a/plugins/transforms/dynamicsqlrow/src/main/samples/transforms/dynamic-sql-row.hpl
+++
b/plugins/transforms/dynamicsqlrow/src/main/samples/transforms/dynamic-sql-row.hpl
@@ -36,41 +36,47 @@ limitations under the License.
<modified_date>2023/02/14 20:20:51.940</modified_date>
</info>
<notepads>
+ <notepad>
+ <backgroundcolorblue>251</backgroundcolorblue>
+ <backgroundcolorgreen>232</backgroundcolorgreen>
+ <backgroundcolorred>201</backgroundcolorred>
+ <bordercolorblue>90</bordercolorblue>
+ <bordercolorgreen>58</bordercolorgreen>
+ <bordercolorred>14</bordercolorred>
+ <fontbold>N</fontbold>
+ <fontcolorblue>90</fontcolorblue>
+ <fontcolorgreen>58</fontcolorgreen>
+ <fontcolorred>14</fontcolorred>
+ <fontitalic>N</fontitalic>
+ <fontname>Noto Sans</fontname>
+ <fontsize>10</fontsize>
+ <height>44</height>
+ <xloc>384</xloc>
+ <yloc>128</yloc>
+ <note>get a list of ID columns from the all the tables in the PUBLIC
schema.
+build a query to list of of the available IDs per table</note>
+ <width>393</width>
+ </notepad>
</notepads>
<order>
<hop>
- <from>get initial row_count</from>
- <to>add 4 rows</to>
+ <from>get ID columns</from>
+ <to>build query</to>
<enabled>Y</enabled>
</hop>
<hop>
- <from>add 4 rows</from>
- <to>add counter</to>
- <enabled>Y</enabled>
- </hop>
- <hop>
- <from>add counter</from>
- <to>get sydate</to>
- <enabled>Y</enabled>
- </hop>
- <hop>
- <from>get sydate</from>
- <to>sysdate to string</to>
- <enabled>Y</enabled>
- </hop>
- <hop>
- <from>sysdate to string</from>
- <to>build sql</to>
+ <from>build query</from>
+ <to>Dynamic SQL row</to>
<enabled>Y</enabled>
</hop>
<hop>
- <from>build sql</from>
- <to>Dynamic SQL row</to>
+ <from>Dynamic SQL row</from>
+ <to>keep TABLE_NAME. ID_COL</to>
<enabled>Y</enabled>
</hop>
<hop>
- <from>Dynamic SQL row</from>
- <to>get final row_count</to>
+ <from>keep TABLE_NAME. ID_COL</from>
+ <to>log table_name, id</to>
<enabled>Y</enabled>
</hop>
</order>
@@ -90,39 +96,17 @@ limitations under the License.
<query_only_on_change>N</query_only_on_change>
<replace_vars>N</replace_vars>
<rowlimit>0</rowlimit>
- <sql>insert into PUBLIC.TABLEINPUT values (10, 'N', 'Value 10',
'2023-02-14 20:34:26');</sql>
- <sql_fieldname>sql</sql_fieldname>
- <attributes/>
- <GUI>
- <xloc>848</xloc>
- <yloc>224</yloc>
- </GUI>
- </transform>
- <transform>
- <name>add 4 rows</name>
- <type>CloneRow</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <addcloneflag>N</addcloneflag>
- <addclonenum>N</addclonenum>
- <nrclonefield>ROW_COUNT</nrclonefield>
- <nrcloneinfield>N</nrcloneinfield>
- <nrclones>4</nrclones>
+ <sql>select cast(ID as INT) as id_col, 'DIM_SAMPLE' as table_name from
DIM_SAMPLE;</sql>
+ <sql_fieldname>query</sql_fieldname>
<attributes/>
<GUI>
- <xloc>256</xloc>
- <yloc>112</yloc>
+ <xloc>272</xloc>
+ <yloc>240</yloc>
</GUI>
</transform>
<transform>
- <name>add counter</name>
- <type>Sequence</type>
+ <name>log table_name, id</name>
+ <type>WriteToLog</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
@@ -131,22 +115,27 @@ limitations under the License.
<method>none</method>
<schema_name/>
</partitioning>
- <connection>hop-samples</connection>
- <increment_by>1</increment_by>
- <max_value>999999999</max_value>
- <seqname>SEQ_</seqname>
- <start_at>1</start_at>
- <use_counter>Y</use_counter>
- <use_database>N</use_database>
- <valuename>counter</valuename>
+ <loglevel>log_level_basic</loglevel>
+ <displayHeader>Y</displayHeader>
+ <limitRows>N</limitRows>
+ <limitRowsNumber>0</limitRowsNumber>
+ <logmessage/>
+ <fields>
+ <field>
+ <name>TABLE_NAME</name>
+ </field>
+ <field>
+ <name>ID_COL</name>
+ </field>
+ </fields>
<attributes/>
<GUI>
- <xloc>400</xloc>
- <yloc>112</yloc>
+ <xloc>672</xloc>
+ <yloc>240</yloc>
</GUI>
</transform>
<transform>
- <name>build sql</name>
+ <name>build query</name>
<type>ScriptValueMod</type>
<description/>
<distribute>Y</distribute>
@@ -163,14 +152,13 @@ limitations under the License.
<jsScript_name>Script 1</jsScript_name>
<jsScript_script>//Script here
-var id = ROW_COUNT + counter;
-var sql = "insert into PUBLIC.TABLEINPUT values (" + id + ", 'N', 'Value " +
id + "', '" + sysdate + "');"; </jsScript_script>
+var query = "select cast(" + COLUMN_NAME + " as INT) as id_col, '" +
TABLE_NAME + "' as table_name from " + TABLE_NAME + ";" </jsScript_script>
</jsScript>
</jsScripts>
<fields>
<field>
- <name>sql</name>
- <rename>sql</rename>
+ <name>query</name>
+ <rename>query</rename>
<type>String</type>
<length>-1</length>
<precision>-1</precision>
@@ -179,36 +167,12 @@ var sql = "insert into PUBLIC.TABLEINPUT values (" + id +
", 'N', 'Value " + id
</fields>
<attributes/>
<GUI>
- <xloc>848</xloc>
+ <xloc>272</xloc>
<yloc>112</yloc>
</GUI>
</transform>
<transform>
- <name>get final row_count</name>
- <type>TableInput</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <connection>hop-samples</connection>
- <execute_each_row>N</execute_each_row>
- <limit>0</limit>
- <sql>SELECT count(*) as row_count
-FROM PUBLIC.TABLEINPUT
-</sql>
- <variables_active>N</variables_active>
- <attributes/>
- <GUI>
- <xloc>1040</xloc>
- <yloc>224</yloc>
- </GUI>
- </transform>
- <transform>
- <name>get initial row_count</name>
+ <name>get ID columns</name>
<type>TableInput</type>
<description/>
<distribute>Y</distribute>
@@ -221,8 +185,10 @@ FROM PUBLIC.TABLEINPUT
<connection>hop-samples</connection>
<execute_each_row>N</execute_each_row>
<limit>0</limit>
- <sql>SELECT count(*) as row_count
-FROM PUBLIC.TABLEINPUT
+ <sql>SELECT *
+FROM INFORMATION_SCHEMA.COLUMNS
+WHERE TABLE_SCHEMA = 'PUBLIC'
+ AND COLUMN_NAME = 'ID'
</sql>
<variables_active>N</variables_active>
<attributes/>
@@ -232,8 +198,8 @@ FROM PUBLIC.TABLEINPUT
</GUI>
</transform>
<transform>
- <name>get sydate</name>
- <type>SystemInfo</type>
+ <name>keep TABLE_NAME. ID_COL</name>
+ <type>SelectValues</type>
<description/>
<distribute>Y</distribute>
<custom_distribution/>
@@ -244,51 +210,17 @@ FROM PUBLIC.TABLEINPUT
</partitioning>
<fields>
<field>
- <name>sysdate</name>
- <type>system date (variable)</type>
+ <name>TABLE_NAME</name>
+ </field>
+ <field>
+ <name>ID_COL</name>
</field>
- </fields>
- <attributes/>
- <GUI>
- <xloc>560</xloc>
- <yloc>112</yloc>
- </GUI>
- </transform>
- <transform>
- <name>sysdate to string</name>
- <type>SelectValues</type>
- <description/>
- <distribute>Y</distribute>
- <custom_distribution/>
- <copies>1</copies>
- <partitioning>
- <method>none</method>
- <schema_name/>
- </partitioning>
- <fields>
<select_unspecified>N</select_unspecified>
- <meta>
- <name>sysdate</name>
- <rename>sysdate</rename>
- <type>String</type>
- <length>-2</length>
- <precision>-2</precision>
- <conversion_mask>yyyy-MM-dd HH:mm:ss</conversion_mask>
- <date_format_lenient>false</date_format_lenient>
- <date_format_locale/>
- <date_format_timezone/>
- <lenient_string_to_number>false</lenient_string_to_number>
- <encoding/>
- <decimal_symbol/>
- <grouping_symbol/>
- <currency_symbol/>
- <storage_type/>
- </meta>
</fields>
<attributes/>
<GUI>
- <xloc>704</xloc>
- <yloc>112</yloc>
+ <xloc>480</xloc>
+ <yloc>240</yloc>
</GUI>
</transform>
<transform_error_handling>
diff --git
a/plugins/transforms/fileexists/src/main/samples/transforms/file-exists-basic.hpl
b/plugins/transforms/fileexists/src/main/samples/transforms/file-exists-basic.hpl
new file mode 100644
index 0000000000..08606a9444
--- /dev/null
+++
b/plugins/transforms/fileexists/src/main/samples/transforms/file-exists-basic.hpl
@@ -0,0 +1,233 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+
+-->
+<pipeline>
+ <info>
+ <name>file-exists-basic</name>
+ <name_sync_with_filename>Y</name_sync_with_filename>
+ <description/>
+ <extended_description/>
+ <pipeline_version/>
+ <pipeline_type>Normal</pipeline_type>
+ <parameters>
+ </parameters>
+ <capture_transform_performance>N</capture_transform_performance>
+
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
+
<transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit>
+ <created_user>-</created_user>
+ <created_date>2023/02/22 09:31:08.160</created_date>
+ <modified_user>-</modified_user>
+ <modified_date>2023/02/22 09:31:08.160</modified_date>
+ </info>
+ <notepads>
+ </notepads>
+ <order>
+ <hop>
+ <from>get customers-100.txt filename</from>
+ <to>check if customers-100.txt exists</to>
+ <enabled>Y</enabled>
+ </hop>
+ <hop>
+ <from>generate 1 row</from>
+ <to>get customers-100.txt filename</to>
+ <enabled>Y</enabled>
+ </hop>
+ <hop>
+ <from>check if customers-100.txt exists</from>
+ <to>exists?</to>
+ <enabled>Y</enabled>
+ </hop>
+ <hop>
+ <from>exists?</from>
+ <to>log exists</to>
+ <enabled>Y</enabled>
+ </hop>
+ <hop>
+ <from>exists?</from>
+ <to>log does not exist</to>
+ <enabled>Y</enabled>
+ </hop>
+ </order>
+ <transform>
+ <name>get customers-100.txt filename</name>
+ <type>GetVariable</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <fields>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>filename</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${PROJECT_HOME}/files/customers-100.txt</variable>
+ </field>
+ </fields>
+ <attributes/>
+ <GUI>
+ <xloc>328</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>check if customers-100.txt exists</name>
+ <type>FileExists</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <addresultfilenames>N</addresultfilenames>
+ <filenamefield>filename</filenamefield>
+ <filetypefieldname>file_type</filetypefieldname>
+ <includefiletype>Y</includefiletype>
+ <resultfieldname>result</resultfieldname>
+ <attributes/>
+ <GUI>
+ <xloc>560</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>generate 1 row</name>
+ <type>RowGenerator</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <fields>
+</fields>
+ <interval_in_ms>5000</interval_in_ms>
+ <last_time_field>FiveSecondsAgo</last_time_field>
+ <limit>1</limit>
+ <never_ending>N</never_ending>
+ <row_time_field>now</row_time_field>
+ <attributes/>
+ <GUI>
+ <xloc>96</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>exists?</name>
+ <type>FilterRows</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <compare>
+ <condition>
+ <conditions>
+</conditions>
+ <function>=</function>
+ <leftvalue>result</leftvalue>
+ <negated>N</negated>
+ <operator>-</operator>
+ <value>
+ <isnull>N</isnull>
+ <length>-1</length>
+ <mask/>
+ <name>constant</name>
+ <precision>-1</precision>
+ <text>Y</text>
+ <type>Boolean</type>
+ </value>
+ </condition>
+ </compare>
+ <send_false_to>log does not exist</send_false_to>
+ <send_true_to>log exists</send_true_to>
+ <attributes/>
+ <GUI>
+ <xloc>792</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>log exists</name>
+ <type>WriteToLog</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <loglevel>log_level_basic</loglevel>
+ <displayHeader>Y</displayHeader>
+ <limitRows>N</limitRows>
+ <limitRowsNumber>0</limitRowsNumber>
+ <logmessage/>
+ <fields>
+ </fields>
+ <attributes/>
+ <GUI>
+ <xloc>1024</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>log does not exist</name>
+ <type>WriteToLog</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <loglevel>log_level_basic</loglevel>
+ <displayHeader>Y</displayHeader>
+ <limitRows>N</limitRows>
+ <limitRowsNumber>0</limitRowsNumber>
+ <logmessage/>
+ <fields>
+ </fields>
+ <attributes/>
+ <GUI>
+ <xloc>1024</xloc>
+ <yloc>192</yloc>
+ </GUI>
+ </transform>
+ <transform_error_handling>
+ </transform_error_handling>
+ <attributes/>
+</pipeline>
diff --git
a/plugins/transforms/getvariable/src/main/samples/transforms/get-variables-basic.hpl
b/plugins/transforms/getvariable/src/main/samples/transforms/get-variables-basic.hpl
new file mode 100644
index 0000000000..f420f0be0a
--- /dev/null
+++
b/plugins/transforms/getvariable/src/main/samples/transforms/get-variables-basic.hpl
@@ -0,0 +1,232 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements. See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+
+-->
+<pipeline>
+ <info>
+ <name>get-variables-basic</name>
+ <name_sync_with_filename>Y</name_sync_with_filename>
+ <description/>
+ <extended_description/>
+ <pipeline_version/>
+ <pipeline_type>Normal</pipeline_type>
+ <parameters>
+ </parameters>
+ <capture_transform_performance>N</capture_transform_performance>
+
<transform_performance_capturing_delay>1000</transform_performance_capturing_delay>
+
<transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit>
+ <created_user>-</created_user>
+ <created_date>2023/02/22 10:27:40.052</created_date>
+ <modified_user>-</modified_user>
+ <modified_date>2023/02/22 10:27:40.052</modified_date>
+ </info>
+ <notepads>
+ <notepad>
+ <backgroundcolorblue>251</backgroundcolorblue>
+ <backgroundcolorgreen>232</backgroundcolorgreen>
+ <backgroundcolorred>201</backgroundcolorred>
+ <bordercolorblue>90</bordercolorblue>
+ <bordercolorgreen>58</bordercolorgreen>
+ <bordercolorred>14</bordercolorred>
+ <fontbold>N</fontbold>
+ <fontcolorblue>90</fontcolorblue>
+ <fontcolorgreen>58</fontcolorgreen>
+ <fontcolorred>14</fontcolorred>
+ <fontitalic>N</fontitalic>
+ <fontname>Noto Sans</fontname>
+ <fontsize>10</fontsize>
+ <height>27</height>
+ <xloc>64</xloc>
+ <yloc>32</yloc>
+ <note>get a number of different variables from the current Apache Hop
project, os, java and user environment</note>
+ <width>585</width>
+ </notepad>
+ </notepads>
+ <order>
+ <hop>
+ <from>generate 1 row</from>
+ <to>get variables</to>
+ <enabled>Y</enabled>
+ </hop>
+ <hop>
+ <from>get variables</from>
+ <to>log variable values</to>
+ <enabled>Y</enabled>
+ </hop>
+ </order>
+ <transform>
+ <name>generate 1 row</name>
+ <type>RowGenerator</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <fields>
+</fields>
+ <interval_in_ms>5000</interval_in_ms>
+ <last_time_field>FiveSecondsAgo</last_time_field>
+ <limit>1</limit>
+ <never_ending>N</never_ending>
+ <row_time_field>now</row_time_field>
+ <attributes/>
+ <GUI>
+ <xloc>96</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>get variables</name>
+ <type>GetVariable</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <fields>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>filename</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${PROJECT_HOME}/files/customers-100.txt</variable>
+ </field>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>java_version</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${java.runtime.version}</variable>
+ </field>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>hop_config_folder</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${HOP_CONFIG_FOLDER}</variable>
+ </field>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>hop_platform_os</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${HOP_PLATFORM_OS}</variable>
+ </field>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>user_home</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${user.home}</variable>
+ </field>
+ <field>
+ <currency/>
+ <decimal/>
+ <format/>
+ <group/>
+ <length>-1</length>
+ <name>user_dir</name>
+ <precision>-1</precision>
+ <trim_type>none</trim_type>
+ <type>String</type>
+ <variable>${user.dir}</variable>
+ </field>
+ </fields>
+ <attributes/>
+ <GUI>
+ <xloc>304</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform>
+ <name>log variable values</name>
+ <type>WriteToLog</type>
+ <description/>
+ <distribute>Y</distribute>
+ <custom_distribution/>
+ <copies>1</copies>
+ <partitioning>
+ <method>none</method>
+ <schema_name/>
+ </partitioning>
+ <loglevel>log_level_basic</loglevel>
+ <displayHeader>Y</displayHeader>
+ <limitRows>N</limitRows>
+ <limitRowsNumber>0</limitRowsNumber>
+ <logmessage/>
+ <fields>
+ <field>
+ <name>filename</name>
+ </field>
+ <field>
+ <name>java_version</name>
+ </field>
+ <field>
+ <name>hop_config_folder</name>
+ </field>
+ <field>
+ <name>hop_platform_os</name>
+ </field>
+ <field>
+ <name>user_home</name>
+ </field>
+ <field>
+ <name>user_dir</name>
+ </field>
+ </fields>
+ <attributes/>
+ <GUI>
+ <xloc>512</xloc>
+ <yloc>96</yloc>
+ </GUI>
+ </transform>
+ <transform_error_handling>
+ </transform_error_handling>
+ <attributes/>
+</pipeline>
