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.

In the right pane, 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. The staging table 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.

Output and Staging Table Interactions

See Also