arroyo run
subcommand:
Running a query
A pipeline cluster runs a single SQL query, however that query may contain multiple independentINSERT INTO...SELECT
statements.
The query can be specified in one of three ways:
- Via STDIN:
- As a CLI argument:
- As an environment variable:
State
Arroyo is a stateful system, capable of consistently saving and restoring in-progress computations. For Pipeline clusters, that state can be stored on a local filesystem or on an object store. To learn more about the supported object stores and how to configure them, see the storage docs. For production deployments, it is recommended to always use an object store. The storage location is specified on the command line with the--state-dir
argument,
or via an environment variable with ARROYO__RUN__STATE_DIR
.
For example
--force
flag.