tHDFSRowCount
Reads a file in HDFS row by row in order to determine the number of rows this file
contains.
tHDFSRowCount counts the number of rows in a file in
HDFS. If the file to be processed is a Hadoop sequence file type or a large dataset, it
is recommended to use a tAggregateRow to count the records.
tHDFSRowCount Standard properties
These properties are used to configure tHDFSRowCount running in the Standard Job framework.
The Standard
tHDFSRowCount component belongs to the Big Data and the File families.
The component in this framework is available in all Talend products with Big Data
and in Talend Data Fabric.
Basic settings
Property Type |
Built-In: You create and store the schema locally for this component Repository: You have already created the schema and stored it in the |
Use an existing connection |
Select this check box and in the Component List click the HDFS connection component from which Note that when a Job contains the parent Job and the child Job, |
Distribution |
Select the cluster you are using from the drop-down list. The options in the
list vary depending on the component you are using. Among these options, the following ones requires specific configuration:
|
Version |
Select the version of the Hadoop distribution you are using. The available |
Scheme | Select the URI scheme of the file system to be used from the Scheme drop-down list. This scheme could be
The schemes present on this list vary depending on the distribution you Once a scheme is If you have selected
ADLS, the connection parameters to be defined become:
For a |
NameNode URI |
Type in the URI of the Hadoop NameNode, the master node of a |
Use kerberos authentication |
If you are accessing the Hadoop cluster running
with Kerberos security, select this check box, then, enter the Kerberos principal name for the NameNode in the field displayed. This enables you to use your user name to authenticate against the credentials stored in Kerberos.
This check box is available depending on the Hadoop distribution you are |
Use a keytab to authenticate |
Select the Use a keytab to authenticate Note that the user that executes a keytab-enabled Job is not necessarily |
User name |
The User name field is available when you are not using |
Group |
Enter the membership including the authentication user under which the HDFS instances were |
File name |
Browse to, or enter the path pointing to the data to be used in the file system. |
Row separator |
The separator used to identify the end of a row. |
Ignore empty rows |
Select this check box to skip the empty rows. |
Encoding |
Select the encoding from the list or select Custom |
Compression |
Select the Uncompress the data check box to uncompress Hadoop provides different compression formats that help reduce the space needed for |
Advanced settings
Hadoop properties |
Talend Studio uses a default configuration for its engine to perform operations in a Hadoop distribution. If you need to use a custom configuration in a specific situation, complete this table with the property or properties to be customized. Then at runtime, the customized property or properties will override those default ones.
For further information about the properties required by Hadoop and its related systems such
as HDFS and Hive, see the documentation of the Hadoop distribution you are using or see Apache’s Hadoop documentation on http://hadoop.apache.org/docs and then select the version of the documentation you want. For demonstration purposes, the links to some properties are listed below:
|
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a Job level as well as at each component level. |
Global Variables
Global Variables |
COUNT: the number of rows in a file. This is a Flow
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Usage
Usage rule |
tHDFSRowCount is a standalone The valid code for tJava to get
this count could be:
In this example, tHDFSRowCount_1 is the label of this component in a Job, For further information about how to label a component or how to |
||
Dynamic settings |
Click the [+] button to add a row in the The Dynamic settings table is For examples on using dynamic parameters, see Reading data from databases through context-based dynamic connections and Reading data from different MySQL databases using dynamically loaded connection parameters. For more information on Dynamic |
||
Prerequisites |
The Hadoop distribution must be properly installed, so as to guarantee the interaction
For further information about how to install a Hadoop distribution, see the manuals |
||
Limitation |
JRE 1.6+ is required. |
Related scenarios
No scenario is available for the Standard version of this component yet.