starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

[Bug] Cannot set sparcity on table with flat json enabled

Open brent-statsig opened this issue 1 month ago • 0 comments

Steps to reproduce the behavior (Required)

  • Create table
StarRocks > ALTER TABLE my_table SET ("flat_json.sparsity.factor" = "0.1");
ERROR 5064 (42000): Getting analyzing error. Detail message: Property flat_json.enable haven't been enabled.

I had to manually set enabled - then it could be updated. Flat JSON was already enabled on the table via global configuration.

StarRocks > ALTER TABLE my_table SET ("flat_json.enable" = "true");
Query OK, 0 rows affected (0.01 sec)

StarRocks > ALTER TABLE my_table SET ("flat_json.sparsity.factor" = "0.1");
Query OK, 0 rows affected (0.01 sec)

StarRocks version (Required)

v4.0.2

brent-statsig avatar Dec 10 '25 07:12 brent-statsig