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 when you are using one of the Talend solutions with Big Data.
Basic settings
Property Type |
Built-In: You create and store the Repository: You have already created |
||
Use an existing connection |
Select this check box and in the Component List Note that when a Job contains the parent Job and the child Job, Component List presents only the connection components in the same |
||
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:
|
||
Hadoop version |
Select the version of the Hadoop distribution you are using. The available
options vary depending on the component you are using. Along with the evolution of Hadoop, please note the following changes:
|
||
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 |
||
NameNode URI |
Type in the URI of the Hadoop NameNode, the master node of a Hadoop system. For |
||
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 and define it manually. This field is compulsory for database |
||
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 Scenario: Reading data from databases through context-based dynamic connections and Scenario: 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.