Usage Note 63350: "Bulk load directory does not exist" and other errors occur when you use BULKLOAD=YES with SAS/ACCESS® Interface to Impala
 |  |  |  |
When using SAS/ACCESS Interface to Impala with bulk loading, you can receive the following error:
ERROR: java.io.EOFException: End of File Exception between local host is: "<server-name>/<IP-Address>"; destination
host is: "<server-name>":<port-number>; : java.io.EOFException; For more details see:
http://wiki.apache.org/hadoop/EOFException
ERROR: CLI execute error: bulk load directory '/tmp' does not exist
host is: "<server-name>":<port-number>; : java.io.EOFException; For more details see:
http://wiki.apache.org/hadoop/EOFException
ERROR: CLI execute error: bulk load directory '/tmp' does not exist
The problem occurs even when you have Write access to the directory and the directory exists. If you do not use bulk loading, the table is created.
The problem occurs because Impala bulk loading uses Hadoop Distributed File System (HDFS). On certain versions of Cloudera, there is a problem with this behavior that appears to be a Java classpath issue.
To circumvent the problem, make a copy of the core-site.xml file and move it into the SAS_HADOOP_JAR_PATH directory.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Impala | Windows 7 Enterprise x64 | 9.4 TS1M5 | |
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | |||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M5 | |||
| Microsoft Windows Server 2008 | 9.4 TS1M5 | |||
| Microsoft Windows 10 | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | |||
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | |||
| Microsoft® Windows® for x64 | 9.4 TS1M5 | |||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | |||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | |||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | |||
| Windows 7 Professional x64 | 9.4 TS1M5 | |||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | |||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | |||
| 64-bit Enabled AIX | 9.4 TS1M5 | |||
| Linux for x64 | 9.4 TS1M5 | |||
When using SAS/ACCESS Interface to Impala with bulk loading, you can receive errors that the HDFS directory does not exist and other errors.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2018-12-19 10:28:07 |
| Date Created: | 2018-12-10 10:07:13 |