If you use SAS^® LASR™ Analytic Server with SAS^® Embedded Process to load data from Hadoop Hive, column values are set to zero. This issue occurs when the Hive table contains a DECIMAL column or FLOAT column.

Click the Full Code tab in this SAS Note to see an example of code that causes incorrect results to be reported in the SAS output window.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

libname hps hadoop DBCREATE_TABLE_OPTS="STORED AS ORC" 
	 port=10000 server="myhive.sas.com"
	 SUBPROTOCOL=HIVE2 DBMAX_TEXT=32000 SCHEMA=default PROPERTIES="hive.fetch.task.conversion=more;hive.fetch.task.conversion.threshold=-1";

proc datasets lib=hps nodetails nolist nowarn;
     delete HIVE_DECIMAL;
quit;

/* Create Hive table */
proc sql noprint;
     connect to HADOOP as hivesrc (SUBPROTOCOL=HIVE2 SERVER="myhive.sas.com" DBMAX_TEXT=32000 SCHEMA=default PROPERTIES="hive.fetch.task.conversion=more;hive.fetch.task.conversion.threshold=-1");
     execute (create table default.HIVE_DECIMAL (A varchar(10), B DECIMAL(2,0)) stored as orc) by hivesrc;
     execute (insert into default.HIVE_DECIMAL values("val1", 31)) by hivesrc;
     execute (insert into default.HIVE_DECIMAL values("val1", 42)) by hivesrc;
     disconnect from hivesrc;
quit;

proc print data=hps.HIVE_DECIMAL;
Title 'Hivetable';
run;

proc lasr add
data=hps.HIVE_DECIMAL
signer="http://myhive.sas.com:7980/SASLASRAuthorization"
port=10011; 
performance host="myhive.sas.com";
run;

 
libname LASRLIB meta library="Visual Analytics LASR" metaout=data;

proc print data=LASRLIB.HIVE_DECIMAL;
Title 'LASRTable';
run;

A fix for this issue for SAS In-Database for Hadoop on Linux 9.42 is available at: