OpenDistro SQL and internal indices

I was wondering if there is a way to query internal indices (specifically, the internal users) using the SQL functionality.

I naively tried a “SELECT * FROM .opendistro_security” query, but received a ParserException that was unhappy with the dot in the index name:

  "error": {
    "reason": "Invalid SQL query",
    "details": "ERROR. token : DOT, pos : 15",
    "type": "ParserException"
  "status": 400

Hi @dquick, we have this fixed in PR #216, this change is available in OpenDistro Version > =

1 Like