I am getting below error when i am trying to rename my table in singlestore .how to fix it?
ERROR 1945 ER_CANNOT_DROP_REFERENCED_BY_PIPELINE: Cannot rename table because it is referenced by pipeline
fdext
One of your pipeline in SingleStore is ingesting data into this table so you can not rename the table because the pipeline will try to insert data into the previous one. Unfortunately you can't alter pipeline to target a different table. So here is the sequence to do it :