SQL Pass-Through Facility Specifics for Impala

Key Information

For general information about this feature, see SQL Pass-Through Facility.

Here are the SQL pass-through facility specifics for the Impala interface.

• The dbms-name is IMPALA.
• The CONNECT statement is required.
• PROC SQL supports multiple connections to Impala. If you use multiple simultaneous connections, you must use the alias argument to identify the different connections. If you do not specify an alias, the default IMPALA alias is used.
• The CONNECT statement database-connection-arguments are identical to its LIBNAME connection options. Additional LIBNAME options that are valid in the CONNECT statement are indicated in SAS/ACCESS LIBNAME Options for Impala.

CONNECT Statement Examples

This example uses the default Impala port.

proc sql;
   connect to impala (user="myusr1" pw="mypwd1" server=hxpduped) schema=myschema;

This example explicitly specifies the default Impala port.

proc sql;
   connect to impala (user="myusr1" pw="mypwd1" server=hxpduped 
   port=21050 schema=myschema schema=default);