Query Error "no available engine for table ..." in the Analysis Engine
Error Messages
Error 9805 (HY000): no available engine for tables `tpch1000`.`lineitem`, You can get detail table sync status by `SHOW REPLICATION TABLES `tpch1000`.`lineitem`` [872454a1-63da-40b6-9674-9a730833529c]
Error Causes
Cause 1:
When the table is not fully loaded as a columnar storage table and the current status is Data Loading, querying this table will result in the above error. Wait until the table status changes to Real-Time Loading to perform queries normally.
Cause 2:
When the delay of the table object exceeds the set value of the libra_max_delay_allow_query parameter, querying this table will also result in the above error.