SUPPORT / SAMPLES & SAS NOTES
Problem Note 63834: SAS/ACCESS® Interface to Hadoop ignores blank values when you use a WHERE clause with the SQL procedure and the option DBIDIRECTEXEC
 |  |  |  |  |
Blank values are ignored when you subset an Apache Hive table with a WHERE clause in a PROC SQL statement with the option DBIDIRECTEXEC enabled.
The following example shows syntax that might return incorrect results from Hive:
option dbidirectexec;
proc sql;
select * from hivelib.table-name where variable = '';
quit;
select * from hivelib.table-name where variable = '';
quit;
To circumvent the problem, use a DATA step that is similar to the following (and update the italicized parts of the syntax with your correct values):
data zzz;
set hivelib.table-name;
where variable = '';
run;
set hivelib.table-name;
where variable = '';
run;
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Hadoop | 64-bit Enabled AIX | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 |
| Microsoft® Windows® for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| HP-UX IPF | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Linux for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||
| Solaris for x64 | 9.45 | 9.46 | 9.4 TS1M5 | 9.4 TS1M6 | ||