| <?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>0021-row-denormaliser-beam</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>2021/05/31 11:45:59.943</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2021/05/31 11:45:59.943</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <order> |
| <hop> |
| <from>Input data</from> |
| <to>Row denormaliser: colors</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Row denormaliser: colors</from> |
| <to>aggregate results</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>aggregate results</from> |
| <to>/tmp/0021-row-denormaliser-beam.csv</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Input data</name> |
| <type>DataGrid</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <currency/> |
| <decimal/> |
| <set_empty_string>N</set_empty_string> |
| <format/> |
| <group/> |
| <length>-1</length> |
| <name>id</name> |
| <precision>-1</precision> |
| <type>Integer</type> |
| </field> |
| <field> |
| <currency/> |
| <decimal/> |
| <set_empty_string>N</set_empty_string> |
| <format/> |
| <group/> |
| <length>-1</length> |
| <name>colorCode</name> |
| <precision>-1</precision> |
| <type>String</type> |
| </field> |
| <field> |
| <currency/> |
| <decimal/> |
| <set_empty_string>N</set_empty_string> |
| <format/> |
| <group/> |
| <length>-1</length> |
| <name>colorValue</name> |
| <precision>-1</precision> |
| <type>String</type> |
| </field> |
| </fields> |
| <data> |
| <line> |
| <item>1</item> |
| <item>white</item> |
| <item>0xFFFFFF</item> |
| </line> |
| <line> |
| <item>1</item> |
| <item>black</item> |
| <item>0x000000</item> |
| </line> |
| <line> |
| <item>2</item> |
| <item>red</item> |
| <item>0xFF0000</item> |
| </line> |
| <line> |
| <item>2</item> |
| <item>green</item> |
| <item>0x00FF00</item> |
| </line> |
| <line> |
| <item>2</item> |
| <item>blue</item> |
| <item>0X0000FF</item> |
| </line> |
| </data> |
| <attributes/> |
| <GUI> |
| <xloc>128</xloc> |
| <yloc>96</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Row denormaliser: colors</name> |
| <type>Denormaliser</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <field_name>colorValue</field_name> |
| <key_value>white</key_value> |
| <target_aggregation_type>-</target_aggregation_type> |
| <target_length>-1</target_length> |
| <target_name>colorWhite</target_name> |
| <target_precision>-1</target_precision> |
| <target_type>String</target_type> |
| </field> |
| <field> |
| <field_name>colorValue</field_name> |
| <key_value>black</key_value> |
| <target_aggregation_type>-</target_aggregation_type> |
| <target_length>-1</target_length> |
| <target_name>colorBlack</target_name> |
| <target_precision>-1</target_precision> |
| <target_type>String</target_type> |
| </field> |
| <field> |
| <field_name>colorValue</field_name> |
| <key_value>red</key_value> |
| <target_aggregation_type>-</target_aggregation_type> |
| <target_length>-1</target_length> |
| <target_name>colorRed</target_name> |
| <target_precision>-1</target_precision> |
| <target_type>String</target_type> |
| </field> |
| <field> |
| <field_name>colorValue</field_name> |
| <key_value>green</key_value> |
| <target_aggregation_type>-</target_aggregation_type> |
| <target_length>-1</target_length> |
| <target_name>colorGreen</target_name> |
| <target_precision>-1</target_precision> |
| <target_type>String</target_type> |
| </field> |
| <field> |
| <field_name>colorValue</field_name> |
| <key_value>blue</key_value> |
| <target_aggregation_type>-</target_aggregation_type> |
| <target_length>-1</target_length> |
| <target_name>colorBlue</target_name> |
| <target_precision>-1</target_precision> |
| <target_type>String</target_type> |
| </field> |
| </fields> |
| <group> |
| <field> |
| <name>id</name> |
| </field> |
| </group> |
| <key_field>colorCode</key_field> |
| <attributes/> |
| <GUI> |
| <xloc>288</xloc> |
| <yloc>96</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>/tmp/0021-row-denormaliser-beam.csv</name> |
| <type>BeamOutput</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <file_description_name/> |
| <file_prefix>0021-row-denormaliser-beam</file_prefix> |
| <file_suffix>.csv</file_suffix> |
| <output_location>${java.io.tmpdir}/0021/</output_location> |
| <windowed>N</windowed> |
| <attributes/> |
| <GUI> |
| <xloc>688</xloc> |
| <yloc>96</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>aggregate results</name> |
| <type>MemoryGroupBy</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <give_back_row>N</give_back_row> |
| <group> |
| <field> |
| <name>id</name> |
| </field> |
| </group> |
| <fields> |
| <field> |
| <aggregate>colorWhite</aggregate> |
| <subject>colorWhite</subject> |
| <type>FIRST</type> |
| <valuefield/> |
| </field> |
| <field> |
| <aggregate>colorBlack</aggregate> |
| <subject>colorBlack</subject> |
| <type>FIRST</type> |
| <valuefield/> |
| </field> |
| <field> |
| <aggregate>colorRed</aggregate> |
| <subject>colorRed</subject> |
| <type>FIRST</type> |
| <valuefield/> |
| </field> |
| <field> |
| <aggregate>colorGreen</aggregate> |
| <subject>colorGreen</subject> |
| <type>FIRST</type> |
| <valuefield/> |
| </field> |
| <field> |
| <aggregate>colorBlue</aggregate> |
| <subject>colorBlue</subject> |
| <type>FIRST</type> |
| <valuefield/> |
| </field> |
| </fields> |
| <attributes/> |
| <GUI> |
| <xloc>464</xloc> |
| <yloc>96</yloc> |
| </GUI> |
| </transform> |
| <transform_error_handling> |
| </transform_error_handling> |
| <attributes/> |
| </pipeline> |