OPERATOR / VERSION 1.0

piflow_execute_sql_stop

Data processing · SQL

Read-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.

View manifest JSON ↗

Use this operator

operator: piflow_execute_sql_stop@1.0

Configure 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.