topic Re: SAS numeric columns are read as double data type in HIVE in New SAS User

SAS numeric columns are read as double data type in HIVE

nagayamini — Mon, 05 Nov 2018 07:33:46 GMT

Hi,

I'm using SAS access to Hadoop and connecting to Hadoop engine using libname statement.

Whenever I'm creating table in HIVE, it's automatically reading all numeric values as double in HIVE.

This is causing decimal values in output tables.

For example, account_id has a 16 digit value (X) in source data, it's displaying as a decimal value X.0 in HIVE because of double data type.

Could someone help me how to read the columns as BIGINT in HIVE using create table query in SAS.

I tried defining column data type as BIGINT in create table statement but that gives me a syntax error, when I used INT instead, it resulted in double.

Both create table like and create table are reading as double in HIVE.

Please assist me in this regards.

Best Regards

Yamini

Re: SAS numeric columns are read as double data type in HIVE

Kurt_Bremser — Mon, 05 Nov 2018 07:40:54 GMT

SAS stores numbers in 8-byte real (floating) format, so that will be the default when writing to an external database.

Re: SAS numeric columns are read as double data type in HIVE

nagayamini — Mon, 05 Nov 2018 08:44:47 GMT

Dear Kurt,

Thanks for your response.

Since the users are not OK to see the decimal values in output table, please let me know if there's any other way to overwrite this default floating format from SAS end.

Appreciate your assistance on this.

Best Regards

Yamini