The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Derived Tables & Column Store

I have been having trouble with a stored procedure using derived tables joining to other column store tables and to innodb store tables. I have "SET infinidb_vtable_mode = 0;" prior to the SP call. I get "Table '/opt/tmp/#sql_7b29_0' is marked as crashed and should be repaired". After restart of the server the table name changes but the problem remains.

I couldn't find anything on this subject. Should I be able to use a derived table?

innodb_version = 5.7.20 version = 10.2.10-MariaDB-log version_comment = Columnstore 1.1.2-1

Answer Answered by David Thompson in this comment.

by derived tables do you mean: https://mariadb.com/kb/en/library/derived-table-merge-optimization/ ?

There are a lot of limitations with stored procedures and columnstore tables right now. It might be best if you can post an example.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.