To configure a Hive connector stage to read or look up rows in a Hive table or view, you
must specify the source table or view or define a complete SELECT statement.
-
From the job design canvas, double-click the Hive Connector
stage.
-
Click the Output tab.
-
Click the Properties tab, and, in the Usage
section specify the settings for the read operation.
-
Use one of these methods to specify the source of the data:
- Set Generate SQL at runtime to Yes, and then
enter the name of the table or view in the Table name property. Use the
syntax table_name or owner.table_name, where owner is the
owner of the table. If you do not specify an owner, the connector uses the schema that belongs to
the user who is currently connected.
- Set Generate SQL at runtime to No , and then
specify the SELECT statement in the Select statement property.
- Set Generate SQL at runtime to No, and then
enter the fully qualified file name of the file that contains the SQL statement in the Select
statement property. Note that this file must reside on the engine host. If you enter a file name,
you must also set Read select statement from file to
Yes.
-
Click OK, and then save the job.