I try to retrieve a single value from a query using a macro, but I get empty results. I am working with Athena, Core version 1.7.10, Plugins: athena 1.7.2.
I tried to write a simple query like this: select ‘2020-01-01’ as max_date for testing, but I see that it just doesn’t work.
Is it something related to the Athena plugin version?