Using DEFLATE instead of LZ4 for the table codec could also help.
The column store cannot be disabled yet on numeric values directly (open issue: Allow to disable column store on numeric data types (bigint, int, real, double precision) · Issue #11652 · crate/crate · GitHub)
However you can put numeric values in an OBJECT(IGNORED) to indirectly also disable it.