Acts on the actual DB structure or on the data without handling data itself, depending on the nature of the query and the database.
tHiveRow executes the HiveQL query stated in the specified database. The row suffix means the component implements a flow in the Job design although it does not provide output.
The SQLBuilder tool helps you write your HiveQL statements easily.
This component can also perform queries in a HBase database once the Store by HBase check box is available and you have selected this check box.
This component is not shipped with your Talend Studio by default. You need to install it using the Feature Manager. For more information, see Installing features using the Feature Manager.
For more technologies supported by Talend, see Talend components.