load
Table of Contents
Operator
load — add and commit data to a pool
Synopsis
load <pool>[@<branch>] [author <author>] [message <message>] [meta <meta>]
✵ Note ✵
The load operator is exclusively for working with pools in a
SuperDB data lake and is not available for use in
super.
Description
The load operator populates the specified <pool> with the values it
receives as input. Much like how super db load
is used at the command line to populate a pool with data from files, streams,
and URIs, the load operator is used to save query results from your SuperPipe
query to a pool in the same SuperDB data lake. <pool> is a string indicating the
name or ID of the destination pool.
If the optional @<branch> string is included then the data will be committed
to an existing branch of that name, otherwise the main branch is assumed.
The author, message, and meta strings may also be provided to further
describe the committed data, similar to the same super db load options.
Input Data
Examples below assume the existence of the SuperDB data lake created and populated by the following commands:
{flip:1,result:"heads"} {flip:2,result:"tails"}{flip:1,result:"heads"}
{flip:2,result:"tails"}Loading...The lake then contains the two pools:
Examples
Modify some values, load them into the main branch of our empty bigflips pool, and see what was loaded
from bigflipstrueLoading...Add a filtered subset of records to our onlytails branch, while also adding metadata
from coinflips@onlytailstrueLoading...