The Ultimate Guide to High Availability with MariaDB

Comments - create table ... select, insert into ... select not working

5 years, 8 months ago Roman Nozdrin
Re: create table ... select, insert into ... select not working [Answer]

Greetings,

There are three operation modes for SELECTs in ColumnStore. One is the fastest, another we call it disabled vtable could be much slower. More information is here[1]. Complex SELECT queries used in INSERT..SELECT could be run in disabled vtable mode thus their execution time is unpredictable. There is a workaround this. You should use mcsmysql pipelining its output to cpimport. Something like this:

mcsmysql -e 'complex select query' | cpimport

CS will process the query in vtable mode then, not disabled vtable.

PS I would suggest to ask questions in the dedicated Google Group b/c you could get the answer faster.

1. https://mariadb.com/kb/en/library/columnstore-operating-mode/

 
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.