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.
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.

See Also

Working with SAS LASR Analytic Server
Copyright © SAS Institute Inc. All rights reserved.