{"api_version":2,"name":"piflow_join","version":"2.0","description":"Key-based inner/left/right/full_outer record join. Params: joinMode, correlationColumn. Colliding right non-key columns receive _right suffix. 128 MiB per input.","icon":{"path":"M14 12a5 5 0 1 1-10 0a5 5 0 1 1 10 0M20 12a5 5 0 1 1-10 0a5 5 0 1 1 10 0"},"inputs":{"left":{"representations":["records"],"formats":[]},"right":{"representations":["records"],"formats":[]}},"parameters":{"type":"object","properties":{"joinMode":{"type":"string","description":"Join semantics: inner, left, right, or full_outer.","enum":["inner","left","right","full_outer"]},"correlationColumn":{"type":"string","description":"Comma-separated join key column names."}},"required":["joinMode","correlationColumn"],"additionalProperties":false},"execution":{"executor":"jvm","entrypoint":"xstream.examples.piflow.Join","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":"ad1c265d1b37a53effab956925f3c9c69325a29327bb04225b0e8fb0a16b3cf7","size":13187,"filename":"join-sources.zip"},"license":"Apache-2.0"},"artifact":{"sha256":"9536e3a8c47a93fc65d4046072c2818f436915ce0183f338a757ccf5400a92e5","size":53269,"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","Relational"],"documentation":{"inputs":{"left":"First record stream; its key fields must match the right stream for joins.","right":"Second record stream, joined by key or appended after the first stream."},"outputs":{"result":"Join two record streams using the specified key columns and join mode."},"parameters":{"joinMode":{"description":"Join semantics: inner, left, right, or full_outer.","help":"Choose inner, left, right or full_outer according to which unmatched records should be retained.","example":"inner"},"correlationColumn":{"description":"Comma-separated join key column names.","help":"Provide matching field names present on both inputs, separated by commas.","example":"station_id"}},"example_job":"name: Join two record streams using the specified key columns and join mode.\nsteps:\n- id: read_left\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/example/left.csv\n    view: records\n- id: read_right\n  operator: item_source@1.0\n  inputs: {}\n  params:\n    uri: context:/example/right.csv\n    view: records\n- id: process\n  operator: piflow_join@2.0\n  inputs:\n    left: read_left\n    right: read_right\n  params:\n    joinMode: inner\n    correlationColumn: 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":1793612088625},"publication":{"author":"dacp-examples","submitted_at_ms":1793612063837,"approved_at_ms":1793612088625,"last_submitted_at_ms":1793612063837,"last_approved_at_ms":1793612088625},"download_count":6}