v3.4 snappy compression

Community Support
1

Thought of playing around with the use of snappy compression in v3.4 on macOS

Installed snappy via brew

https://homebrew.bintray.com/bottles/snappy-1.1.3.el\_capitan.bottle.tar.gz

KDB+ 3.4 2016.10.27 Copyright (C) 1993-2016 Kx Systems

m32/ 4()core 8192MB ajay ajays-mbp.mynet 192.168.1.100 NONEXPIRE

q).z.zd:17 3 6

q)t:([]time:asc 10000000?.z.t; sym:10000000?`1;price:10000000?100f)

q).Q.dpft[`:.;.z.d;`sym;`t]

dlopen(libsnappy.dylib, 10): no suitable image found.  Did find:

/usr/local/lib/libsnappy.dylib: mach-o, but wrong architecturesnappy

I guess I need a 32bit version of snappy? Anyone got it working so far?

-Ajay

2

using macports:

bash-3.2$ sudo port install snappy +universal
bash-3.2$ export LD_LIBRARY_PATH=/opt/local/lib
bash-3.2$ q
KDB+ 3.4 2016.06.27 Copyright (C) 1993-2016 Kx Systems
m32/ 4()core 8192MB nick macbook-pro-5.local 192.168.0.8 NONEXPIRE 
q).z.zd:17 3 6
q)t:(time:asc 10000000?.z.t; sym:10000000?1;price:10000000?100f) q).Q.dpft[:.;.z.d;sym;t]

`t

q)-21!:2017.01.06/t/time compressedLength  | 39996717 uncompressedLength| 40000016 algorithm         | 3i logicalBlockSize  | 17i zipLevel          | 6i q)5#get :2017.01.06/t
sym time         price  

a   00:00:00.002 30.17723
a   00:00:00.011 37.5638
a   00:00:00.029 38.9056
a   00:00:00.070 64.30982
a   00:00:00.183 72.67987

3

Thanks Nick, that worked for me (although I am not a big fan of macports :))