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
... View more