If I create a covering index:
Definition
CREATE INDEX `covering_idx` ON `EON`(`marketCountry`,`catagory`,`severity`,`issue`,`createDate`,`createTime`,`status`,`parentJira`,`childrenJira`,`title`,`updateCtr`,`notifyUser`,`subcatagory`,`updateDate`,`updateTime`)
should I not be able to do:
SELECT * FROM EON
I also tried
SELECT marketCountry,catagory,severity,issue,createDate,createTime,status,parentJira,childrenJira,title,updateCtr,notifyUser,subcatagory,updateDate,updateTime FROM EON
The explain returns:
"errors": [
{
"code": 4000,
"msg": "No index available on keyspace EON 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": "explain SELECT marketCountry,catagory,severity,issue,createDate,createTime,status,parentJira,childrenJira,title,updateCtr,notifyUser,subcatagory,updateDate,updateTime FROM EON"
}
Am I missing something?
Thanks