{"api_version":2,"name":"piflow_execute_sql_stop","version":"2.0","description":"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.","icon":{"path":"M4 5h16v14H4zM8 9l3 3-3 3m5 0h4"},"inputs":{"source":{"representations":["records"],"formats":[]}},"parameters":{"type":"object","properties":{"viewName":{"type":"string","description":"Relation name used to expose the input to the query."},"sql":{"type":"string","description":"Read-only SQLite SELECT query."}},"required":["sql","viewName"],"additionalProperties":false},"execution":{"executor":"jvm","entrypoint":"xstream.examples.piflow.ExecuteSql","config":{}},"runtime":{"image":"sha256:23732819bf6777f314efc0454034fb8509caac9dc81b84538e52104274cb4af3","archive":{"sha256":"c2292f636d53fb70c0de30cf95b589b9eebd1d60c805465281a6980ff2889288","size":104964639,"filename":"jvm-arrow-2.1.tar.gz"}},"dependencies":{"provider":"jvm"},"source_public":true,"provenance":{"source_archive":{"sha256":"1d4417dceebd6e57671376f314aa7b69051173a826f3f8013aa77c016ee39676","size":13688,"filename":"execute_sql_stop-sources.zip"},"license":"Apache-2.0"},"artifact":{"sha256":"09d8e07835633d42259af6fabb4ced69aabc65180bec5a02aa34bb278d41e6d1","size":62509,"filename":"operator.jar"},"environment":{"fingerprint":"d274f059fe79c29e4719485f61aebf291bdf03dc7e1b92acfa788a1e7e8d66dd","image":"sha256:3449e5be70485e5bea7ee74a1e164b8c272ce597053ec9fb637ad1f94d82723c","archive":{"sha256":"9772a8410a7f0f615ad66d49d5aef4466cf95ed1c082c9b9f9c83742aa963598","size":120190464,"filename":"environment.tar"},"lock":{"provider":"jvm","version":1,"platform":"linux/amd64","files":[{"path":"jars/commons-codec-1.17.2.jar","sha256":"4148332728490cef12b29dac4c385f46982f04285132c6fa51ad7267d7dc7a8b"},{"path":"jars/commons-csv-1.13.0.jar","sha256":"648035ab973875787f3a12313cf239e86b51b4d209f91106ba90eba2fbd561cc"},{"path":"jars/commons-io-2.18.0.jar","sha256":"f3ca0f8d63c40e23a56d54101c60d5edee136b42d84bfb85bc7963093109cf8b"},{"path":"jars/sqlite-jdbc-3.49.1.0.jar","sha256":"5c8609d2ca341deb8c6f71778974b5ba4995c7d32d7c7c89d9392a3e72c39291"}],"coordinates":["org.apache.commons:commons-csv:1.13.0","org.xerial:sqlite-jdbc:3.49.1.0"]}},"categories":["Data transformation","SQL"],"documentation":{"inputs":{"source":"Input records to process."},"outputs":{"result":"Run a read-only SQLite analysis query over the input relation."},"parameters":{"viewName":{"description":"Relation name used to expose the input to the query.","help":"Use this same relation name in the FROM clause.","example":"observations"},"sql":{"description":"Read-only SQLite SELECT query.","help":"Reference viewName; use SELECT and explicitly cast text columns when numeric operations are needed.","example":"SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM observations GROUP BY station_id"}},"example_job":"name: Run a read-only SQLite analysis query over the input relation.\nsteps:\n- id: read_source\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/example/source.csv\n    view: records\n- id: process\n  operator: piflow_execute_sql_stop@2.0\n  inputs:\n    source: read_source\n  params:\n    viewName: observations\n    sql: SELECT station_id, AVG(CAST(temperature AS REAL)) AS mean_temperature FROM\n      observations GROUP BY station_id\n- id: receive_result\n  operator: client_sink@1.0\n  inputs:\n    result: process\n"},"role":"transform","type":"sdk","outputs":{"result":{"view":"records"}},"trust":{"score":4,"assessed_by":"administrator","reviewed_at_ms":1793612035272},"publication":{"author":"dacp-examples","submitted_at_ms":1793612008415,"approved_at_ms":1793612035272,"last_submitted_at_ms":1793612008415,"last_approved_at_ms":1793612035272},"download_count":4}