cc-index-table icon indicating copy to clipboard operation
cc-index-table copied to clipboard

Verify example queries using Athena engine v3

Open sebastian-nagel opened this issue 1 year ago • 0 comments

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.

sebastian-nagel avatar Feb 06 '23 17:02 sebastian-nagel