Could not delete existing index that not building yet


#1

there are two image those explain my issue



and for more details


how can I remove index that not building yet( and may not online)?
why i want do it, because it takes long time (regarding resource issue) and I’d like remove.
it and use view directly


#2

Looks like you’ve censored it (fair enough!) but have you specified a custom name for the Primary index? If so you would need to drop the index like any other (non-Primary) one, e.g.:
DROP INDEX `beer-sample`.`my_primary_index`

From the docs here:

Important: Named primary indexes that are created using CREATE PRIMARY INDEX, can only be dropped using the DROP INDEX command.


#3

Oooooop!
I could not believe that I made this very awful wrong.
you are right and that worked.
Thanks.