Need to load a variable as BIGINT to Hadoop

[lauracw4]

When I loaded an numeric ID variable to Hadoop using a simple data step, it went up as DOUBLE, adding a ".0".  This causes problems with joins.  What format should an ID be in when in SAS so that it will load up to Hadoop as BIGINT?

data had.hadoop_table;

set lib.sas_table;

run;

[kiranv_]

need to do something like below by using dbsastype

data had.hadoop_table;

set lib.sas_table (dbsastype= (name='char(20)'));

run;

please check this link for more info.

http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a001371572.htm