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?