Problem Note 57121: As SAS® Embedded Process for Hadoop is shutting down, intermittent failures occur and various errors, warnings, and notes are returned
 |  |  |  |  |
You might experience intermittent failures with the SAS Embedded Process for Hadoop. The failures are caused by a timing issue during the shutdown. Messages similar to the following occur:
ERROR: Job job_1441204357106_0687 has failed. Please, see job log for details.
Job tracking URL : http://machine_name.com:8088/proxy/application_1441204357106_0687/
ERROR: General error org.apache.hive.service.cli.HiveSQLException: Error while compiling statement:
FAILED: SemanticException Line 1:17 Invalid path ''/tmp/sasds2_ck_tbo6ec1x_nv22a/sasds2ip_1757622927output'':
No files matching path hdfs://machine_name.com:8020/tmp/sasds2_
WARNING: Unable to Load Data directly into Hive Table.
A common cause of this issue is conflicting HDFS permissions between the data file and the Hive warehouse
directory for the table. Also, the 'sticky bit' may be set on the source directory or Load Data may be
unsupported. DS2 pass-through will instead attempt to use the slower INSERT INTO syntax.
NOTE: Execution succeeded. No rows affected. Error submitting a line of text to the asynchronous language service.
NOTE: DS2 query cancelled per user request.
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 In-Database Code Accelerator for Hadoop | Microsoft® Windows® for x64 | 9.4 TS1M3 | |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro | 9.4 TS1M3 | |||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M3 | |||
| Microsoft Windows Server 2012 Std | 9.4 TS1M3 | |||
| Windows 7 Enterprise 32 bit | 9.4 TS1M3 | |||
| Windows 7 Enterprise x64 | 9.4 TS1M3 | |||
| Windows 7 Home Premium 32 bit | 9.4 TS1M3 | |||
| Windows 7 Home Premium x64 | 9.4 TS1M3 | |||
| Windows 7 Professional 32 bit | 9.4 TS1M3 | |||
| Windows 7 Professional x64 | 9.4 TS1M3 | |||
| Windows 7 Ultimate 32 bit | 9.4 TS1M3 | |||
| Windows 7 Ultimate x64 | 9.4 TS1M3 | |||
| 64-bit Enabled AIX | 9.4 TS1M3 | |||
| 64-bit Enabled Solaris | 9.4 TS1M3 | |||
| HP-UX IPF | 9.4 TS1M3 | |||
| Linux for x64 | 9.4 TS1M3 | |||
| Solaris for x64 | 9.4 TS1M3 | |||
A fix for this issue for SAS In-Database for Hadoop on Linux 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/U47.html#57121| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-12-14 15:36:45 |
| Date Created: | 2015-11-19 16:40:21 |