Impala to SAS incorrect numeric value

joker — Thu, 14 Feb 2019 10:54:22 GMT

Hello,

We are accessing Impala tables from SAS using the LIBNAME engine IMPALA.

I create table SAS table using the following code:

PROC SQL;

CREATE TABLE SASTABLE AS

SELECT * FROM IMPALA.TABLE

WHERE COL=123 ;

QUIT ;

The table SASTABLE contains one row. Ok

then I try access the created table using the following code:

PROC SQL ;

CREATE TABLE SASTABLE2 as SELECT * FROM SASTABLE

WHERE COL=123 ;

QUIT ;

The table SASTABLE2 does not contain any record.

I checked the content of the variable COL using an Hexadecimal and the value contains trailing digits "FF".

Have you ever faced this problem?

Thanks for your input

Re: Impala to SAS incorrect numeric value

ChrisNZ — Thu, 14 Feb 2019 21:30:03 GMT

What are the delimiters used in the Impala file?

>I checked the content of the variable COL using an Hexadecimal and the value contains trailing digits "FF".

How did you check this?