If a schema is included in a Hadoop library definition in metadata, Hadoop requires the SCHEMA= option in code for in-database processing. The option must be part of the connection string in PROC SQL for in-database processing that uses pass-through logic. 

In SAS^® Data Integration Studio 4.903, the SCHEMA= option is incorrectly omitted. This omission can result in unexpected results or errors during job execution.

The workaround for this issue is to take these steps:

1. On the Code tab of the Properties window for the transformation where the issue occurs, change the selection for the Code generation mode field from Automatic to User written body. 
2. Edit the connection string and add the following missing option:
       SCHEMA=schema-name
3. Click OK to save the changes.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for SAS Management Console 9.4_M5 is available at:

A fix for this issue for Data Integration Studio 4.7_M5 is available at:

A fix for this issue for Data Integration Studio 4.903 is available at:

A fix for this issue for SAS Management Console 9.4_M4 is available at:

A fix for this issue for Data Integration Studio 4.902 is available at: