piflow_execute_sql_stop
Data transformation · 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@2.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@2.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.jar' 'https://repo.conox.cn/v1/blobs/sha256/09d8e07835633d42259af6fabb4ced69aabc65180bec5a02aa34bb278d41e6d1/operator.jar'
sha256sum -- 'operator.jar'
curl -fLo 'environment.tar' 'https://repo.conox.cn/v1/blobs/sha256/9772a8410a7f0f615ad66d49d5aef4466cf95ed1c082c9b9f9c83742aa963598/environment.tar'
sha256sum -- 'environment.tar'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.