Impala to SAS incorrect numeric value

[joker]

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

[ChrisNZ]

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?