Reply To: Compression for null string column

[eohara_kdb]

Thanks @rocuinneagain , will test.

FYI we’d also tested changing the type from string to symbol, the symbol column compresses at the same ratio as in your example

q)show c:count get`:eohara_dev/strCol
18809996
q)vals:sym?c#
q)sym

symbol$()
q)(

:eohara_dev/test;17;2;5)set vals

:eohara_dev/test
q)-21!

:eohara_dev/test
compressedLength | 257281
uncompressedLength| 150484064
algorithm | 2i
logicalBlockSize | 17i
zipLevel | 5i

q)150484064%257281
584.9016