Configuring the Hive connector as a source

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.

  1. From the job design canvas, double-click the Hive Connector stage.
  2. Click the Output tab.
  3. Click the Properties tab, and, in the Usage section specify the settings for the read operation.
  4. 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.
  5. Click OK, and then save the job.