Simple query using date_add

Plugins SQL
4

Thanks for bumping this @searchymcsearchface

As it turns out, AWS ES 7.9 has the “new SQL engine” disabled. Running the following seems to enable it and open up the world of date_functions which were born in 1.11.0 but “hidden” until 1.13.0 when the “new engine” was enabled by default.

PUT _opendistro/_sql/settings
{
  "transient" : {
    "opendistro.sql.engine.new.enabled" : "true"
  }
}

There was a bunch of digging that went into this one … and the keys came from here:

and eventually led me here:

of course YMMV but that’s what we’ve found and what we are going with.

1 Like