Problem Note 60979: The Load Data to LASR directive returns "ERROR:The SAS System stopped processing this step because of insufficient memory" when loading to a new table
 |  |  |  |  |
When you use the Load Data to LASR directive in SAS® Data Loader for Hadoop with the Hortonworks distribution of Hadoop, you can receive the following error:
ERROR: The SAS System stopped processing this step because of insufficient memory.
The error can be generated when the name of the target table for the Load Data to LASR directive is different from the Hadoop table name. You can see the following error in the SAS Data Loader for Hadoop log when tracing is enabled:
HADOOP: Streaming read CTAS error: Error while compiling statement:
FAILED: SemanticException 0:0 Error creating temporary folder on hdfs://directory_path.
Error encountered near token "token_name".
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 Data Loader for Hadoop | Microsoft® Windows® for x64 | 3.1 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 3.1 | 9.4 TS1M4 | ||||
| Microsoft Windows 8 Pro x64 | 3.1 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 3.1 | 9.4 TS1M4 | ||||
| Microsoft Windows 8.1 Pro x64 | 3.1 | 9.4 TS1M4 | ||||
A fix for this issue for SAS Data Loader Mid-Tier 3.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B3I.html#60979| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-10-18 10:46:57 |
| Date Created: | 2017-08-29 14:28:08 |