how to create table in sas work library into hadoop?

[Geo-]

I have a table in SAS work.mytable,how to create it into hadoop.this way will not work:

proc sql;
connect to hadoop(
server=xxx
user=sas
password=xxx
schema=xxx
subprotocol=hive2
hdfs_tempdir='/tmp/sastemp/'
properties=xxx
);
select * from connection to hadoop(
create table sas_card_tmp.test01 as
)
select * from work.mytable;
disconnect from hadoop;
quit;

[LinusH · Accepted solution]

Create table, PROC APPEND, PROC copy or data step writing to libname connection.