I m Creating Global secondary Indexes On some key of my document .
The index gets created and is visible on Indexes UI as ready but when I’m trying on query it shows No index is created.
Is it Possible to have secondary index working without creating Primary index?
August 29, 2017, 1:19pm
Post Index definition and query. Queries can work with secondary index alone without primary index. If the query can’t use secondary index and no primary index it will return error.
Create INDEX i1 ON
SELECT a2 FROM
ErrorLogs1 USE INDEX (i1);
“msg”: “No index available on keyspace ErrorLogs1 that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online.”,
“query_from_user”: “SELECT a2 FROM
ErrorLogs1 USE INDEX (i1);”
August 29, 2017, 1:23pm
Index selection is depends on WHERE clause. Try this
SELECT a2 FROM ErrorLogs1 USE INDEX (i1) WHERE a1 IS NOT MISSING;
Also check this out
So this means it is mandatory to use where clause when using Secondary Indexes?
August 29, 2017, 1:27pm
Thanks will definitely look into it.