We are running AES 7.9.
I submitted this query: SELECT adddate(curdate(), INTERVAL 1 DAY) FROM some-index* which is simpler than the query I need which is the use of dates and date functions in the where clause.
And received this error (note: adddate will work when applied to timestamp but not this embedded function call. I don’t see anything wrong any suggestions or recommendations)
: Bad Request, this query is not runnable.
“reason”: “Invalid SQL query”,