The following errors might occur in SAS Enterprise Guide when you attempt to read data from a Hive view.

How you handle this issue depends on which release of SAS/ACCESS® Interface to Hadoop you are running. If you are unsure, execute the SAS Installation Qualification Tool (SAS IQ) to determine the exact version that is installed at your site. The following example shows results for the 9.41 version of the SAS/ACCESS product.

              Host: lax
           Product: hadoop
           Version: 9.41
      Display Name: SAS/ACCESS Interface to Hadoop
   Display Version: 9.41

If you are running 9.41, proceed to the section "Workaround for SAS 9.41," below.

If you are running SAS^® 9.4 TS1M2, ship event 08w15 or later, and you encounter these errors, apply Hot Fix S64002.

Workaround for SAS 9.41

Which of the following workarounds you use depends on whether the Hadoop LIBNAME statement is configured to be pre-assigned in SAS^® Management Console.

• If the Hadoop LIBNAME statement is configured to be pre-assigned in SAS Management Console, add the following option to the sasv9_usermods.cfg file for your SAS Applications Server.
-set SAS_HADOOP_DISABLE_VIEW_OPTIMIZE "DISABLE"
• If it is not, then add the following option before the Hadoop LIBNAME statement.
  options set=SAS_HADOOP_DISABLE_VIEW_OPTIMIZE="DISABLE";

Note: Later, if you install the hot fix or migrate to a later release of SAS, you must remove this option.

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/ACCESS Interface to Hadoop	Microsoft Windows Server 2008 for x64	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2008 R2	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2012 Datacenter	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2012 R2 Datacenter	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2012 R2 Std	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2012 Std	9.4 TS1M1	9.4 TS1M3
		Windows 7 Enterprise 32 bit	9.4 TS1M1	9.4 TS1M3
		Windows 7 Enterprise x64	9.4 TS1M1	9.4 TS1M3
		Windows 7 Home Premium 32 bit	9.4 TS1M1	9.4 TS1M3
		Windows 7 Home Premium x64	9.4 TS1M1	9.4 TS1M3
		Windows 7 Professional 32 bit	9.4 TS1M1	9.4 TS1M3
		Windows 7 Professional x64	9.4 TS1M1	9.4 TS1M3
		Windows 7 Ultimate 32 bit	9.4 TS1M1	9.4 TS1M3
		Windows 7 Ultimate x64	9.4 TS1M1	9.4 TS1M3
		64-bit Enabled AIX	9.4 TS1M1	9.4 TS1M3
		64-bit Enabled Solaris	9.4 TS1M1	9.4 TS1M3
		HP-UX IPF	9.4 TS1M1	9.4 TS1M3
		Linux for x64	9.4 TS1M1	9.4 TS1M3
		Solaris for x64	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8.1 Enterprise 32-bit	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8 Pro x64	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8 Pro 32-bit	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8 Enterprise x64	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8 Enterprise 32-bit	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows Server 2008	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 10	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8.1 Pro 32-bit	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8.1 Pro	9.4 TS1M1	9.4 TS1M3
		Microsoft Windows 8.1 Enterprise x64	9.4 TS1M1	9.4 TS1M3
		Microsoft® Windows® for x64	9.4 TS1M1	9.4 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for this issue for SAS/ACCESS Interface to Hadoop 9.41 is available at:

A fix for this issue for SAS/ACCESS Interface to Hadoop 9.4_M2 is available at: