SUPPORT / SAMPLES & SAS NOTES
Problem Note 57998: The Serializer/Deserializer (SerDe) for the SAS® Scalable Performance Data (SPD) Engine on HDFS treats VarChar data types as String data types
 |  |  |  |  |
The SAS Scalable Performance Data (SPD) Engine creates SAS® data sets on a Hadoop Distributed File System (HDFS). The Serializer/Deserializer (SerDe) provided by SAS enables read access to these tables directly from Hive.
SAS character variables are stored in Hive as a VarChar data type with the length of the original variable definition. However, when executing a query from Hive, the variable values are presented as a String data type padded with spaces to the full length of the variable.
This means that comparison strings used in the query must also be padded with spaces in order to match the data returned from the SerDe.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Solaris for x64 | 9.4 TS1M3 | |
| Linux for x64 | 9.4 TS1M3 | |||
| HP-UX IPF | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 9.4 TS1M3 | |||
| 64-bit Enabled AIX | 9.4 TS1M3 | |||