IMSTAT Procedure
- Syntax
Procedure SyntaxPROC IMSTAT StatementBALANCE StatementCOLUMNINFO StatementCOMPUTE StatementDELETEROWS StatementDISTRIBUTIONINFO StatementDROPTABLE StatementFETCH StatementFREE StatementIMPORTCUBE StatementLIFETIME StatementNUMROWS StatementPARTITION StatementPARTITIONINFO StatementPROMOTE StatementPURGETEMPTABLES StatementREPLAY StatementSAVE StatementSCHEMA StatementSCORE StatementSERVERINFO StatementSERVERPARM StatementSERVERTERM StatementSERVERWAIT StatementSET StatementSTORE StatementTABLE StatementTABLEINFO StatementUPDATE StatementQUIT Statement - Overview
- Concepts
- Examples
SAVE Statement
The SAVE statement enables you to save an in-memory table to HDFS. The table must be the active table. You specify the active table with the DATA= option in the IMSTAT procedure or with the TABLE statement.
| Example: | Deleting Rows and Saving a Table to HDFS |
Syntax
Optional Arguments
BLOCKSIZE
specifies the block size to use for distributing the data set. Suffix values are B (bytes), K (kilobytes), M (megabytes), and G (gigabytes).
| Interaction | If the in-memory table is partitioned, the BLOCKSIZE= specification is ignored. The server determines the block size based on the size of the partitions. |
COPIES=n
specifies the number of replications to make for the data set (beyond the original blocks). The default value is 1. You can specify COPIES=0 if you do not need replications for redundancy.
FULLPATH
specifies that the value for the PATH= option specifies the full path for the file, including the filename (without the SASHDAT extension). The filename portion of the quoted string is expected to be in lowercase characters.
PATH='HDFS-path'
specifies the directory in HDFS in which to store the table as a SASHDAT file. The value is case sensitive. The filename for the SASHDAT file that is stored in the path is always lowercase.
REPLACE
specifies that the SASHDAT file should be overwritten if it already exists.
SAVE=table-name
saves the result table so that you can use it in other IMSTAT procedure statements like STORE, REPLAY, and FREE. The value for table-name must be unique within the scope of the procedure execution. The name of a table that has been freed with the FREE statement can be used again in subsequent SAVE= options.