ColumnStore table does not exist after a rename

I had a simple ColumnStore table like shown below with simple 2 rows.
I ran the ALTER TABLE statement to rename the table and move the table from one database to another database. It ran successfully.
When I run count or any query on the new db.name it return an error like below.
I can see the .frm file has moved from dw_db to ds_db. Also, "show tables" list the table in ds_db.

CREATE TABLE dw_db.orders_test_cs (
orderkey INTEGER,
customer VARCHAR(45)
) ENGINE=ColumnStore;
INSERT INTO dw_db.orders_test_cs (orderkey, customer) VALUES
(12, 'JohnSmith'),
(13, 'John Public');

ALTER TABLE dw_db.orders_test_cs RENAME TO ds_db.orders_test_cs2;

select count from ds.orders_test_cs2;
ERROR 1815 (HY000): Internal error: MCS-2006: 'ds_db.orders_test_cs2' does not exist in Columnstore.