Information_schema CTAS error

Help
1

I want to use historical data from ‘information_schema’.
so, I create new database and tables;

create database info;
use info;
create table MV_EVENTS as select * from information_schema.MV_EVENTS;

ERROR 1146 ER_NO_SUCH_TABLE: Leaf Error (192.168.1.200:6614): Table ‘info_18._MV_EVENTS’ doesn’t exist

The above results occurred in 13 tables.

MV_ACTIVITIES_EXTENDED_CUMULATIVE
MV_BACKUP_STATUS
MV_BLOB_CACHE_EVENTS
MV_BT
MV_CACHED_BLOBS
MV_COLUMNSTORE_MERGE_STATUS
MV_EVENTS
MV_FINISHED_TASKS
MV_PLANCACHE
MV_PROCESSLIST
MV_REPLICATION_STATUS
MV_ROW_CHANGE_COUNTS
MV_TASKS

Please tell me why and how I can use it.

2

Thanks for reporting this. We’ve open a bug internally to track this issue.

-Adam

1 Like