Problem Note 62437: Bulk loading to Impala fails with an error when you specify the DSN= option in the LIBNAME statement
 |  |  |  |  |
Bulk loading with SAS/ACCESS® Interface to Impala fails with an error under the following conditions:
- You use a LIBNAME or CONNECT TO statement.
- The statement contains a DSN= option with BULKLOAD=YES.
Depending on the options that you use, the error that you receive might be similar to the following:
ERROR: Use of BULKLOAD=YES requires SERVER= on the LIBNAME statement or BL_HOST=.
ERROR: Invalid combination of connection options. You cannot use DSN with the SERVER or DATABASE options.
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 | SAS/ACCESS Interface to Impala | Microsoft® Windows® for x64 | 9.4 TS1M4 | |
| 64-bit Enabled AIX | 9.4 TS1M4 | |||
| Linux for x64 | 9.4 TS1M4 | |||
A fix for this issue for SAS/ACCESS Interface to Impala 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7E.html#62437A fix for this issue for SAS/ACCESS Interface to Impala 9.43 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B7D.html#62437A fix for this issue for SAS/ACCESS Interface to Impala 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z34.html#62437
When you bulk load with SAS/ACCESS® Interface to Impala, you might receive errors similar to the following: "ERROR: Use of BULKLOAD=YES requires SERVER= on the LIBNAME statement or BL_HOST=" or "ERROR: Invalid combination of connection options. You cannot use DSN with the SERVER or DATABASE option."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-06-19 09:39:27 |
| Date Created: | 2018-06-11 09:43:40 |