segmented database with different date ranges

Community Support
1

/ How can I fix this? Thx.


quote:(time:(“p”$2016.06.01)+til 3; sym:AB`C; price:0.1*til 3);

quoteEnum:.Q.en[`:/tmp/hdb/head][quote];

.[`:/tmp/hdb/gamma/2016.06.01/gamma/; (); :; quoteEnum];

.[`:/tmp/hdb/delta/2016.06.02/delta/; (); :; quoteEnum];

`:/tmp/hdb/head/par.txt 0: (“/tmp/hdb/gamma”; “/tmp/hdb/delta”);

/ restart kdb

\l /tmp/hdb/head

2

after

\l /tmp/hdb/head

run

q).Q.chk[`:.]
:/tmp/hdb/delta/2016.06.02
:/tmp/hdb/gamma/2016.06.01

this will populate the missing tables

3

Personally I prefer .Q.bv.I fire it off on startup of some hdb procs nowYou can look at it tooOn Wed, Jun 01, 2016 at 8:14 AM, abcfoots > wrote:after\l /tmp/hdb/headrunq).Q.chk[:.]:/tmp/hdb/delta/2016.06.02:/tmp/hdb/gamma/2016.06.01this will populate the missing tablesOn Wednesday, June 1, 2016 at 1:47:29 AM UTC-4, Yan Yan wrote:/ How can I fix this? Thx.quote:([]time:("p"$2016.06.01)+til 3; sym:ABC; price:0.1*til 3);quoteEnum:.Q.en[:/tmp/hdb/head][quote];.[:/tmp/hdb/gamma/2016.06.01/gamma/; (); :; quoteEnum];.[:/tmp/hdb/delta/2016.06.02/delta/; (); :; quoteEnum];:/tmp/hdb/head/par.txt 0: (“/tmp/hdb/gamma”; “/tmp/hdb/delta”);/ restart kdb\l /tmp/hdb/head[https://lh3.googleusercontent.com/-kL1_GWxmSuQ/V052ro6tAoI/AAAAAAAAD-U/zcCv36jME4AD4dxiMYlY1g0MNto3iMfvwCLcB/s1600/20160601T134548.png]https:–

Submitted via Google Groups</https:>

4

.Q.chk[`:.] / worked. thx

.Q.bv / error as shown below

5

.Q.bv only for partitioned and not segmented db afaik

6

No ? it works fine on seg/part dbs.You need a patch which will be available in 3.4(2015.12.13). I?ve manually patched up my 3.3 for now as it is a very useful function.Full excerpt belowq)quote:(time:(“p”$2016.06.01)+til 3; sym:ABC; price:0.1*til 3);quoteEnum:.Q.en[:/tmp/hdb/head][quote];.[:/tmp/hdb/gamma/2016.06.01/gamma/; (); :; quoteEnum];q).[:/tmp/hdb/delta/2016.06.02/delta/; (); :; quoteEnum];:/tmp/hdb/head/par.txt 0: ("/tmp/hdb/gamma"; "/tmp/hdb/delta");/ restart kdbq)q)\l /tmp/hdb/headq)q)q)\adeltaquotequoteEnumq)select from deltak){0!(?).@[x;0;p1[;y;z]]}'/tmp/hdb/gamma/2016.06.01/delta/time: No such file or directory.?(+timesymprice!:/tmp/hdb/gamma/2016.06.01/delta;();0b;())q.Q))\q).Q.bvq)select from deltadate time sym price--------------------------------------------------2016.06.02 2016.06.01D00:00:00.000000000 A 02016.06.02 2016.06.01D00:00:00.000000001 B 0.12016.06.02 2016.06.01D00:00:00.000000002 C 0.2On Wed, Jun 01, 2016 at 11:11 AM, aka_magnus <niall.rea>> wrote:.Q.bv only for partitioned and not segmented db afaikOn Wednesday, June 1, 2016 at 9:18:14 AM UTC-4, Yan Yan wrote:.Q.chk[`:.] / worked. thx.Q.bv / error as shown below[https://lh3.googleusercontent.com/-dzO5OQhRVw0/V07gLBILOtI/AAAAAAAAD-k/w0AC0HdykOwDsR48YkA9F-B4Y79VGOEiwCLcB/s1600/20160601T211526-yani5.png]https:–

Submitted via Google Groups</https:></niall.rea>