SQL Pass-Through Facility Specifics for Hadoop

Key Information

For general information about this feature, see About SQL Procedure Interactions . Hadoop examples are available.

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

The dbms-name is HADOOP.
The CONNECT statement is required.
PROC SQL supports multiple connections to Hadoop. 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 HADOOP alias is used.
The database-connection-arguments for the CONNECT statement are identical to its LIBNAME connection options.

This example uses the default Hive port and schema.

proc sql;
   connect to hadoop (user="myuser" pw="mypwd" server=hxpduped);

This example explicitly specifies the default Hive port and schema.

proc sql;
   connect to hadoop (user="myuser" pw="mypwd" 
      server=hxpduped port=10000 schema=default);