Output and Staging Table Interactions

The physical table is always replaced with the results of the data query. When you use a data query to append data and stage the data too, the staging table holds the data to append. As a result, the output table that the data query appends to is typically much larger than the staging table.
If you select the Compress data check box on the Outputs tab, then the tables are compressed as follows:
  • If the output table is in the SAS LASR Analytic Server library or SAS Data in HDFS library, then the output table is compressed.
  • If the output table is in the SAS LASR Analytic Server library and the staging table is in the SAS Data in HDFS library, then the staging table is compressed. It will automatically be compressed when it is loaded to memory on the SAS LASR Analytic Server.
The following table identifies the supported combinations for output tables and staging tables. In addition, whether you can append data to tables is indicated.
Output Table and Staging Table Interactions
Output Table
Staging Table
Append Data
SAS or DBMS 1
None
Supported
SAS Data in HDFS
None
Not supported
Teradata or Greenplum 2
None
Supported
SAS LASR Analytic Server
None
Supported
SAS or DBMS 1
SAS or DBMS 1
Supported
SAS LASR Analytic Server
SAS or DBMS 1
Supported 3
SAS LASR Analytic Server
SAS Data in HDFS
Note: When the staging table is in HDFS, SAS LASR Analytic Server is the only choice for the output table.
Not supported
SAS LASR Analytic Server
Teradata or Greenplum 2
Supported 3
1The SAS or DBMS value represents data stored in SAS data sets or a third-party vendor database, respectively.
2The Teradata or Greenplum value represents deployments that use a third-party vendor appliance as a co-located data provider for SAS LASR Analytic Server.
3Appending data is performed by the SAS LASR Analytic Server engine. Appends are not performed by having the server read data in parallel.
The information about appending data in the previous table applies to data queries. See Appending In-Memory Tables if you are working with in-memory tables on SAS LASR Analytic Server exclusively.