Usage Note 58253: "Error: Terminating Impala load" occurs when you use the bulk-load facility with SAS/ACCESS® Interface to Impala
 |  |  |  |
When you attempt to bulk load data while using SAS/ACCESS Interface to Impala, you might receive the following error:
ERROR: Error terminating Impala load: Unable to retrieve error message
The error occurs because the Impala bulk-load facility uses the Hadoop Distributed File System (HDFS) to accomplish its Write operations.
To resolve the problem, you or your administrator (see Note, below) should remove the sticky bit from the /tmp directory as shown here:
sudo -u hdfs hadoop fs -chmod o-t /tmp
Note: In most situations, removal of the sticky bit must be performed by the Impala administrator.
Programs run when using BULKLOAD=NO.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | Microsoft® Windows® for x64 | ||
| 64-bit Enabled AIX | ||||
| Linux for x64 | ||||
When using BULKLOAD=YES with SAS/ACCESS Interface to Impala, you might receive "Terminating Imapala load" errors. The problem occurs because the user does not have Write access to the /tmp directory.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2016-06-03 11:39:53 |
| Date Created: | 2016-05-20 12:44:43 |