How do I increase the maximum number of columns per table?

CrateDB SQL
1

Hi

I’m new to crateDB and I’m trialing the product at the moment.

I have a requirement where our tables contain 1000-2000 columns but I’m hitting an upper limit of 1000 columns per table at the moment (see the error message below)…

SQLActionException[SQLParseException: Limit of total fields [1000] in index [mm.bm0000001] has been exceeded]

Is there a parameter I can modify to increase the number of columns per table?

Regards

Mark

2

You can adjust the max number of columns for a table with the
mapping.total_fields.limit parameter

Sets the maximum number of columns that is allowed for a table. Default is 1000 .

3

Thanks proddata

Much appreciated.

Mark