Important: | The semantics of this statement have changed significantly in this release fromPresto version 3.6. The version attribute identifies which semantics are used. For information on 3.6 semantics and the available attributes, see<loadfrom> for Presto 3.6. |
Can Contain | Empty |
Allowed In | mashup | catch | else | elseif | for | foreach | if | macro | operation | sequence | try | while |
Name | Required | Description | ||
version | The version of RAQL that is used in this statement. This version affects what attributes are required and the meaning of some attributes in <loadfrom>. Possible values are: 1.0 = the initial version of RAQL released in Presto 3.6. See <loadfrom> for Presto 3.6 for information on the available attributes when this version is in effect. 2.0 = the default. This is the current version of RAQL. | |||
cache | yes | The name of the In-Memory Store where the dataset to load resides.
For dynamic In-Memory Stores, this name is a simple string. For declared In-Memory Stores, this name is in the form data-source-name.store-name. See Declared Versus Dynamic
In-Memory Stores for more information. | ||
variable | yes | The name of the variable to hold the dataset or specific rows to retrieve. This variable must have been explicitly declared previously in the mashup. | ||
period | Defines an optional time period used to retrieve specific rows in the dataset based on their timestamp. Valid time periods include: ns = the last n seconds nm = the last n minutes nh = the last n hours nd = the last n days nw = the last n weeks n = with no period specified, this defaults to the last n minutes See Load Dataset Rows for Specific Time Periods for an example. | |||
fetchsize | The numbers of rows to request from the In-Memory Store at one time during loading. This can be used to fine tune performance with very large datasets or datasets with a large number of columns per row. |