How do i store data that is executed in pass through statement?

[WorkingMan]

Hi. I have a pass through statement to connect to hadoop server.

The code is as below:

proc sql;
   connect to hadoop (
      server="myserver" port=10000 schema=myschema);
execute
(
select * from `myschema`.`table1` wherecofee = 'mocha'
) by hadoop;
disconnect from hadoop;

QUIT;

If i want to store the result into a SAS work table or a proper SAS table with library, how do i do so?

[SASKiwi]

libname MySASLib "c:\MySASFolder";

proc sql;
   connect to hadoop (
      server="myserver" port=10000 schema=myschema);
create table MySASLib.MySASTable as
select * 
from connection to hadoop
(
select * from `myschema`.`table1` wherecofee = 'mocha'
);
disconnect from hadoop;

QUIT;