In SAS^® Viya^® 3.3, Hive decimal values can change when loaded into CAS. For example, a decimal (10,0) value such as 1029136883 might become 9619071475 after it is loaded into CAS. You encounter this issue when you use the parallel data transfer mode of the SAS Data Connect Accelerator for Hadoop and the SAS Embedded Process for Hadoop. 

To work around the issue, load the table using the serial data transfer mode.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

Verify That the Update Is Installed

To verify that the fix is installed, run the following rpm command:

rpm -q sas-sepcorehadp

To complete this process, make sure that the package version that is shown in the rpm output either matches or is newer than the following:

sas-sepcorehadp-03.11.01-20180903.102646383099.x86_64

Note: After the fix is installed, you must update the SAS Embedded Process on your Hadoop cluster, using the appropriate method for your deployment.

If you deployed the SAS Embedded Process using Cloudera Manager or Ambari, complete these instructions:

1. Uninstall the previous version as described in the Cloudera Manager or Ambari sections of "Uninstall the SAS Embedded Process for SAS 9.4 or SAS Viya." 
2. Install the updated SAS Embedded Process as described in the Cloudera Manager or Ambari sections of "Deploy the SAS Embedded Process."

If you deployed the SAS Embedded Process manually, complete these instructions:

1. Copy the /opt/sas/viya/home/share/ep/sepcorehadphf-14.00000-1.sh file to the EPInstallDir/SASEPHome/hotfix directory in the Hadoop cluster. Create the hotfix directory within EPInstallDir/SASEPHome if it does not exist.
2. Run the following commands:

3. For further details, refer to the "Hadoop Deployment: Configuring SAS In-Database Technologies" section in the SAS^® Viya^® 3.3 for Linux: Deployment Guide. 

Additional Assistance

If you need additional assistance, contact SAS Technical Support.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Viya	Linux for x64	3.3

* 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.

---

An update for this issue is available for SAS Viya 3.3. For instructions on how to access and apply software updates, see the Managing Your Software section of the SAS Viya 3.3 Administration document at

http://documentation.sas.com/?softwareId=administration&softwareVersion=3.3&softwareContextId=softwareUpdates

---

Hive decimal values are changed when you load them into CAS. You encounter this issue when you use the parallel data transfer mode of the SAS Data Connect Accelerator for Hadoop and the SAS Embedded Process for Hadoop.

Type:	Problem Note
Priority:	high

Date Modified:	2018-11-13 16:02:57
Date Created:	2018-08-31 17:40:02