SQL code Compatibility: Migrating an Oracle RDS database to an Athena Trino Datalake
0
votes
1
answer
73
views
We are thinking of migrating an Oracle RDS database to Athena Trino Datalake.
We would keep all database names, schemas, tables, and columns the same.
Would SQL that runs correctly against the Oracle RDS database be 100% guaranteed to run correctly against the Athena Trina Datalake (with possible trivial differences, such as sorting-order for queries without ORDER BY)?
My guess is that it would not, though hopefully most such SQL would run correctly in both systems.
Asked by JosephDoggie
(203 rep)
Dec 8, 2021, 01:56 PM
Last activity: Sep 27, 2022, 03:59 PM
Last activity: Sep 27, 2022, 03:59 PM