Hi,
I am trying to combine two different tables with different columns (that has a common id column) with the below approach:
(SELECT id as "pID", CAST(Age as int) as "pAge", CAST(NULL as double) as "value" FROM t2045328DataLake.t2045328.inventory)
UNION (SELECT id as "pID", CAST(NULL as int) as "pAge", CAST("c8y_HRM.HR.value" as double) as "value" FROM t2045328DataLake.t2045328."measurements_c8y_HRM")
but it shows this error: Job ‘…x…’ output doesn’t exist
Can someone please advise on what to do?