Querying Multiple Indices
Querying Multiple Indices
Multiple indices can be queried by executing a query using one of the following formats:
-
Query all indices via the _all view: SELECT * FROM [_all]
-
Query a list of indices: SELECT * FROM [index1,index2,index3]
-
Query indices matching a wildcard pattern: SELECT * FROM [index*]
Note, index lists can contain wildcards and indices can be excluded by prefixing an index with '-'. For example: SELECT * FROM [index*,-index3]