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 SASHDAT 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 SASHDAT 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
Staging Table
Append Data
SAS or DBMS 1
None
Supported
SASHDAT
None
Not supported
Co-located HDFS or NFS-mounted MapR
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 2
SAS LASR Analytic Server
SASHDAT
Note: When the staging table is in SASHDAT, SAS LASR Analytic Server is the only choice for the output table.
Not supported
SAS LASR Analytic Server
Co-located HDFS or NFS-mounted MapR
Supported 2
1The SAS or DBMS value represents data stored in SAS data sets or a third-party vendor database, respectively.
2Appending 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 Append In-Memory Tables if you are working with in-memory tables on SAS LASR Analytic Server exclusively.