2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
This seems like a bug or something. Kindly report it via support ticket for proper investigation and next steps.
répondu il y a 4 mois
0
Another strange thing about time data type. For example, this update query works fine (assuming install time is of type TIME):
UPDATE [dwh].[dim_app_installs]
SET
[install_time] = t.[servertime]::time
FROM [staging].[app_install] t
WHERE 1 = 1
AND [origin_id] = t.[id];
Also, this update query works fine:
UPDATE [dwh].[dim_app_installs]
SET
[install_time] = t.[servertime]
FROM [dwh].[dim_app_installs] d
JOIN [staging].[app_install] t ON d.[origin_id] = t.[id];
However, adding explicit cast to TIME to the query above is not working, while it worked in the first query just fine:
UPDATE [dwh].[dim_app_installs]
SET
[install_time] = t.[servertime]::time
FROM [dwh].[dim_app_installs] d
JOIN [staging].[app_install] t ON d.[origin_id] = t.[id];
ERROR: Target table must be part of an equijoin predicate.
Why is that so? All three queries are equivalent, i think.
répondu il y a 4 mois
Contenus pertinents
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a 2 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
Thank you! The support cases are submitted.