Passing Joins to Impala

In order for a multiple-libref join to be passed to the database, all of these components of the LIBNAME statements must match exactly.

• user ID (USER=)
• password (PASSWORD=)
• port (PORT=)
• schema (SCHEMA=)
• server (SERVER=)
• data source (DSN=, if specified)

You can use the SQL pass-through facility to pass a cross-schema join to your database. For more information about when and how SAS/ACCESS passes joins to the DBMS, see Passing Joins to the DBMS.