OpenDistro SQL and internal indices

Plugins SQL
1

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
}
2

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

1 Like