W3cubDocs

/MariaDB

limit of number of columns

I have a table of 6MB with 50 values in the pivot-values leading to 50 columns in the pivoted table. That one works nicely.

I have another much larger table with 170MB and 121 columns. When creating the pivoted table I get an error:

SQL Fehler (1939): Engine CONNECT failed to discover table `abc`.`def` with 'CREATE TABLE whatever ...

The server runs on Win7 64Bit version 10.0.13

How can I create the pivoted table of the large table?

Answer Answered by Daniel Black in this comment.

the error sounds more like the table name is incorrect.

Alternately try the tracing documented here: loading-the-connect-storage-engine

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.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/limit-of-number-of-columns/