Exceed the maximal row size while creating table

[Karl-WangSK]

what do I need to set in prop when occurring
java.sql.SQLSyntaxErrorException: errCode = 2, detailMessage = The size of a row (157200) exceed the maximal row size: 100000

[morningman]

Currently, Doris only support a row with max length of 100KB.
You can add the config in fe.conf

max_layout_length_per_row=xxx

to configure this value, the default is 100000, unit is Byte.

And it may impact the performance, which we are not sure about it.

[Karl-WangSK]

Currently, Doris only support a row with max length of 100KB.
You can add the config in fe.conf

max_layout_length_per_row=xxx

to configure this value, the default is 100000, unit is Byte.

And it may impact the performance, which we are not sure about it.

Can I add this in PROPERTIES while creating table ? Or must be set in fe.conf?

[morningman]

Property is not supported yet, you have to set it in fe.conf, currently.

[Karl-WangSK]

Property is not supported yet, you have to set it in fe.conf, currently.

Thank you. I figured out.
Set this in clause.
ADMIN SET FRONTEND CONFIG ("fe_config_name" = "fe_config_value");