piflow_execute_sql_stop
Data processing · SQLRead-only SQLite SQL over a named input relation (not Spark SQL). Params: sql, viewName. Scalar inputs, max 128 MiB. Output types inferred; empty computed columns have null type.
Use this operator
operator: piflow_execute_sql_stop@1.0Configure remote_operator_library_urls with this repository’s origin. XStream verifies and caches artifacts by digest, sharing them across operators.
Named ports
- sourceInputrecords
Input records to process.
Formats: Any compatible format - resultOutputrecords
Run a read-only SQLite analysis query over the input relation.
Output structure and samples are provided by operator inference.
Parameters
- viewNamestringRequired
Relation name used to expose the input to the query.
- How to fill
- Use this same relation name in the FROM clause.
- Example value
- observations
- sqlstringRequired
Read-only SQLite SELECT query.
- How to fill
- Reference viewName; use SELECT and explicitly cast text columns when numeric operations are needed.
- Example value
- SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM observations GROUP BY station_id
Operator usage example
Connect the input ports to upstream steps and adjust the parameters for your data.
id: process
operator: piflow_execute_sql_stop@1.0
inputs:
source: read_source
params:
viewName: observations
sql: SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM
observations GROUP BY station_id
Manual download
curl -fLo 'operator.zip' 'https://repo.conox.cn/v1/blobs/sha256/e8ecb960b2363d87c880a88c9e53f88e114333c8cb814cbddee7bdf66653f313/operator.zip'
sha256sum -- 'operator.zip'Compare checksums with the manifest. Download execution and build environments from the runtime catalog ↗.
Source and licensing
See Source archive under Artifact details
- Source repository
- Source repository not provided
- Source revision
- Revision not declared
- License (publisher declared)
- Apache-2.0
- License text
- License text not provided
- Dependency SBOM
- Dependency SBOM not provided
Build instructions
Build instructions not provided
Publisher-provided source, licenses and dependency information support your review. Availability and checksums do not certify safety, legal clearance, or that the executable matches the source.