<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic how to create table in sas work library into hadoop? in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/how-to-create-table-in-sas-work-library-into-hadoop/m-p/507050#M136010</link>
    <description>&lt;P&gt;I have a table in SAS work.mytable,how to create it into hadoop.this way will not work:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;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;&lt;/CODE&gt;&lt;/PRE&gt;</description>
    <pubDate>Wed, 24 Oct 2018 02:08:14 GMT</pubDate>
    <dc:creator>Geo-</dc:creator>
    <dc:date>2018-10-24T02:08:14Z</dc:date>
    <item>
      <title>how to create table in sas work library into hadoop?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/how-to-create-table-in-sas-work-library-into-hadoop/m-p/507050#M136010</link>
      <description>&lt;P&gt;I have a table in SAS work.mytable,how to create it into hadoop.this way will not work:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;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;&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Wed, 24 Oct 2018 02:08:14 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/how-to-create-table-in-sas-work-library-into-hadoop/m-p/507050#M136010</guid>
      <dc:creator>Geo-</dc:creator>
      <dc:date>2018-10-24T02:08:14Z</dc:date>
    </item>
    <item>
      <title>Re: how to create table in sas work library into hadoop?</title>
      <link>https://communities.sas.com/t5/SAS-Programming/how-to-create-table-in-sas-work-library-into-hadoop/m-p/507058#M136013</link>
      <description>Create table,  PROC APPEND, PROC copy or data step writing to libname connection.</description>
      <pubDate>Wed, 24 Oct 2018 06:09:38 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/how-to-create-table-in-sas-work-library-into-hadoop/m-p/507058#M136013</guid>
      <dc:creator>LinusH</dc:creator>
      <dc:date>2018-10-24T06:09:38Z</dc:date>
    </item>
  </channel>
</rss>

