1 Resposta
- Mais recentes
- Mais votos
- Mais comentários
0
Athena version 2 is now deprecated. When Amazon Athena was initially launched, it used engine version 2. However, over time Amazon has made improvements and added new features to Athena that are only available in the newer engine version 3.
Some key differences between the two versions include:
- Version 3 supports newer file formats like ORC, Parquet and Apache Iceberg tables that version 2 did not support.
- The SQL syntax for time travel operations using SYSTEM_TIME and SYSTEM_VERSION clauses has changed to use TIMESTAMP AS OF and VERSION AS OF in version 3. This is causing the errors you mentioned in some of your existing queries.
- Version 3 includes performance improvements and scalability enhancements that make it more suitable for production use compared to the older version 2.
- While you can no longer downgrade a workgroup back to version 2, there are a few options to resolve the timestamp errors:
- Update the affected queries to use the new TIMESTAMP AS OF and VERSION AS OF syntax.