tFileInputDelimited properties for Apache Spark Batch
These properties are used to configure tFileInputDelimited running in the Spark Batch Job framework.
The Spark Batch
tFileInputDelimited component belongs to the File family.
The component in this framework is available only if you have subscribed to one
of the
Talend
solutions with Big Data.
Basic settings
Define a storage configuration |
Select the configuration component to be used to provide the configuration If you leave this check box clear, the target file system is the local The configuration component to be used must be present in the same Job. For |
Property type |
Either Built-In or Repository. |
Built-In: No property data stored centrally. |
|
Repository: Select the repository file where the The properties are stored centrally under the Hadoop For further information about the Hadoop |
|
Schema and Edit |
A schema is a row description. It defines the number of fields (columns) to Click Edit schema to make changes to the |
Built-In: You create and store the |
|
Repository: You have already created |
|
Folder/File |
Browse to, or enter the path pointing to the data to be used in the file system. If the path you set points to a folder, this component will read all of the files stored in that folder, for example, /user/talend/in; if sub-folders exist, the sub-folders are automatically ignored unless you define the property If you want to specify more than one files or directories in this If the file to be read is a compressed one, enter the file name with
The button for browsing does not work with the Spark Local mode; if you are using the Spark Yarn or the Spark Standalone mode, |
Die on error |
Select the check box to stop the execution of the Job when an error |
Row separator |
The separator used to identify the end of a row. |
Field separator |
Enter character, string or regular expression to separate fields for the transferred |
Header |
Enter the number of rows to be skipped in the beginning of file. |
CSV options |
Select this check box to include CSV specific parameters such as Escape char and Text |
Skip empty rows |
Select this check box to skip the empty rows. |
Advanced settings
Set minimum partitions |
Select this check box to control the number of partitions to be created from the input In the displayed field, enter, without quotation marks, the minimum number of partitions When you want to control the partition number, you can generally set at least as many partitions as |
Custom Encoding |
You may encounter encoding issues when you process the stored data. In that Then select the encoding to be used from the list or select Custom and define it manually. |
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 (.). |
Trim all columns |
Select this check box to remove the leading and trailing whitespaces from all |
Check column to trim |
This table is filled automatically with the schema being used. Select the check |
Check each row structure against |
Select this check box to check whether the total number of columns |
Check date |
Select this check box to check the date format strictly against the input schema. |
Decode String for long, int, short, byte |
Select this check box if any of your numeric types (long, integer, short, or byte type), will |
Usage
Usage rule |
This component is used as a start component and requires an output link.. This component, along with the Spark Batch component Palette it belongs to, appears only Note that in this documentation, unless otherwise |
Spark Connection |
You need to use the Spark Configuration tab in
the Run view to 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:
This connection is effective on a per-Job basis. |