Stream-Table joins using ksqldb

ksqlDB
1

image
image921×688 30.7 KB
- stream
I have 3 ktables named: HN_DEV_USCENTRAL1_AVRO_PRODUCT_HMS_CREATE - (primary key : SELLING_SKU),
HN_DEV_USCENTRAL1_AVRO_INVENTORY_HMS_CREATE (primary key : SELLING_SKU), , HN_DEV_USCENTRAL1_AVRO_PRODUCT_STATUS -(primary key : SKUID),
and 2 stream named HN_DEV_USCENTRAL_AVRO_PRODUCT_AEM_STATUS.

now if i want to join all these 4 then i am executing this script but its not working
: CREATE STREAM HN_DEV_USCENTRAL1_AVRO_COMBINED_PRODUCT_STATUS AS
SELECT p., i., ps., asp.
FROM HN_DEV_USCENTRAL_AVRO_PRODUCT_AEM_STATUS asp
LEFT JOIN HN_DEV_USCENTRAL1_AVRO_PRODUCT_HMS_CREATE p ON asp.SELLING_SKU = p.SELLING_SKU
LEFT JOIN HN_DEV_USCENTRAL1_AVRO_INVENTORY_HMS_CREATE i ON asp.SELLING_SKU = i.SELLING_SKU
LEFT JOIN HN_DEV_USCENTRAL1_AVRO_PRODUCT_STATUS ps ON asp.SKUID = ps.SKUID;

its not working, can anyone help on this

2

This topic was automatically closed after 30 days. New replies are no longer allowed.