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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.