SAS:using sas to connect hadoop

[Geo-]

I am using example on:http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p0bodejpo614gxn1vk...
to using hive sql instead of sas sql

Use implicit pass-through SQL to extract only 10 rows from the newtab table and load the work SAS data set with the results.

proc sql;
connect to hadoop (server=hxpduped);
create table work.a as
select * from connection to hadoop (select * from newtab limit 10);

and the connection information is the case of our school,how should I write a right connection code in sas?

[ChrisNZ · Accepted solution]

If you already have the libname defined, just use it:

libname HAD001 hadoop ... ;

proc sql;
  connect using HAD001;

  create table A as select * from connection to HAD001 (select * from newtab limit 10);

quit;