cc-index-table
cc-index-table copied to clipboard
Verify example queries using Athena engine v3
The example queries below src/sql/examples/cc-index/ were developed using Athena engine v1 or v2. There might be issues when engine v3 (based on Trino instead of PrestoDb) is used. Eg. (num_pages/total_pages_host) >= .05
in one of the queries needs to be updated to (1.0*num_pages/total_pages_host) >= .05
(int/float cast).
Ideally, should run the queries against each of the engines and compare the results to verify that everything works as expected.