teradataml offers various API's that allow users to perform set operations which internally uses Teradata SET operators, to combine similar data sets or find difference of a list of teradataml DataFrames or GeoDataFrames.
The SET operators are similar to the JOINs, the only difference is that JOIN combines the columns from different DataFrames or GeoDataFrames, whereas SET operators combine rows from different DataFrames or GeoDataFrames.
Supported SET operators include:
The data types of the columns which are being used in the SET operators must match.