Some directives use
a SAS Server (SAS Workspace Server) to read or write tables. By default,
the character columns for the input tables to such directives will
be expanded to 32K in length. The affected directives are as follows:
-
-
-
-
Copy Data to Hadoop (when a data
set from the SAS Server is selected as the input table)
-
Copy Data from Hadoop (when the
SAS Server is selected as the location for the target table)
For best performance,
we recommend that you reduce the default length of the character columns
for these input tables. Specify a value that is short enough to help
performance but long enough to avoid truncating the data in character
columns. For example, you could use a global option to reduce the
column-length value for all new directive instances. You could use
the advanced options for an individual directive to set a column-length
value for that directive.
If you want to globally
change the Maximum Length for SAS character columns for all new directive
instances, go to the Directives page. Select Configuration from
the Action menu. Select General Preferences from
the Configuration window. Specify the desired
length for SAS character columns.
If you want to change
the Maximum Length for SAS character columns for a specific directive,
go to the Directives page and open an appropriate directive. From
the Source Table step, select Advanced Options from
the Action menu at upper right. Specify the desired length for SAS
character columns.
The only way to change
the Maximum Length for SAS character columns for a specific directive
is to set the appropriate advanced option for that directive. For
example, you cannot change the global default for the Maximum Length
for SAS character columns and have that dynamically applied to existing
directives. The global option applies to new instances of directives
only.