Hi Team
My Inputs for Stream Analytics Job:
Input 1: Stream Input from IoT Hub
Input 2: Reference Data from Azure Blob Storage
I am trying to use following query to join
stream input (deviceinput)
and reference input (refinputpdjson).
SELECT
din.deviceid as streamdeviceid,
din.heartrate as streamheartrate,
refin.deviceid as refdeviceid,
refin.patientid as refpatientid,
din.srcdatetime,
din.EventProcessedUtcTime
FROM
[asa-in-iot-healthcare-rpm] din
TIMESTAMP BY srcdatetime
JOIN
[asa-ref-in-patient-device-mapping] refin
ON refin.deviceid = din.deviceid
but its failing with following error:
The join predicate is not time bounded. JOIN operation between data streams requires specifying max time distances between matching events. Please add DATEDIFF to the JOIN condition. Example: SELECT input1.a, input2.b FROM input1 JOIN input2 ON DATEDIFF(minute, input1, input2) BETWEEN 0 AND 10
As per instruction on azure docs (https://video2.skills-academy.com/en-us/stream-analytics-query/reference-data-join-azure-stream-analytics) , I did follow the mentioned steps, but above error is coming.
I am not sure about this forum to post such issue or not. But, it will be great if anyone can help/direct us on this issue.