Set Operations (DB)

Combines results from merging two or more queries into a single result set.

Information at a Glance

Category Transform
Data source type DB
Sends output to other operators Yes
Data processing tool n/a
Note: The Set Operations (DB) operator is for database data only. For Hadoop data, use the Set Operations (HD) operator.

Input

Two or more databases.

Restrictions

  • The number and the order of the columns must be the same in all queries.
  • The data types must be compatible.
Note: Check Operator and Data Source Compatibility Matrix for specific exceptions.

Configuration

Parameter Description
Notes Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator.
Sets Click Define Sets to display the Define Sets dialog box. For more information, see the Define Sets Dialog Box.
Output Type
  • TABLE outputs a database table. Specifying TABLE enables Storage Parameters.
  • VIEW outputs a database view.
Output Schema The schema for the output table or view.
Output Table The table path and name where the results are output. By default, this is a unique table name based on your user ID, workflow ID, and operator.
Storage Parameters Advanced database settings for the operator output. Available only for TABLE output.

See Storage Parameters Dialog Box for more information.

Drop If Exists Specifies whether to overwrite an existing table.
  • Yes - If a table with the name exists, it is dropped before storing the results.
  • No - If a table with the name exists, the results window shows an error message.

Output

Visual Output
The data rows of the output table or view displayed (up to 200 rows).
Data Output
A data set of the output table or view of the joined data sets. This operator always creates a CSV output.
Related reference