Problem Note 60080: SAS® In-Database Code Accelerator for Hadoop fails to drop tables in HDFS encryption zones
 |  |  |  |  |
When a table resides in a Hadoop Distributed File System (HDFS) encryption zone, the SAS In-Database Code Accelerator for Hadoop fails to properly drop tables. The error that you might encounter varies but can include the following text:
ERROR: Execute error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.MetaException(message:Unable to drop table because it is in an encryption zone and track is enabled. Use the PURGE option to skip trash.)
This issue occurs due to changes in the syntax requirements for the DROP TABLE statement.
You can circumvent this issue by disabling the TRASH setting on HDFS.
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 TS1M4 | 9.4 TS1M5 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows 10 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 R2 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2008 for x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Professional x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled AIX | 9.4 TS1M4 | 9.4 TS1M5 | ||
| 64-bit Enabled Solaris | 9.4 TS1M4 | 9.4 TS1M5 | ||
| HP-UX IPF | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Linux for x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
| Solaris for x64 | 9.4 TS1M4 | 9.4 TS1M5 | ||
A fix for this issue for SAS Threaded Kernel In-Database Supervisor 9.41_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A6X.html#60080| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-03-07 10:33:22 |
| Date Created: | 2017-03-03 11:51:27 |