Slide 34
Slide 34 text
Deployment from Script
CREATE TABLE order_shipments (
order_id INT,
order_time TIMESTAMP,
shipment_time TIMESTAMP,
day_diff INT,
PRIMARY KEY (order_id) NOT ENFORCED
)
WITH (
'connector' = 'upsert-kafka',
'key.format' = 'csv',
'properties.bootstrap.servers' = '...',
'topic' = 'order_shipmenst',
'value.format' = 'csv'
);
INSERT INTO order_shipments
SELECT
o.id AS order_id,
o.order_time,
s.shipment_time,
TIMESTAMPDIFF(
DAY,o.order_time,s.shipment_time
) AS day_diff
FROM orders o
JOIN shipments s ON o.id = s.order_id
WHERE
o.order_time
BETWEEN
s.shipment_time - INTERVAL '3' DAY
AND
s.shipment_time;
Sink table: