{"api_version":2,"name":"piflow_filter","version":"2.0","description":"Filter Arrow batches by a SQLite SQL predicate (not Spark SQL). Params: condition, e.g. quality = 0 AND temperature >= 12. Scalar columns only.","icon":{"path":"M3 4h18l-7 8v7l-4 2V12z"},"inputs":{"source":{"representations":["records"],"formats":[]}},"parameters":{"type":"object","properties":{"condition":{"type":"string","description":"SQLite SQL predicate applied to each record batch, e.g. quality = 0."}},"required":["condition"],"additionalProperties":false},"execution":{"executor":"jvm","entrypoint":"xstream.examples.piflow.Filter","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":"filter-sources.zip"},"license":"Apache-2.0"},"artifact":{"sha256":"c8039cc7bf98d81ce0e60ca5c1e88a5fa9e0b6db07f97d86615f6d423e86a674","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":"Keep records that satisfy the configured SQLite predicate."},"parameters":{"condition":{"description":"SQLite SQL predicate applied to each record batch, e.g. quality = 0.","help":"Use column names from the input; quote string literals and CAST string columns for numeric comparisons.","example":"quality = '0'"}},"example_job":"name: Keep records that satisfy the configured SQLite predicate.\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_filter@2.0\n  inputs:\n    source: read_source\n  params:\n    condition: quality = '0'\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":1793612007998},"publication":{"author":"dacp-examples","submitted_at_ms":1793611980031,"approved_at_ms":1793612007998,"last_submitted_at_ms":1793611980031,"last_approved_at_ms":1793612007998},"download_count":7}