July 30, 2023

tWritePositionalFields – Docs for ESB 7.x

  2. Talend for ESB Docs
  3. Docs 7.x
  4. tWritePositionalFields – Docs for ESB 7.x

tWritePositionalFields

Converts records into byte arrays.

tWritePositionalFields generates
strings or byte arrays to be used by the output components, such as tKafkaOutput requiring serialized data while tJMSOutput requiring strings. tWritePositionalFields embeds the incoming data into a single column based on
the format you defined for each column of the input flow.

tWritePositionalFields properties for Apache Spark Streaming

These properties are used to configure tWritePositionalFields running in the Spark Streaming Job framework.

The Spark Streaming
tWritePositionalFields component belongs to the Processing family.

The streaming version of this component is available in Talend Real Time Big Data Platform and in
Talend Data Fabric.

Basic settings

Output type

Select the type of the data to be outputted into the target file. The data is
byte arrays if you select byte.

Schema and Edit
Schema

A schema is a row description. It defines the number of fields
(columns) to be processed and passed on to the next component. When you create a Spark
Job, avoid the reserved word line when naming the
fields.

The schema of this component is read-only. You can click
Edit schema to view the schema.

When the output type is String, the read-only single column is messageContent. This column is used to provide strings to the output components
such as tJMSOutput.

When the output type is byte, the read-only single column is serializedValue. This column is used to provide byte arrays to the output
components such as tKafkaOutput.

The output schema and its read-only column can be seen by
clicking the Row > Output link to the
component that follows in the same Job. The schema is displayed in the Basic settings tab of the Component view

Include header

Select this check box to include the column header to the file.

Custom encoding

You may encounter encoding issues when you process the stored data. In that
situation, select this check box to display the Encoding list.

Select the encoding from the list or select Custom
and define it manually. This field is compulsory for database data handling. The
supported encodings depend on the JVM that you are using. For more information, see
https://docs.oracle.com.

Formats

Customize the data format of the positional file for each column
from the input schema.

  • Column: Select the column you
    want to customize.

  • Size: Enter the column size.

  • Padding char: Type in between
    quotes the padding characters used. A space by default.

  • Alignment: Select the appropriate
    alignment parameter.

  • Keep: If the data in the column
    or in the field are too long, select the part you want to keep.

Advanced settings

Advanced separator (for number)

Select this check box to change the separator used for numbers. By default, the thousands separator is a comma (,) and the decimal separator is a period (.).

Usage

Usage rule

This component is used as an intermediate step.

This component, along with the Spark Streaming component Palette it belongs to, appears
only when you are creating a Spark Streaming Job.

Note that in this documentation, unless otherwise explicitly stated, a scenario presents
only Standard Jobs, that is to say traditional
Talend
 data
integration Jobs.

Spark Connection

In the Spark
Configuration tab in the Run
view, define the connection to a given Spark cluster for the whole Job. In
addition, since the Job expects its dependent jar files for execution, you must
specify the directory in the file system to which these jar files are
transferred so that Spark can access these files:

  • Yarn mode (Yarn client or Yarn cluster):

    • When using Google Dataproc, specify a bucket in the
      Google Storage staging bucket
      field in the Spark configuration
      tab.

    • When using HDInsight, specify the blob to be used for Job
      deployment in the Windows Azure Storage
      configuration       area in the Spark
      configuration       tab.

    • When using Altus, specify the S3 bucket or the Azure
      Data Lake Storage for Job deployment in the Spark
      configuration       tab.
    • When using Qubole, add a
      tS3Configuration to your Job to write
      your actual business data in the S3 system with Qubole. Without
      tS3Configuration, this business data is
      written in the Qubole HDFS system and destroyed once you shut
      down your cluster.

    • When using on-premise
      distributions, use the configuration component corresponding
      to the file system your cluster is using. Typically, this
      system is HDFS and so use tHDFSConfiguration.

  • Standalone mode: use the
    configuration component corresponding to the file system your cluster is
    using, such as tHDFSConfiguration or
    tS3Configuration.

    If you are using Databricks without any configuration component present
    in your Job, your business data is written directly in DBFS (Databricks
    Filesystem).

This connection is effective on a per-Job basis.

Related scenarios

No scenario is available for the Spark Streaming version of this component
yet.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 7.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x