kdb+ and q
Q+A on all things kdb+ database and the q language
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Loading large data into a splay table

I'm trying to understand what's going on in the code:.Q.fs[{ .[`:dir/trade/; (); ,; .Q.en[`:dir] flip colnames!("DFFFFIS";",")0:x]}]`:file.csvfrom:http://code.kx.com/wiki/Cookbook/LoadingFromLargeFilesAndSplaying1) My understanding is that the follow...

namit101 by New Contributor
  • 1 replies
  • 0 kudos

partitioned table loading error

I have a table partitioned on month that has a couple of text columns. It used to work well without any problem but today I got this error while trying to fetch a particular recordk){0!$[#.Q.pm;p3;(?).]@[x;0;p1[;y;z]]}'./2015.09/table1/data#: File ex...

R_1 by New Contributor
  • 0 replies
  • 0 kudos

Alternate approach

Hi,I am trying to learn q by creating different scripts. I am trying to solve below problem."If we list all the natural numbers below 10 that are multiples of 3 or 5, we get 3, 5, 6 and 9. The sum of these multiples is 23. Find the sum of all the mul...

N_V by New Contributor
  • 8 replies
  • 0 kudos

How could I clean up this query?

tab:([]time:"p"$til 6; sym:6#`A`B; price:0.1*til 6);ans1:([]sym:`A`B; price0:0 0.1; price1:0.2 0.3; price2:0.4 0.5);ans2:([]time:"p"$0 1; sym:`A`B; price0:0 0.1; price1:0.2 0.3; price2:0.4 0.5);`time`sym xcols(0!select first time by sym from tab)^(0!...

LamHinYan by New Contributor
  • 4 replies
  • 0 kudos