When you use SAS/ACCESS Interface to Impala, decimals might be truncated or might be displayed as integers. Here is an example that shows how to replicate the problem.

The results from this code show a value of 0 for the variable bigdecone instead of .0011. The problem occurs because Impala decimal fields are a new feature.

To circumvent the problem, complete the following steps:

1. Determine the length of the decimal field in the table by using the following code:
proc sql; connect to impala as sql1 (user=user-id password=password dsn=data-source-name); create table mytablecolumnstats as select * from connection to sql1 (show column stats table-name); quit; proc print data=mytablecolumnstats; title 'my column stats table-name'; run;
2. Use either a FORMAT function or a CAST function to set the length of the decimal field.
   
   For example, you can use a FORMAT function in a LIBNAME statement to set the variable to the correct length as shown below:
   
   libname test impala user=user-id password=password dsn=data-source-name; proc sql; select bigdecone format=5.4 from test.table-name; quit;
   Another option is to use the PRINT procedure with a FORMAT statement as shown in this example:
libname test impala user=user-id password=password dsn=data-source-name; proc print data=test.table-name; format bigdecone 5.4 ; run;
3. If you are using SQL pass-through, you must use a CAST function to recast the value as a float as shown below:
proc sql; connect to impala as sql1 (user=user-id password=password dsn=data-source-name); select * from connection to sql1 (select cast(bigdecone as float )from table-name); quit;

Operating System and Release Information